What is MRP? So MRP (Managed Recovery Process) applies the information from the archived redo logs to the standby database in Oracle. Today in this article, we will go through the steps on how to Start and Stop MRP Process in Oracle dataguard. Let’s go through this :
Table of Contents
Start MRP Process:
SQL>alter database recover managed standby database disconnect from session;
or,
from dgmgrl
DGMGRL> EDIT DATABASE <standby_unique_name> SET STATE='APPLY-ON';
Check if the MRP Process is running fine :
the sequence# should change and the lag also should get reduced.
SQL>select process,status,sequence# from gv$managed_standby;
Start MRP with Delay Option:
Syntax :
SQL>alter database recover managed standby database USING ARCHIVED LOGFILE delay <delay_minutes> disconnect from session;
Example :
Starting MRP with 6 hrs of delay :
SQL>alter database recover managed standby database USING ARCHIVED LOGFILE delay 720 disconnect from session;
Stop MRP Process :
Before stopping MRP, we should disable the log_shipping from Primary :
Disable Log shipping from Primary :
SQL>alter system set log_archive_dest_2=DEFER;
or,
DGMGRL> EDIT DATABASE <standby_unique_name> SET PROPERTY LOG_SHIPPING='OFF';
Stop MRP :
SQL>alter database recover managed standby database disconnect from session;
or,
DGMGRL> EDIT DATABASE <standby_unique_name> SET STATE='APPLY-OFF';
Hope it helps!! Also, you can get more information from the Oracle Doc as well.
Other Oracle Related Articles :
