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;