Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Switchover to Standby is it necessary to shutdown other nodes?

User_CSOQUMar 19 2013 — edited Mar 19 2013

Hi,

I have installed oracle 11g r2 rac with asm in two nodes. OS is hp-Unix.

I have installed oracle11g Active Data Guard using Single alone Database.

Both RAc and Active Data Guard works fine.

I have not configure Data Guard Broker.

For testing purpose I need to make primary as standby and standby as primary.

In node 1: I will run commend in node 1
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN ;

Shall I need to shutdown node 2 in RAC?
if node 2 is in shutdown then after switch over primary as standby just open the node 2 ?

Thanks
Solaiman

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2013

Added on Mar 19 2013

#11gr2, #data-guard, #performance-availability

2 comments

350 views