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