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>
