ITPub博客

首页 > 数据库 > Oracle > DG报错的处理

DG报错的处理

原创 Oracle 作者:zlingyi 时间:2015-04-20 14:19:20 0 删除 编辑
上周搭建了一个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博客 ” ,链接:https://blog.itpub.net/28686045/viewspace-1587036/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-12-22

  • 博文量
    76
  • 访问量
    117207