Stop & Start Managed Recovery Mode On Standby Database

There are few ways you can Stop managed Recovery Mode on Standby Database. 

1) by using Data Guard Broker 

2) Manually by logging into SQLPLUS


1) by using Data Guard Broker 

-- Stop Recovery Mode 

A)  Stop the apply process in the standby database

DGMGRL> edit database 'SUNU_B' set state='APPLY-OFF';
Succeeded.

B) Started the Recover through DG Broker

DGMGRL> edit database 'SUNU_B' set state='APPLY-ON';
Succeeded.

2) Manually by logging into SQLPLUS


By logging into Standby Database  

 Stop the MRP process (stop redo Apply)

SQL> alter database recover managed standby database cancel;


Make sure no MRP is working, from V$MANAGED_STANDBY

SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY where PROCESS=’MRP0';

no rows selected


-- Start Managed Recovery 


SQL> alter database recover managed standby database disconnect from session;

Make sure  MRP is running, from V$MANAGED_STANDBY

SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY where PROCESS=’MRP0';

no rows selected