Pages

Monday, 11 May 2015

Standby logs not applying with warning: Waiting for all non-current ORLs to be archived... Media Recovery Waiting for thread 1 sequence

Today i got issue on Standby where logs are not applying and there is no error in configuration even after shipping the logs from prod to standby the logs are not applied.

and in alert log its showing message like below.

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
Mon May 11 15:49:49 2015
Attempt to start background Managed Standby Recovery process (DBNAME)
MRP0 started with pid=16, OS id=13175
Mon May 11 15:49:49 2015
MRP0: Background Managed Standby Recovery process started (DBNAME)
Managed Standby Recovery not using Real Time Apply
 parallel recovery setup failed: using serial mode
Mon May 11 15:49:55 2015
Waiting for all non-current ORLs to be archived...
Media Recovery Waiting for thread 1 sequence 7249
Mon May 11 15:49:55 2015
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION

Solution:

Just register the log or using RMAN do catalog

RMAN> catalog start with '/oradata/DBNAME/arch';

After that recover stated 

If still logs are not shipping please refer Metalink Note: Logs are not shipped to the physical standby database (Doc ID 1130523.1)


No comments:

Post a Comment