rman实验之归档模式，正常关机丢失非当前的联机重做日志文件

来源：互联网发布：网络直播涉黄40都是谁编辑：程序博客网时间：2024/05/01 17:50

1）查询非当前的联机重做日志文件

sys@ORCL> select group#,sequence#,status,members from v$log;    GROUP#  SEQUENCE# STATUS              MEMBERS---------- ---------- ---------------- ----------         1          7 INACTIVE                  2         2          8 INACTIVE                  2         3          9 CURRENT                   2sys@ORCL> col member for a70 truncsys@ORCL> select group#,member from v$logfile where group#=2;    GROUP# MEMBER---------- ----------------------------------------------------------------------         2 /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_8050hm84_.log         2 /u01/app/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_8050ho5o_.l

2）模拟文件丢失

sys@ORCL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.sys@ORCL> host rm /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_8050hm84_.logsys@ORCL> host rm -rf /u01/app/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_8050ho5o_.logsys@ORCL> startupORACLE instance started.Total System Global Area  419430400 bytesFixed Size                  1219760 bytesVariable Size             159384400 bytesDatabase Buffers          255852544 bytesRedo Buffers                2973696 bytesDatabase mounted.ORA-00313: open failed for members of log group 2 of thread 1ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_8050hm84_.log'ORA-00312: online log 2 thread 1:'/u01/app/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_8050ho5o_.log'

3）修复丢失的联机重做日志文件

sys@ORCL> alter database clear logfile group 2;Database altered.sys@ORCL> alter database open;Database altered.sys@ORCL> col member for a72 wrappedsys@ORCL> select group#,member from v$logfile where group#=2;    GROUP# MEMBER---------- ------------------------------------------------------------------------         2 /u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_8244vp4j_.log         2 /u01/app/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_8244vttx_.log