Oracle Physical Standby Database shutdown and startup
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
No comments:
Post a Comment