2 Replies Latest reply: Mar 19, 2013 5:18 AM by 879152 RSS

    Switchover to Standby is it necessary to shutdown other nodes?

    879152
      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
          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
            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