3 Replies Latest reply: Apr 4, 2013 10:29 AM by Levi Pereira RSS

    Oracle RAC ONE Node ! Inquiry

    Muhammad Ahmad
      Hi,

      Good Day.

      In my understanding Oracle 11gr2 RAC ONE Node "online database relocation" ability can address ONLY "Planned downtime Maintenance window".

      I mean in case of any catastrophic event i.e "failover / un-planned downtime" a production downtime window is a Must which it need to restart the failed instance on standby node.

      Please comment.



      Thanks

      M Ahmad
        • 1. Re: Oracle RAC ONE Node ! Inquiry
          Santysharma-Oracle
          Hi,


          RAC one node feature enables database to restart on same server in case of any instance crash or automatic relocation to other node in case of node failure.


          Regards,
          Sharma
          • 2. Re: Oracle RAC ONE Node ! Inquiry
            Muhammad Ahmad
            Hi Sharma,

            I understand.

            but i was talking about downtime windows, in my understanding customer will face downtime window during failover to secondary node or restart on same node 'the time needed to restart database instance' but ONLY for planned maintenance activities 'online database instance relocation' capability can be utilized to relocate database instance to another node without facing any downtime as it uses 'shutdown transactional' apporach..

            do you agree with my understanding?


            regards,
            M Ahmad
            • 3. Re: Oracle RAC ONE Node ! Inquiry
              Levi Pereira
              Muhammad Ahmad wrote:
              Hi Sharma,

              I understand.

              but i was talking about downtime windows, in my understanding customer will face downtime window during failover to secondary node or restart on same node 'the time needed to restart database instance' but ONLY for planned maintenance activities 'online database instance relocation' capability can be utilized to relocate database instance to another node without facing any downtime as it uses 'shutdown transactional' apporach..

              do you agree with my understanding?
              Yes..

              During failure of Instance it will be restarted (downtime occurs). Is not possible use OMOTION on this case

              Using Omotion:
              Omotion moves a RAC One Node instance from one server to another—without any downtime
              • Use Cases
              * Load balancing
              * Database + OS patching and maintenance
              • Oracle supplied tools control migration
              * Services are not accepting connections on both nodes at the same time
              * Migrated instance shutdown transactional once services moved
              * A maximum of 30 minutes allowed for connections to migrate (then shutdown abort)