**恢复备库控制文件的报错问题分析（ORA-00313）** **在备库此时存在如下参数时的情况：** ``` db_file_name_convert =/oracle/app/oradata/proddg2, /oracle/app/oradata/prod log_file_name_convert=/oracle/app/oradata/proddg2, /oracle/app/oradata/prod ``` **恢复备库的控制文件：** ``` RMAN> restore controlfile from '/home/oracle/rman/standby.ctl'; SQL> alter database mount; Database altered. ``` **此时警告日志会出现很多这种错误：** ``` Errors in file /oracle/app/diag/rdbms/prod/prod/trace/prod_arc3_4119.trc: ORA-00313: open failed for members of log group 4 of thread 1 ORA-00312: online log 4 thread 1: '/oracle/app/oradata/prod/std_redo04.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory ``` **查看数据文件与日志文件信息：** ``` SQL> select name from v$datafile; //数据文件路径会根据db_file_name_convert转化 **NAME** /oracle/app/oradata/prod/system01.dbf /oracle/app/oradata/prod/sysaux01.dbf /oracle/app/oradata/prod/undotbs01.dbf /oracle/app/oradata/prod/users01.dbf /oracle/app/oradata/prod/example01.dbf SQL> select member from v$logfile; //日志文件路径会根据log_file_name_convert转化 MEMBER /oracle/app/oradata/prod/redo03.log /oracle/app/oradata/prod/redo02.log /oracle/app/oradata/prod/redo01.log /oracle/app/oradata/prod/std_redo04.log /oracle/app/oradata/prod/std_redo05.log /oracle/app/oradata/prod/std_redo06.log ``` **再直接使用RMAN执行restore database即可。** ``` RMAN> restore database; ``` **开启主库的日志传输：** ``` SQL> alter system set log_archive_dest_state_2=enable scope=both; ``` 观察备库警告日志： ``` Errors in file /oracle/app/diag/rdbms/prod/prod/trace/prod_rfs_4169.trc: ORA-00313: open failed for members of log group 4 of thread 1 ORA-00312: online log 4 thread 1: '/oracle/app/oradata/prod/std_redo04.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 **SRL log 4 needs clearing because log has not been created** ..... Clearing online log 4 of thread 1 sequence number 0 Errors in file /oracle/app/diag/rdbms/prod/prod/trace/prod_arc3_4119.trc: ORA-00313: open failed for members of log group 4 of thread 1 ORA-00312: online log 4 thread 1: '/oracle/app/oradata/prod/std_redo04.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory ``` **Clearing online log 4 of thread 1 sequence number 0** **等等standbylog不存在的错误，但也可以看出Oracle会自动进行clearing操作，备库会根据控制文件自动创建出standbylog：** **日志组clearing介绍：** ``` 常用于当日志文件丢失时使用，丢失的日志组必须为inactive。 也可以手动执行clearing： --清理日志组即可，oracle会自动创建新的日志文件出来，状态为unused SYS@orcl11g> alter database clear logfile group 1; SYS@orcl11g> alter database clear logfile group 3; ``` ``` [oracle@dgpridb prod]$ ll total 2081760 -rw-r----- 1 oracle oinstall 10043392 Aug 25 06:40 control01.ctl -rw-r----- 1 oracle oinstall 10043392 Aug 25 06:40 control02.ctl -rw-r----- 1 oracle oinstall 355213312 Aug 25 06:33 example01.dbf -rw-r----- 1 oracle oinstall 104858112 Aug 25 06:40 std_redo04.log -rw-r----- 1 oracle oinstall 104858112 Aug 25 06:40 std_redo05.log -rw-r----- 1 oracle oinstall 104858112 Aug 25 06:40 std_redo06.log -rw-r----- 1 oracle oinstall 555753472 Aug 25 06:34 sysaux01.dbf -rw-r----- 1 oracle oinstall 786440192 Aug 25 06:35 system01.dbf -rw-r----- 1 oracle oinstall 94380032 Aug 25 06:31 undotbs01.dbf -rw-r----- 1 oracle oinstall 5251072 Aug 25 06:31 users01.dbf ``` **但为什么redo log却没有自动创建，redo会什么时候创建呢** **此时开启日志应用服务：** ``` alter database recover managed standby database disconnect from session; ``` **观察警告日志：** ``` **Clearing online redo logfile 3 /oracle/app/oradata/prod/redo03.log** Clearing online log 3 of thread 1 sequence number 83 Errors in file /oracle/app/diag/rdbms/prod/prod/trace/prod_mrp0_4199.trc: ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: '/oracle/app/oradata/prod/redo03.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /oracle/app/diag/rdbms/prod/prod/trace/prod_mrp0_4199.trc: ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: '/oracle/app/oradata/prod/redo03.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 **Clearing online redo logfile 3 complete** Media Recovery Log /oracle/app/arch/prod1_78_1046156085.dbf Media Recovery Log /oracle/app/arch/prod1_79_1046156085.dbf Media Recovery Log /oracle/app/arch/prod1_80_1046156085.dbf Media Recovery Log /oracle/app/arch/prod1_81_1046156085.dbf Media Recovery Log /oracle/app/arch/prod1_82_1046156085.dbf Media Recovery Log /oracle/app/arch/prod1_83_1046156085.dbf Media Recovery Waiting for thread 1 sequence 84 (in transit) ``` **Clearing online log 3 of thread 1 sequence number 83** **日志正常应用了，并且也发现redo不存在的错误，并且数据库自动进行了clearing，自动创建新的日志组。** ``` [oracle@dgpridb prod]$ ll redo* -rw-r----- 1 oracle oinstall 52429312 Aug 25 06:42 redo01.log -rw-r----- 1 oracle oinstall 52429312 Aug 25 06:42 redo02.log -rw-r----- 1 oracle oinstall 52429312 Aug 25 06:42 redo03.log ``` **总结：** 我这边是在主库创建了standby redolog，所以备库控制文件中也存在standby redolog，Oracle会自动执行clearing创建standby redolog，如果没有在主库创建standby redolog，那么就需要在备库mount状态时进行创建standby redolog，也可以不创建，如果不在备库创建standby redolog，备库会虚拟几组standby redollog。 **当不在主库创建standby redolog时的情况：** **恢复备库的控制文件：** ``` db_file_name_convert =/oracle/app/oradata/proddg2, /oracle/app/oradata/prod log_file_name_convert=/oracle/app/oradata/proddg2, /oracle/app/oradata/prod ``` ``` RMAN> restore controlfile from '/home/oracle/rman/standby.ctl'; SQL> alter database mount; Database altered. ``` **备库控制文件中记录的日志组信息，不存在standby redolog** ``` SQL> select member from v$logfile; MEMBER /oracle/app/oradata/prod/redo03.log /oracle/app/oradata/prod/redo02.log /oracle/app/oradata/prod/redo01.log RMAN> restore database; ``` **开启主库日志传输并跟踪警告日志：** ``` RFS[4]: Assigned to RFS process 4492 RFS[4]: No standby redo logfiles created RFS[4]: Opened log for thread 1 sequence 86 dbid 457994418 branch 1046156085 ``` **在主库执行日志切换：** ``` RFS[4]: No standby redo logfiles created RFS[4]: Opened log for thread 1 sequence 87 dbid 457994418 branch 1046156085 Archived Log entry 10 added for thread 1 sequence 87 rlc 1046156085 ID 0x1b70d452 dest 2: RFS[4]: No standby redo logfiles created RFS[4]: Opened log for thread 1 sequence 88 dbid 457994418 branch 1046156085 ``` **每接收一个日志就会出现RFS[4]: No standby redo logfiles created。** **（注意如果不在备库创建standby redo，主库alert日志中没有明显的日志传输信息）** **此时备库开启日志应用，检查是否可以正常应用** ``` SQL> alter database recover managed standby database disconnect from session; Clearing online redo logfile 3 /oracle/app/oradata/prod/redo03.log Clearing online log 3 of thread 1 sequence number 86 Errors in file /oracle/app/diag/rdbms/prod/prod/trace/prod_mrp0_4505.trc: ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: '/oracle/app/oradata/prod/redo03.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /oracle/app/diag/rdbms/prod/prod/trace/prod_mrp0_4505.trc: ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: '/oracle/app/oradata/prod/redo03.log' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Clearing online redo logfile 3 complete Clearing online redo logfile 3 complete Media Recovery Log /oracle/app/arch/prod1_78_1046156085.dbf Media Recovery Log /oracle/app/arch/prod1_79_1046156085.dbf Media Recovery Log /oracle/app/arch/prod1_80_1046156085.dbf Media Recovery Log /oracle/app/arch/prod1_81_1046156085.dbf Media Recovery Log /oracle/app/arch/prod1_82_1046156085.dbf Media Recovery Log /oracle/app/arch/prod1_83_1046156085.dbf Media Recovery Log /oracle/app/arch/prod1_84_1046156085.dbf Media Recovery Log /oracle/app/arch/prod1_85_1046156085.dbf Media Recovery Log /oracle/app/arch/prod1_86_1046156085.dbf Media Recovery Log /oracle/app/arch/prod1_87_1046156085.dbf Media Recovery Waiting for thread 1 sequence 88 (in transit) ``` **结论：** 还是会进行redo clearing 然后正常应用日志。 **在备库手动创建standby redolog：** ``` alter database add standby logfile group 4 '/oracle/app/oradata/prod/std_redo04.log' size 50M; alter database add standby logfile group 5 '/oracle/app/oradata/prod/std_redo05.log' size 50M; alter database add standby logfile group 6 '/oracle/app/oradata/prod/std_redo06.log' size 50M; alter database add standby logfile group 7 '/oracle/app/oradata/prod/std_redo07.log' size 50M; ``` **出现如下错误：** ``` ORA-01156: recovery or flashback in progress may need access to files ``` **关闭日志应用：** ``` SQL>alter database recover managed standby database cancel; ``` 再次创建成功。 **再次从主库进行一次日志切换：** ``` SQL> alter system switch logfile; ``` **跟踪备库警告日志：** ``` Archived Log entry 12 added for thread 1 sequence 89 rlc 1046156085 ID 0x1b70d452 dest 2: RFS[4]: Selected log 4 for thread 1 sequence 90 dbid 457994418 branch 1046156085 Tue Aug 25 07:33:18 2020 RFS[4]: Selected log 5 for thread 1 sequence 91 dbid 457994418 branch 1046156085 Tue Aug 25 07:33:18 2020 Archived Log entry 13 added for thread 1 sequence 90 ID 0x1b70d452 dest 1: Tue Aug 25 07:35:39 2020 RFS[4]: Selected log 4 for thread 1 sequence 92 dbid 457994418 branch 1046156085 Tue Aug 25 07:35:39 2020 Archived Log entry 14 added for thread 1 sequence 91 ID 0x1b70d452 dest 1: ``` 完毕~