2 Replies Latest reply on Aug 3, 2012 2:11 PM by liaison1

    How to switch primary role to one of standby DBs without interruption?

    liaison1
      We have a primary database with 2 standby databases running. We would like to switch role of primary to one of the standby with other 2 (one is standby and the other was primary) standby without interruption and rebuild? What is the detail procedure for it?

      Thanks a lot!
        • 1. Re: How to switch primary role to one of standby DBs without interruption?
          damorgan
          The detailed procedure for anything in Oracle more complex than
          SELECT * FROM dual
          requires a version number. Since you thought it unimportant to provide that no help is possible.

          In this case, in addition to the version number, little things such as:

          1. What type of Data Guard implementation? Active? Logical? Snapshot Standby? would be useful information for anyone trying to help you.
          2. Is this stand-alone or RAC? Again you provide no information and this is critically important?
          3. What is the geographical distance between the primary and the standby?
          4. What is the protection mode?

          If you are not a student you need to read the Oracle online docs and understand the technology. To ask this question, without providing obviously essential information, indicates you may be a danger to your database: Something I am sure you do not wish to be.
          • 2. Re: How to switch primary role to one of standby DBs without interruption?
            liaison1
            The database versions are all 10.2.0.4. The 2 data guards are active physical standby with max performance. One dataguard server is at New Jersey and the other one is at Atlanta here local. We would like to switch over to the local one from primary DB.

            Thanks!