This discussion is archived
2 Replies Latest reply: Mar 19, 2013 3:18 AM by 879152 RSS

Switchover to Standby is it necessary to shutdown other nodes?

879152 Newbie
Currently Being Moderated
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
  • 1. Re: Switchover to Standby is it necessary to shutdown other nodes?
    CKPT Guru
    Currently Being Moderated
    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 ?
    When you are not managing with broker, primary if you have 2 node RAC. Then prior to switchover shutdown any one of the node.
    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.
  • 2. Re: Switchover to Standby is it necessary to shutdown other nodes?
    879152 Newbie
    Currently Being Moderated
    Hi,
    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?

    Thanks
    SOlaiman

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points