INACTIVE状态的日志损坏

INACTIVE日志损坏SQL> alter system switch logfile; System altered.查看日志的状态SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM---------- ---------- ---------- -------------------- --- ---------------- ------------- --------- 1 1 28 52428800 1 YES ACTIVE 579215 07-SEP-12 2 1 29 52428800 1 NO CURRENT 579450 07-SEP-12 3 1 27 52428800 1 YES INACTIVE 579032 07-SEP-12查看到第三组日志属于INACTIVE状态查看日志所属的组与对应的日志文件SQL> select * from v$logfile; GROUP# STATUS TYPE MEMBER IS_---------- ------- ----------------------------------------------- --- 3 ONLINE /u01/tiger/oradata/orcl2/redo03.log NO 2 ONLINE /u01/tiger/oradata/orcl2/redo02.log NO 1 ONLINE /u01/tiger/oradata/orcl2/redo01.log NO查看到第三组日志对应的日志文件SQL> ！cp /etc/passwd/u01/tiger/oradata/orcl2/redo03.log SQL> shutdown immediateDatabase closed.Database dismounted.Oracle instance shut down.SQL> startupORACLE instance started. Total System Global Area 314572800 bytesFixed Size 1219136 bytesVariable Size 121636288 bytesDatabase Buffers 184549376 bytesRedo Buffers 7168000 bytesDatabase mounted.ORA-00313: open failed for members of loggroup 3 of thread 1ORA-00312: online log 3 thread 1:"/u01/tiger/oradata/orcl2/redo03.log" 清洗当前日志组SQL> alter database clear logfile group 3; Database altered. SQL> alter database open; Database altered. SQL>Oracle日志的状态根据控制文件的信息恢复数据文件相关资讯 INACTIVE 本文评论查看全部评论（0）