Categories
Blog

Adding New Redo Log Groups

An error occurs when deleting a logfile group after you have added new groups.
SQL> alter database drop logfile group 3;
alter database drop logfile group 3
*
ERROR at line 1:
ORA-01623: log 3 is current log for instance
 
Solution
SQL> alter system switch logfile;
System altered.
SQL> alter system switch logfile;
System altered.
SQL> alter system checkpoint;
System altered.
SQL> alter database drop logfile group 3;
Database altered.
Then just check by doing the following:
SQL> select member
from v$logfile;