数据库故障如下:SQL> startup
ORACLE instance started.Total System Global Area 101784276 bytes
Fixed Size 453332 bytes
Variable Size 75497472 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-00368: 重做日志块中的校验和错误
ORA-00353: 日志损坏接近块 3041 更改 343696241 时间 07/08/2004 11:23:19
ORA-00312: 联机日志 4 线程 1: 'O:\ORACLE\ORADATA\ORCL\REDOLOG4B.ORA'
ORA-00312: 联机日志 4 线程 1: 'O:\ORACLE\ORADATA\ORCL\REDOLOG4A.ORA'
后来用冷备份进行恢复,online 的内容丢失。现用logminer对redolog4a.ora 进行分析。SQL> exec dbms_logmnr.start_logmnr(dictfilename=>'D:\ora_online1\orcldict.ora',s
tartscn=>343628804, endscn=>343699804)PL/SQL procedure successfully completed.
SQL> create table aaaa as select * from v$logmnr_contents;
create table aaaa as select * from v$logmnr_contents
*
ERROR at line 1:
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 2913 change 343696239 time 07/08/2004 11:23
:19
ORA-00334: archived log: 'D:\ORA_ONLINE1\REDOLOG4A.ORA'对于online redo中的数据库坏块我该如何处理呢?
ORACLE instance started.Total System Global Area 101784276 bytes
Fixed Size 453332 bytes
Variable Size 75497472 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-00368: 重做日志块中的校验和错误
ORA-00353: 日志损坏接近块 3041 更改 343696241 时间 07/08/2004 11:23:19
ORA-00312: 联机日志 4 线程 1: 'O:\ORACLE\ORADATA\ORCL\REDOLOG4B.ORA'
ORA-00312: 联机日志 4 线程 1: 'O:\ORACLE\ORADATA\ORCL\REDOLOG4A.ORA'
后来用冷备份进行恢复,online 的内容丢失。现用logminer对redolog4a.ora 进行分析。SQL> exec dbms_logmnr.start_logmnr(dictfilename=>'D:\ora_online1\orcldict.ora',s
tartscn=>343628804, endscn=>343699804)PL/SQL procedure successfully completed.
SQL> create table aaaa as select * from v$logmnr_contents;
create table aaaa as select * from v$logmnr_contents
*
ERROR at line 1:
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 2913 change 343696239 time 07/08/2004 11:23
:19
ORA-00334: archived log: 'D:\ORA_ONLINE1\REDOLOG4A.ORA'对于online redo中的数据库坏块我该如何处理呢?
SQL> ALTER SYSTEM SET EVENTS '10231 trace name context forever,level 10'; 等日志切换到另外个日志,在把日志重新建立关闭断事件SQL> ALTER SYSTEM SET EVENTS '10231 trace name context off ';
我open不起来,后来恢复到最后一个archive log。现在我在测试库上想logmnr 故障时的redolog4a.ora,出现以上错误,我改怎样跳过坏块,发掘有用的sql。
ORACLE instance started.
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01041: internal error. hostdef extension doesn't exist现在不能open了