SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------- ------------- ---------
1 1 2 52428800 1 NO CURRENT 518838 23-APR-11
2 1 1 52428800 1 NO INACTIVE 518704 23-APR-11
3 1 0 52428800 1 YES UNUSED 0
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ---------- ------- --------------------------------------------- ---
3 ONLINE /u01/oracle/oradata/ERIKXUE/redo03.log NO
2 ONLINE /u01/oracle/oradata/ERIKXUE/redo02.log NO
1 ONLINE /u01/oracle/oradata/ERIKXUE/redo01.log NO
SQL>
SQL> ! rm /u01/oracle/oradata/ERIKXUE/redo02.log
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 83887696 bytes
Database Buffers 197132288 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/oracle/oradata/ERIKXUE/redo02.log'
清洗当前日志组内的每个成员内容
SQL> alter database clear logfile group 2;
Database altered.
SQL> alter database open;
Database altered.
SQL>
