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日誌了,問題解決。
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle 跨小版本dg切換應用補丁報錯處理Oracle
- rails gem報錯的處理AI
- oracle dg報錯Oracle
- Extjs報錯處理JS
- errpt報錯處理
- Gulp壓縮報錯處理
- Javascript程式碼報錯處理JavaScript
- 各種報錯處理方法
- 批處理的聊天程式報錯求救!!!!!
- 【DG】 DataGuard 中處理archive gap的方法Hive
- DG發現gap處理流程
- Too many open files報錯處理
- Mysql自動處理同步報錯MySql
- yum groupinstall報錯,處理方法
- ORA-02429 報錯處理
- mysql複製報錯案例處理MySql
- RMAN Duplicate FROM ACTIVE DATABASE 建物理DG還原檔案期間報錯ORA-17629處理Database
- 遇上DG挖礦病毒的處理記錄
- 物理DG與邏輯DG的區別與邏輯DG同步異常處理方法
- Python 入門級報錯處理Python
- Oracle 11g R2 DG 備庫啟動報錯,需要恢復日誌處理措施Oracle
- 記一次dg故障的處理總結
- 一次歸檔報錯的處理和分析
- 處理動態連結庫報錯的問題
- oracle ORA-01940 報錯的處理方法Oracle
- Oracle DG同步失敗故障處理(二)Oracle
- 不明原因的約束報錯的兩種處理方式
- 線上MYSQL同步報錯故障處理總結MySql
- ORA-1654報錯處理一則
- ORA-00979: not a GROUP BY expression報錯處理Express
- 匯入專案@override 報錯處理IDE
- EBS服務啟動報錯基本處理
- pl/sql developer除錯儲存過程報錯處理SQLDeveloper除錯儲存過程
- 在使用 zabbix 4 時, orabbix 會報錯的處理方法
- ORA 12592的報錯處理及補丁更新
- 【ORACLE】ORA-27102: out of memory報錯的處理Oracle
- SQLite.dll在xp中部署時的報錯處理SQLite
- asm管理的dg資料檔案缺失的處理方法ASM