Data Guard / Standby: ORA-01624: log %s needed for crash recovery of instance %s (thread %s)

advertisements

_____________________________________________________________________________________________________________________

Error Description:

Drop redo log group in data guard database is giving following error.

 

SQL> alter database drop logfile group 1;

alter database drop logfile group 1

*

ERROR at line 1:

ORA-01624: log 1 needed for crash recovery of instance TRANPRD_STANDBY (thread 1)

ORA-00312: online log 1 thread 1: '/u03/oradata/TRANPRD_STANDBY/redo1.log'

 

 

Elapsed: 00:00:00.02

 

Solution Description:

Check the status of the redo log group which you are going to drop. If it is in a status ofCLEARING you will not be able to drop the redo log. You have to make the redo log file tounused status by running alter database clearlogfile group n; command

 

SQL> select GROUP#,STATUS from v$log where group#=1;

 

    GROUP# STATUS

---------- ----------------

         1 CLEARING

1 rows selected.

 

SQL> ALTER DATABASE CLEAR LOGFILE GROUP 1;

 

Database altered.

 

SQL> alter database drop logfile group 1;

 

Database altered.

 

Elapsed: 00:00:00.05

_____________________________________________________________________________________________________________________

Website Stats