In the database dropping standby redo logfile fails with error ORA-01624 as below.
SQL> alter database drop standby logfile group 2;
alter database drop standby logfile group 2
*
ERROR at line 1:
ORA-01624: log 2 needed for crash recovery of instance ctl3 (thread 1)
ORA-00312: online log 2 thread 1: '/oradata3/ctl3/redo02.log'
ORA-00312: online log 2 thread 1: '/oraidx3/ctl3/redo02b.log'
Cause of the Problem
The Online redo log which is being dropped on the primary is either the current online redo log or
it has not completely been archived yet. To know more about the redo logfile status see Redo Log file status. By querying the V$LOG view you can see the status of the redo log file. In order to drop a redo log file the status column should be 'INACTIVE'.
Solution of the Problem
1) Switch the logfile on primary database so that group can become non-current.
SQL> ALTER DATABASE SWITCH LOGFILE;
2) Copy the standby logfile from primary database to standby database.
3) In the primary database move the logfile to a different location
4) Rename the logfile
5) Clear the logfile using 'alter database clear logfile group ..'
6) Drop the standby logfile using 'alter database drop standby logfile group ...'
Related Documents
No comments:
Post a Comment