ORA-00312: online log 5 thread 1:誤刪standby log 日誌組

urgel_babay發表於2016-02-29
thread
2014.9.29

剛剛在做DG切換時，切換做了一半時，手賤把standby log 給rm -rf

本來是想刪掉group 5的，但是操作的順序搞錯了，先執行了rm
結果去SQLl裡面drop group 5的時候報錯

點選(此處)摺疊或開啟

  1. SQL> alter database drop logfile group 5;
  2. alter database drop logfile group 5
  3. *
  4. ERROR at line 1:
  5. ORA-00313: open failed for members of log group 5 of thread 1
  6. ORA-00312: online log 5 thread 1: \'/u01/app/oradata/standbylog/redo05b.log\'
  7. ORA-27037: unable to obtain file status
  8. Linux-x86_64 Error: 2: No such file or directory
  9. Additional information: 3
  10. ORA-00312: online log 5 thread 1: \'/u01/app/oradata/standbylog/redo05a.log\'
  11. ORA-27037: unable to obtain file status
  12. Linux-x86_64 Error: 2: No such file or directory
  13. Additional information: 3
日誌內容 alert.log：

點選(此處)摺疊或開啟

  1. Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_pr00_11168.trc:
  2. ORA-00315: log 5 of thread 1, wrong thread # 0 in header
  3. ORA-00312: online log 5 thread 1: \'/u01/app/oradata/standbylog/redo05b.log\'
  4. ORA-00315: log 5 of thread 1, wrong thread # 0 in header
  5. ORA-00312: online log 5 thread 1: \'/u01/app/oradata/standbylog/redo05a.log\'
  6. Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_pr00_11168.trc:
  7. ORA-00315: log 5 of thread 1, wrong thread # 0 in header
  8. ORA-00312: online log 5 thread 1: \'/u01/app/oradata/standbylog/redo05b.log\'
  9. ORA-00315: log 5 of thread 1, wrong thread # 0 in header
  10. ORA-00312: online log 5 thread 1: \'/u01/app/oradata/standbylog/redo05a.log\'
  11. Mon Sep 29 14:39:36 2014
  12. Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_pr00_11168.trc:
  13. ORA-00315: log 5 of thread 1, wrong thread # 0 in header
  14. ORA-00312: online log 5 thread 1: \'/u01/app/oradata/standbylog/redo05b.log\'
  15. ORA-00315: log 5 of thread 1, wrong thread # 0 in header
  16. ORA-00312: online log 5 thread 1: \'/u01/app/oradata/standbylog/redo05a.log\'
    17. 這裡說檔案頭有問題，是因為log 5的物理檔案已經不存在了。
在網上找了一些方法，單都不行。

最後在主庫中drop group 5
成功了！

同時在主庫中重建group 5.
接著shutdown備庫，
startup mount 備庫
應用歸檔，就可以了。
這是現在備庫的日誌

點選(此處)摺疊或開啟

  1. Completed: ALTER DATABASE MOUNT
  2. ARC3: Archival started
  3. ARC0: STARTING ARCH PROCESSES COMPLETE
  4. Mon Sep 29 14:52:48 2014
  5. Using STANDBY_ARCHIVE_DEST parameter default value as /u01/app/oradata/prod/archivelog
  6. Mon Sep 29 14:52:50 2014
  7. SRL log 4 needs clearing because log has not been created
  8. RFS[1]: Assigned to RFS process 11426
  9. RFS[1]: Selected log 6 for thread 1 sequence 16 dbid 271384494 branch 859556145
  10. Mon Sep 29 14:52:50 2014
  11. Primary database is in MAXIMUM PERFORMANCE mode
  12. Clearing online log 5 of thread 1 sequence number 0
  13. Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_arc3_11415.trc:
  14. ORA-00367: checksum error in log file header
  15. ORA-00315: log 5 of thread 1, wrong thread # 0 in header
  16. ORA-00312: online log 5 thread 1: \'/u01/app/oradata/standbylog/redo05a.log\'
  17. RFS[2]: Assigned to RFS process 11428
  18. RFS[2]: No standby redo logfiles available for thread 1
  19. Archived Log entry 32 added for thread 1 sequence 16 ID 0x102ccae0 dest 1:
  20. RFS[2]: No standby redo logfiles available for thread 1
  21. RFS[2]: Opened log for thread 1 sequence 17 dbid 271384494 branch 859556145
  22. Mon Sep 29 14:54:49 2014
  23. Archived Log entry 33 added for thread 1 sequence 17 rlc 859556145 ID 0x102ccae0 dest 2:
  24. SRL log 4 needs clearing because log has not been created
  25. RFS[2]: Selected log 5 for thread 1 sequence 18 dbid 271384494 branch 859556145
  26. Mon Sep 29 14:55:56 2014
  27. SRL log 4 needs clearing because log has not been created
  28. RFS[2]: Selected log 6 for thread 1 sequence 19 dbid 271384494 branch 859556145
  29. Mon Sep 29 14:55:56 2014
  30. Archived Log entry 34 added for thread 1 sequence 18 ID 0x102ccae0 dest 1:
  31. Mon Sep 29 14:57:23 2014
  32. RFS[2]: No standby redo logfiles available for thread 1
  33. RFS[2]: Opened log for thread 1 sequence 20 dbid 271384494 branch 859556145
  34. Mon Sep 29 14:57:23 2014
  35. Archived Log entry 35 added for thread 1 sequence 19 ID 0x102ccae0 dest 1:
  36. Mon Sep 29 14:59:01 2014
  37.  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION
  38. Attempt to start background Managed Standby Recovery process (prod)
  39. Mon Sep 29 14:59:01 2014
  40. MRP0 started with pid=27, OS id=11462
  41. MRP0: Background Managed Standby Recovery process started (prod)
  42.  started logmerger process
  43. Mon Sep 29 14:59:06 2014
  44. Managed Standby Recovery starting Real Time Apply
  45. Parallel Media Recovery started with 24 slaves
  46. Waiting for all non-current ORLs to be archived...
  47. All non-current ORLs have been archived.
  48. Media Recovery Log /u01/app/oradata/prod/archivelog/1_16_859556145.dbf
  49. Media Recovery Log /u01/app/oradata/prod/archivelog/1_17_859556145.dbf
  50. Media Recovery Log /u01/app/oradata/prod/archivelog/1_18_859556145.dbf
  51. Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION
  52. Media Recovery Log /u01/app/oradata/prod/archivelog/1_19_859556145.dbf
  53. Recovery created file /u01/app/oradata/prod/prod/tt.dbf
  54. Successfully added datafile 6 to media recovery
  55. Datafile #6: \'/u01/app/oradata/prod/prod/tt.dbf\'
  56. Media Recovery Waiting for thread 1 sequence 20 (in transit)

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/30936525/viewspace-2016712/，如需轉載，請註明出處，否則將追究法律責任。

相關文章