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

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World

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

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer