ORA-01153: an incompatible media recovery is active
Hi,
My database version is 11.2.0.1.0 running on AIX 64-bit.
When I am trying to keep my standby database in managed mode getting the following error... but archives are getting applied.
=======================================================================================================================================
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
=======================================================================================================================================
Did the following...
1. Cancelled the recovery.
2. shutdown the standby database.
3. Startup the standby DB in NOMOUNT.
4. Then in mounted - ALTER DATABASE MOUNT STANDBY DATABASE;
After starting the STANDBY DB in MOUNT, automatically archives were getting applied. I observerd that MRP0 was started.
SQL> SELECT PROCESS, STATUS, SEQUENCE# FROM V$MANAGED_STANDBY;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CLOSING 39020
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
MRP0 WAIT_FOR_LOG 39021
RFS IDLE 39065
RFS IDLE 39023
RFS IDLE 39021
RFS IDLE 39022
9 rows selected.
=======================================================================================================================================
From Alert log ...
ALTER DATABASE MOUNT STANDBY DATABASE
ARCH: STARTING ARCH PROCESSES
Tue Feb 19 02:16:01 2013
ARC0 started with pid=21, OS id=18874512
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Tue Feb 19 02:16:02 2013
ARC1 started with pid=22, OS id=19071106
Tue Feb 19 02:16:02 2013
Successful mount of redo thread 1, with mount id 1873774620
Tue Feb 19 02:16:02 2013
ARC2 started with pid=23, OS id=20381810
Physical Standby Database mounted.
Lost write protection disabled
Tue Feb 19 02:16:02 2013
ARC1: Archival startedARC3 started with pid=24, OS id=20447348
ARC2: Archival started
ARC2: Becoming the 'no FAL' ARCH
ARC1: Becoming the heartbeat ARCH
Completed: ALTER DATABASE MOUNT STANDBY DATABASE
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Tue Feb 19 02:16:04 2013
Starting Data Guard Broker (DMON)
Tue Feb 19 02:16:04 2013
NSV0 started with pid=25, OS id=20512886
=======================================================================================================================================
I would like to know that in 11g R2, does MRP0 process starts automatically ???
Thanks.