ORA-00312 ORA-01623: log 3 is current log for instance

#Error while dropping current redo log group members 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 test (thread 1) - cannot drop ORA-00312: online log 3 thread 1: 'D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO03.LOG' Cause:  You can not drop current or active redo log group members. Solution: Switch 2-3 logs and change the status of current or active to inactive and then drop the redo log group members. #First check the status of the redo log group members. SQL> select group#,type,member from v$logfile order by 1; GROUP# TYPE    MEMBER ------ ------- ------------------------------------------------      1 ONLINE  D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO01.LOG      2 ONLINE  D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO02.LOG      3 ONLINE  D:\RUPESH\SETUPS\TEST\TEST\ONLINELOG\REDO03.LOG SQL> select group#,thread#,sequence#,members,archived,status from v$log order by 1; GROUP# THREAD#  SEQUENCE#    MEMBERS ARC STATUS ------ ------- ---------- ---------- --- --------      1       1        118          1 YES INACTIVE      2       1        119          1 YES ACTIVE      3       1        120          1 NO  CURRENT From the above output, you can see that the status of the redo log group 3 is CURRENT and hence you can not drop this redo log group. #Perform the log switch and check the redo log group status. SQL> alter system switch logfile; System altered. SQL> alter system switch logfile; System altered. SQL> alter system checkpoint; System altered. SQL> select group#,thread#,sequence#,members,archived,status from v$log order by 1; GROUP# THREAD#  SEQUENCE#    MEMBERS ARC STATUS ------ ------- ---------- ---------- --- ---------      1       1        121          1 YES INACTIVE      2       1        122          1 NO  CURRENT      3       1        120          1 YES INACTIVE #Now the group# 3 is INACTIVE. You can drop this group. SQL> alter database drop logfile group 3; Database altered. SQL> select group#,thread#,sequence#,members,archived,status from v$log order by 1; GROUP# THREAD#  SEQUENCE#    MEMBERS ARC STATUS ------ ------- ---------- ---------- --- --------      1       1        121          1 YES INACTIVE      2       1        122          1 NO  CURRENT