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
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.
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/