MRP0: Background Media Recovery terminated with error 1110
Hi,
After restore from active primary, stand by database is not sync with primary .
SQL> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
SQL> alter database recover managed standby database disconnect from session ;
Database altered.
SQL> select thread#,max(sequence#) from v$log_history group by thread#;
THREAD# MAX(SEQUENCE#)
---------- --------------
1 5126
2 3750
SQL> recover managed standby database cancel;
ORA-16136: Managed Standby Recovery not active
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-10458: standby database requires recovery
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file