[ORA-00361: cannot remove last log member ]

* Log File Group의 그룹의 멤버가 1개일 때 멤버 삭제시 발생하는 에러.

* Redo Log Group의 멤버는 최소 1개.

SQL> @log   GROUP# MEMBER       MB SEQ# STATUS       ARC ------ --------------------------------------------- ---- ---------- ---------------- -----      1 /u01/app/oracle/oradata/PROD/redo01a.log       100   17 INACTIVE       NO      2 /u01/app/oracle/oradata/PROD/redo02a.log       100   18 INACTIVE       NO      3 /u01/app/oracle/oradata/PROD/redo03a.log       100   20 CURRENT       NO      4 /u01/app/oracle/oradata/PROD/redo04_a.log 5   19 INACTIVE       NO   SQL> alter database drop logfile member   2  '/u01/app/oracle/oradata/PROD/redo04_a.log'; alter database drop logfile member * ERROR at line 1: ORA-00361: cannot remove last log member /u01/app/oracle/oradata/PROD/redo04_a.log for group 4

 

=> Log file group의 멤버는 최소 1개이기 때문에, member가 지워지지 않는다. 그룹을 지움으로써 삭제해야함.

SQL> alter database drop logfile group 4;   SQL> @log  GROUP# MEMBER       MB SEQ# STATUS       ARC ------ --------------------------------------------- ---- ---------- ---------------- -----      1 /u01/app/oracle/oradata/PROD/redo01a.log       100   17 INACTIVE       NO      2 /u01/app/oracle/oradata/PROD/redo02a.log       100   18 INACTIVE       NO      3 /u01/app/oracle/oradata/PROD/redo03a.log       100   20 CURRENT       NO