ITPub博客

首页 > 数据库 > Oracle > ORA-00312: online log 5 thread 1:误删standby log 日志组

ORA-00312: online log 5 thread 1:误删standby log 日志组

Oracle 作者:urgel_babay 时间:2016-02-29 17:29:34 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2016-02-29

  • 博文量
    203
  • 访问量
    215309