Total System Global Area 353862792 bytes
Fixed Size 730248 bytes
Variable Size 285212672 bytes
Database Buffers 67108864 bytes
Redo Buffers 811008 bytes
Database mounted.
Database opened.
SQL>;
6、 查看日至成员
SQL>; select * from v$logfile;

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
3 ONLINE
/T3/ORACLE/oradata/ORA9/redo03.log

2 ONLINE
/T3/ORACLE/oradata/ORA9/redo02.log

1 ONLINE
/T3/ORACLE/oradata/ORA9/redo01.log

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
1 ONLINE
/T3/ORACLE/oradata/ORA9/redo01a.log

2 ONLINE
/T3/ORACLE/oradata/ORA9/redo02a.log

3 INVALID ONLINE
/T3/ORACLE/oradata/ORA9/redo03a.log
7、 删除出问题的联机日志文件
SQL>; alter database drop logfile member '/T3/ORACLE/oradata/ORA9/redo03a.log';
alter database drop logfile member '/T3/ORACLE/oradata/ORA9/redo03a.log'
*
ERROR at line 1:
ORA-01609: log 3 is the current log for thread 1 - cannot drop members
ORA-00312: online log 3 thread 1: '/T3/ORACLE/oradata/ORA9/redo03.log'
ORA-00312: online log 3 thread 1: '/T3/ORACLE/oradata/ORA9/redo03a.log'

SQL>;
看来当前日志成员是不允许删除的
SQL>; alter system switch logfile;

System altered.

SQL>; select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- ----------
1 1 5 104857600 2 NO CURRENT
557687 02-9月 -05

2 1 3 104857600 2 YES INACTIVE
554601 02-9月 -05

3 1 4 104857600 2 YES ACTIVE
554603 02-9月 -05

SQL>; alter database drop logfile member '/T3/ORACLE/oradata/ORA9/redo03a.log';

Database altered.

SQL>; alter database add logfile member '/T3/ORACLE/oradata/ORA9/redo03a.log' to group 3;

Database altered.
SQL>; select * from v$logfile;

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
3 ONLINE
/T3/ORACLE/oradata/ORA9/redo03.log

2 ONLINE
/T3/ORACLE/oradata/ORA9/redo02.log

1 ONLINE
/T3/ORACLE/oradata/ORA9/redo01.log

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
1 ONLINE
/T3/ORACLE/oradata/ORA9/redo01a.log

2 ONLINE
/T3/ORACLE/oradata/ORA9/redo02a.log

3 INVALID ONLINE
/T3/ORACLE/oradata/ORA9/redo03a.log
看来还得切换一下日至
SQL>; alter system switch logfile;

System altered.
SQL>; select * from v$logfile;

GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
3 ONLINE
/T3/ORACLE/oradata/ORA9/redo03.log

2 ONLINE
/T3/ORACLE/oradata/ORA9/redo02.log