5 Replies Latest reply: Oct 19, 2012 2:40 AM by 744052 RSS

    Enable Physical Standby Database

    744052
      Hi,

      I am working on Linix with Oracle Database 10g, I am preforming a test with the data guard

      DGMGRL for Linux: Version 10.2.0.3.0 - Production

      Copyright (c) 2000, 2005, Oracle. All rights reserved.

      Welcome to DGMGRL, type "help" for information.
      DGMGRL> connect sys/oracle@DRCP
      Connected.
      DGMGRL> show configuration

      Configuration
      Name:                DB123
      Enabled:             YES
      Protection Mode:     MaxAvailability
      Fast-Start Failover: DISABLED
      Databases:
      PROD   - Primary database
      DRCP - Physical standby database

      Current status for "DB123":
      SUCCESS

      DGMGRL> failover to 'DRCP'
      Performing failover NOW, please wait...
      Failover succeeded, new primary is "DRCP"
      DGMGRL>  SHOW CONFIGURATION;

      Configuration
      Name:                DB123
      Enabled:             YES
      Protection Mode:     MaxPerformance
      Fast-Start Failover: DISABLED
      Databases:
      PROD   - Physical standby database (disabled)*
      DRCP - Primary database

      Current status for "DB123":
      SUCCESS

      My question is how to move back to PROD and enable it, what are the options?

      Please advice. Thank you
        • 1. Re: Enable Physical Standby Database
          Fran
          please check:
          http://www.idevelopment.info/data/Oracle/DBA_tips/Data_Guard/DG_52.shtml#Activate%20the%20Physical%20Standby%20Database%20as%20a%20Read/Write%20Clone%20of%20the%20Primary%20Database
          http://www.pythian.com/news/1405/testing-a-physical-standby-database-in-oracle-10g/
          • 2. Re: Enable Physical Standby Database
            saurabh
            you done a failover to the standby database. you cannot revert back to PROD database as production. In order to do so you need to take backup of DRCP database and create standby using it and then switchover the database and donot failover again.
            • 3. Re: Enable Physical Standby Database
              JohnWatson
              You need to use REINSTATE DATABASE which requires flashback to have been enabled.
              • 4. Re: Enable Physical Standby Database
                Shivananda Rao
                Hi,

                Since you have performed a FAILOVER, this is a one way process. If you were trying to test the role transitions, then you could have gone with SWITCHOVER which is a 2 way process.

                Now, you are having only 1 database which is behaving as primary database and you do not have the standby database. If flashback was enabled on your old primary database, then you can reinstate it to behave as standby database.

                Since you are using DGMGRL, you can refer this http://gavinsoorma.com/2009/06/using-flashback-to-reinstate-a-standby-after-a-failover/

                If using SQL, then you can refer http://shivanandarao.wordpress.com/2012/08/28/dataguard-failover/
                • 5. Re: Enable Physical Standby Database
                  744052
                  Thank you all for your answers. Flashback was not enabled so then it becomes only a one way process.

                  Edited by: user8676543 on Oct 19, 2012 12:40 AM