Restart Oracle Physical Standby Database and MRP Process

Shutdown Physical Standby Database and MRP:

Please execute below on physical standby database to stop the Managed Recovery Process(MRP) and shutdown physical standby database:

  # connect / as sysdba
 
   STANDBY> alter database recover managed standby database cancel;
   
   STANDBY> recover standby database until cancel;
   auto
   
   STANDBY> shutdown immediate
   
   STANDBY> exit

Startup Physical Standby Database and MRP:

Please execute below commands on physical standby database to start physical standby database and the Managed Recovery Process(MRP) :

   # connect / as sysdba
   
   STANDBY> startup nomount
   
   STANDBY> alter database mount standby database;
   
   STANDBY> alter database recover managed standby database disconnect from session;
   
   STANDBY> exit

If you want to Enable/Disable Archive Log shipping from Primary to Standby Server then execute below command on Primary Node

Defer or Disable Log shipping on the Primary server: 

# connect / as sysdba

PRIMARY> ALTER SYSTEM SET log_archive_dest_state_2 = DEFER;

Enable Log shipping on the Primary server:

# connect / as sysdba

PRIMARY> ALTER SYSTEM SET log_archive_dest_state_2 = ENABLE;