ORA-01624: log 73 needed for crash recovery of instance

On the primary standby side,when I tried to drop log file I got this error.
Why I need to drop this redolog file,the reason is that resized online redol log file on primary side

SQL> ALTER DATABASE CLEAR LOGFILE GROUP 73;

Database altered.

SQL> alter database drop logfile group 73;
alter database drop logfile group 73
*
ERROR at line 1:
ORA-01624: log 73 needed for crash recovery of instance pdw1k9 (thread 9)
ORA-00312: online log 73 thread 9:
‘+DATAX2KSC00/pdw1k/onlinelog/group_73.5219.849813663’

The action plan is offered from oracle support

On the primary:

1). Add online redo logs of the desirable sizes.

2). Then do a log switch and drop ORL when status is INACTIVE

3). Add SRL and drop the ones with INACTIVE status

4). On the standby follow this concise procedure to recreate standby controlfile:

>> Step By Step Guide On How To Recreate Standby Control File When Datafiles Are On ASM And Using Oracle Managed Files (Doc ID 734862.1)

Advertisements

About Ugurcan

Exadata Engineer
This entry was posted in Dataguard. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s