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


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
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google