DG報錯的處理

zlingyi發表於2015-04-20
上週搭建了一個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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章