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 immediate

Database closed.

Database dismounted.

Oracle instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  314572800 bytes

Fixed Size                  1219136 bytes

Variable Size             121636288 bytes

Database Buffers          184549376 bytes

Redo Buffers                7168000 bytes

Database mounted.

ORA-00313: open failed for members of loggroup 3 of thread 1

ORA-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>