ORA-00361: cannot remove last log member

Cause:

While drop of redo log member, oracle doesnot allow to drop logfile which is the last member of group due to recovery

kIsH@x3z6zx9<^>alter database drop logfile member '+RECOX/x3z6zx9/onlinelog/group_3.259.1098264695';
alter database drop logfile member '+RECOX/x3z6zx9/onlinelog/group_3.259.1098264695'
*
ERROR at line 1:
ORA-00361: cannot remove last log member +RECOX/x3z6zx9/onlinelog/group_3.259.1098264695 for group 3

Action:

Add a new logfile

kIsH@x3z6zx9<^>alter database add logfile member '+RECOX' to group 3;

Database altered.

Switch logfile

kIsH@x3z6zx9<^>alter system switch logfile;

System altered.

Drop the old one

kIsH@x3z6zx9<^>alter database drop logfile member '+RECOX/x3z6zx9/onlinelog/group_3.259.1098264695';

Database altered.

Leave a Reply