SQL> alter database drop logfile member 'C:/ORACLE/ORADATA/TEST/REDO04A.LOG';
alter database drop logfile member 'C:/ORACLE/ORADATA/TEST/REDO04A.LOG'
*
ERROR 位于第 1 行:
ORA-00362: 组成组 4 中的有效日志文件要求输入成员
ORA-01517: 日志成员: 'C:/ORACLE/ORADATA/TEST/REDO04A.LOG'
rollingpig说
之所以不能drop logfile member from group 4,是因为group 4的其他redo log file 的状态不对。
这种情况,应该作几次alter system switch logfile , 使group 4的其他redo log file 的状态变为正常就可以了。
SQL> alter system switch logfile;
系统已更改。
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- ----------
1 1 35 104857600 1 NO INACTIVE
3463212 08-3月 -08
2 1 37 104857600 1 NO CURRENT
3463460 08-3月 -08
3 1 34 104857600 1 NO INACTIVE
3461197 08-3月 -08
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- ----------
4 1 36 52428800 2 NO ACTIVE
3463329 08-3月 -08
SQL> alter database drop logfile member 'C:/ORACLE/ORADATA/TEST/REDO04A.LOG';
数据库已更改。
可以成功删除!