Database Administration (MOSC)

MOSC Banner

MRP0: Background Media Recovery terminated with error 1110

edited Sep 25, 2015 10:01AM in Database Administration (MOSC) 5 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center