2014.9.29

刚刚在做DG切换时，切换做了一半时，手贱把standby log 给rm -rf

本来是想删掉group 5的，但是操作的顺序搞错了，先执行了rm
结果去SQLl里面drop group 5的时候报错

点击(此处)折叠或打开

SQL> alter database drop logfile group 5;
alter database drop logfile group 5
*
ERROR at line 1:
ORA-00313: open failed for members of log group 5 of thread 1
ORA-00312: online log 5 thread 1: \'/u01/app/oradata/standbylog/redo05b.log\'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 5 thread 1: \'/u01/app/oradata/standbylog/redo05a.log\'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

日志内容 alert.log：

点击(此处)折叠或打开

Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_pr00_11168.trc:
ORA-00315: log 5 of thread 1, wrong thread # 0 in header
ORA-00312: online log 5 thread 1: \'/u01/app/oradata/standbylog/redo05b.log\'
ORA-00315: log 5 of thread 1, wrong thread # 0 in header
ORA-00312: online log 5 thread 1: \'/u01/app/oradata/standbylog/redo05a.log\'
Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_pr00_11168.trc:
ORA-00315: log 5 of thread 1, wrong thread # 0 in header
ORA-00312: online log 5 thread 1: \'/u01/app/oradata/standbylog/redo05b.log\'
ORA-00315: log 5 of thread 1, wrong thread # 0 in header
ORA-00312: online log 5 thread 1: \'/u01/app/oradata/standbylog/redo05a.log\'
Mon Sep 29 14:39:36 2014
Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_pr00_11168.trc:
ORA-00315: log 5 of thread 1, wrong thread # 0 in header
ORA-00312: online log 5 thread 1: \'/u01/app/oradata/standbylog/redo05b.log\'
ORA-00315: log 5 of thread 1, wrong thread # 0 in header
ORA-00312: online log 5 thread 1: \'/u01/app/oradata/standbylog/redo05a.log\'

在网上找了一些方法，单都不行。

最后在主库中drop group 5
成功了！

同时在主库中重建group 5.
接着shutdown备库，
startup mount 备库
应用归档，就可以了。
这是现在备库的日志

点击(此处)折叠或打开

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

ITPub博客

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

最新文章