Hi,all
I am trying to do the oracle backup&restore using dataguard.
I installed 4 instances in a same server, and did the configuration correctly in every instance.
but after i did the role switch-over for one instance, the MRP terminated by system, and after awhile, the system attempt to start background MRP again, and it will be terminated again....
the log information is showed as follows, and attachment is the configuration and inoc_pr00_43079.trc.
hope you guys can help me, thanks very much....
Fri Mar 04 01:15:09 2016
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION
ORA-1153 signalled during: ALTER DATABASE RECOVER MANAGED
STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION ...
Fri Mar 04
01:15:20 2016
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE
USING CURRENT LOGFILE DISCONNECT FROM SESSION
Fri Mar 04 01:15:21
2016
Recovery coordinator died, shutting down parallel recovery
Fri Mar 04
01:15:21 2016
MRP0: Background Media Recovery terminated with error
448
Errors in file
/opt/oracle/app/oracle/diag/rdbms/inocstandby/inoc/trace/inoc_pr00_43079.trc:
ORA-00448:
normal completion of background process
Managed Standby Recovery not using
Real Time Apply
Recovery interrupted!
Recovered data files to a consistent
state at change 2687663
Attempt to start background Managed Standby Recovery
process (inoc)
Fri Mar 04 01:15:22 2016
MRP0 started with pid=28, OS
id=49748
MRP0: Background Managed Standby Recovery process started
(inoc)
started logmerger process
Fri Mar 04 01:15:27 2016
Managed
Standby Recovery starting Real Time Apply
Parallel Media Recovery started
with 5 slaves
Waiting for all non-current ORLs to be archived...
All
non-current ORLs have been archived.
Media Recovery Waiting for thread 1
sequence 55 (in transit)
Recovery of Online Redo Log: Thread 1 Group 17 Seq
55 Reading mem 0
Mem# 0: /oradata/inoc/standby_redo01.log
Completed:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT
LOGFILE DISCONNECT FROM SESSION
Fri Mar 04 01:15:36
2016
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING
CURRENT LOGFILE DISCONNECT FROM SESSION
ORA-1153 signalled during: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION ...
Fri Mar 04 01:15:48
2016
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING
CURRENT LOGFILE DISCONNECT FROM SESSION
ORA-1153 signalled during:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT
LOGFILE DISCONNECT FROM SESSION ...
Fri Mar 04 01:15:58
2016
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING
CURRENT LOGFILE DISCONNECT FROM SESSION
ORA-1153 signalled during:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT
LOGFILE DISCONNECT FROM SESSION ...
Fri Mar 04 01:16:25 2016
Fri Mar 04
01:16:25 2016
Recovery coordinator died, shutting down parallel recoveryMRP0:
Background Media Recovery terminated with error 448
Errors in file
/opt/oracle/app/oracle/diag/rdbms/inocstandby/inoc/trace/inoc_pr00_49767.trc:
ORA-00448:
normal completion of background process
Managed Standby Recovery not using
Real Time Apply
Recovery interrupted!
Recovered data files to a consistent
state at change 2687825