ORA-01578: ORACLE data block corrupted (file # 3, block # 1675)
警告日志中发现如下报错信息：
ORA-01578: ORACLE data block corrupted (file # 3, block # 1675)
ORA-01110: data file 3: '/u01/app/oracle/oradata/PROD1/undotbs01.dbf'
报错提示为：undo表空间第1675个数据块出现损坏。
解决方法：
1、创建新的undo表空间undotbs2
SQL> create undo tablespace UNDOTBS2 datafile '/u01/app/oracle/oradata/PROD1/undotbs02.dbf' size 295M;
Tablespace created.
2、修改数据库undo表空间为undotbs2
SQL> alter system set undo_tablespace = undotbs2 scope=spfile;
System altered.
3、重启数据库
SQL> startup force
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1348244 bytes
Variable Size 524291436 bytes
Database Buffers 318767104 bytes
Redo Buffers 5124096 bytes
Database mounted.
Database opened.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 5400
undo_tablespace string UNDOTBS2
4、删掉undotbs1表空间及数据文件
SQL> Drop tablespace UNDOTBS1 including contents and datafiles;
Tablespace dropped.
5、重新创建undotbs1表空间
SQL> create undo tablespace UNDOTBS1 datafile '/u01/app/oracle/oradata/PROD1/undotbs01.dbf' size 295M;
Tablespace created.
6、修改数据库undo表空间为undotbs1
SQL> alter system set undo_tablespace=undotbs1 scope=spfile;
System altered.
7、重启数据库
SQL> startup force
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1348244 bytes
Variable Size 524291436 bytes
Database Buffers 318767104 bytes
Redo Buffers 5124096 bytes
Database mounted.
Database opened.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 5400
undo_tablespace string UNDOTBS1
8、删掉undotbs2表空间
SQL> Drop tablespace UNDOTBS2 including contents and datafiles;
Tablespace dropped.
问题解决。
2019-2-26 5:35
最新文章
- linux下安装nodejs
- POJ 3250 Bad Hair Day --单调栈(单调队列?)
- SPRING IN ACTION 第4版笔记-第四章ASPECT-ORIENTED SPRING-003-Spring对AOP支持情况的介绍
- NDK安装 eclipse 不出现NDK目录问题
- JQuery 左右拖动插件
- 当fixed元素相互嵌套时chrome下父元素会影响子元素的层叠关系
- RequireJS进阶（三）
- 阻碍android程序员发展的几个原因
- Html表格<table>还是须要加入一些标签进行优化，能够加入标题<caption>和摘要<table summary>
- Oracle的用户，权限以及角色
- java获取客户端ip地址工具类
- thingsboard改造使用mysql数据库
- H5 颜色属性
- Android 模块化/热修复/插件化 框架选用
- XmlDocument.Load(url) url是https远程时，报错" 基础连接已经关闭: 未能为 SSL/TLS 安全通道建立信任关系。" "根据验证过程，远程证书无效。"
- C# ACtiveMQ 收发数据
- git 子模块
- 【ORACLE】oracle数据库用户密码复杂度配置
- http://www.gasi.ch/blog/inside-deep-zoom-2/
- connectedSignal 简单使用