【日志】ORA-00362 ORA-01517

-----------------------------------------------------------------
SQL> archive log list
Database log mode           No Archive
ModeAutomatic archival      Disabled
Archive destination         USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence  16
Current log sequence        19
-----------------------------------------------------------------
在noarchive mode 下出现
-----------------------------------------------------------------
SQL> ALTER DATABASE DROP LOGFILE MEMBER2 '/u01/oracle/oradata/wilson/redo03.log';
ALTER DATABASE DROP LOGFILE MEMBER
*
ERROR at line 1:ORA-00362: member is required to form. a valid logfile in group 3
ORA-01517: log member: '/u01/oracle/oradata/wilson/redo03.log'
------------------------------------------------------------------
SQL> select a.group#,a.status,b.member from v$log a,v$logfile b
2 where a.group#=b.group# order by group#
GROUP STATUS   MEMBER
----- -------- --------------------------------------
1     CURRENT   /u01/oracle/oradata/wilson/redo01.log
1     CURRENT   /u01/oracle/oradata/wilson/redo01.rdo
2     INACTIVE  /u01/oracle/oradata/wilson/redo02.rdo
2     INACTIVE  /u01/oracle/oradata/wilson/redo02.log
3     INACTIVE  /u01/oracle/oradata/wilson/redo03.rdo
3     INACTIVE  /u01/oracle/oradata/wilson/redo03.log
-----------------------------------------------------------------
解决方法：多进行几次switch logfile。SQL> alter system switch logfile;
-----------------------------------------------------------------
SQL> alter database drop logfile member
2 '/u01/oracle/oradata/wilson/redo03.log';
Database altered.
=================================================================

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7351078/viewspace-669362/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7351078/viewspace-669362/