This discussion is archived
5 Replies Latest reply: Oct 19, 2012 12:40 AM by 744052 RSS

Enable Physical Standby Database

744052 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    You need to use REINSTATE DATABASE which requires flashback to have been enabled.
  • 4. Re: Enable Physical Standby Database
    Shivananda Rao Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

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