1. 首页
  2. IT资讯

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 droplogfile group 4; alter database add standby logfile group 4; alter database droplogfile group 5; alter database add standby logfile group 5; 主库执行alter system switch logfile;看备库的日志是否正常切换,查看alert日志文件,日志已经切换到redo04日志了,问题解决。

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

主题测试文章,只做测试使用。发布者:布吉卡,转转请注明出处:http://www.cxybcw.com/195503.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code