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.