DG报错的处理

上周搭建了一个DG，数据正常传递过来并应用，但是查看alert日志有个报错经常出现
ORA-00312: online log 5 thread 0: '/u01/app/oracle/oradata/LRWLDB/redo05.log'
ORA-00315: log 5 of thread 0
ORA-00367: checksum error in log file header
/u01/app/oracle/diag/rdbms/lrwldbdg/LRWLDBDG/trace/LRWLDBDG_rfs_20079.trc
查看该文件的具体报错信息
*** 2015-04-20 09:06:34.462
RFS[1]: Archival completed for log 6 thread 1 sequence 7088 dbid 377098956 branch 847026510
DDE rules only execution for: ORA 312
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
Successfully dispatched
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----
SRL log 4 needs clearing because log has not been created
ORA-00367: checksum error in log file header
ORA-00315: log 4 of thread 0, wrong thread # 1 in header
ORA-00312: online log 4 thread 0: '/u01/app/oracle/oradata/LRWLDB/redo04.log'
DDE: Problem Key 'ORA 312' was flood controlled (0x5) (no incident)
ORA-00312: online log 5 thread 0: '/u01/app/oracle/oradata/LRWLDB/redo05.log'
SRL log 5 needs clearing because log has not been created
ORA-00367: checksum error in log file header
ORA-00315: log 5 of thread 0, wrong thread # 1 in header
ORA-00312: online log 5 thread 0: '/u01/app/oracle/oradata/LRWLDB/redo05.log'

猜测是redo04和redo05 standby log有问题，于是
alter database drop  logfile group 4;
alter database add standby logfile group 4;
alter database drop  logfile group 5;
alter database add standby logfile group 5;
主库执行alter system switch logfile;看备库的日志是否正常切换，查看alert日志文件，日志已经切换到redo04日志了，问题解决。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28686045/viewspace-1587036/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28686045/viewspace-1587036/