How to start and stop the MRP process with DGMGRL dataguard commands

You need to connect to DGMGRL and explicitly set the apply state to APPLY-OFF for the standby database. 

DGMGRL> CONNECT sys/password@standby_connect_identifier AS SYSDBA;

Following command run by using STANDBY:

Stop the MRP by setting the database’s state:

DGMGRL> EDIT DATABASE <standby_unique_name> SET STATE='APPLY-OFF';

Start the MRP by Setting the Database State:

DGMGRL> EDIT DATABASE <standby_unique_name> SET STATE='APPLY-ON';

Example:


DGMGRL> EDIT DATABASE standby SET STATE='APPLY-OFF';
Succeeded.

DGMGRL> EDIT DATABASE standby SET STATE='APPLY-ON';
Succeeded.


This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply