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;