Friday, 14 August 2015

drop logfile group ORA-01624: log 1 needed for crash recovery of instance ORA-00312

After re-sizing redo log getting below error while dropping redo log group.

Before drop we should make sure aleast 3 redo group are there and droping group should be in INACTIVE state.

SQL> alter database drop logfile group 1
*
ERROR at line 1:
ORA-01624: log 1 needed for crash recovery of instance  (thread 1)
ORA-00312: online log 1 thread 1: '/u01/oradata//redolog/redo01_a.log'

So to make ACTIVE to INACTIVE exeute system level checkpoint.

SQL> ALTER SYSTEM CHECKPOINT GLOBAL;

System altered.

SQL> 
SQL> select GROUP#,THREAD#,STATUS from v$log;

    GROUP#    THREAD# STATUS
---------- ---------- ----------------
         1          1 INACTIVE
         4          1 INACTIVE
         5          1 CURRENT
         6          1 INACTIVE
         7          1 INACTIVE
         8          1 INACTIVE

Now drop the group.
SQL> alter database drop logfile group 1;

Database altered.

SQL>

No comments: