High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Ordering to restart the physical standby database in Oracle Data Guard !

 Hi all,

   I want ask about rules to restart the standby database (it's RAC with two nodes). My database has version 11gR1. I setup and configured my data guard environment success !
   So now, assume that I want restart the standby database. Because it also a production database, so I wonder bellow order actions is right ? I need some comments from expert before restart it!

    1. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
  2. Shutdown immediate;
  3. Startup mount;
  4. Alter database open read only;
  5. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
  

  Thanks for help !

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center