This content has been marked as final. Show 2 replies
I have installed oracle 11g r2 rac with asm in two nodes. OS is hp-Unix.When you are not managing with broker, primary if you have 2 node RAC. Then prior to switchover shutdown any one of the node.
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 ?
Once you performed switch over, Your primary database will be non-RAC database[because not an clustered], So the redo threads active in only one node.
In such case you will be having one node primary and one node standby.
Thanks for yiur reply,
But I want 2 node standby after switchover also in that case new primary is one node primary.
Pls reply how?