Data Guard Broker For Automatic Failover.
862878Dec 15 2011 — edited Mar 28 2012Experts,
I've below environment.
Primary Database:
• Type: RAC with two nodes
• Version: 11.2.0.2
• DB_UNIQUE_NAME: IAM
• Real Time Apply: Enabled
• Data Guard Protection Mode: Maximum Availability
Standby Database:
• Type: Single Server Standalone Database
• Version: 11.2.0.2
• DB_UNIQUE_NAME: IAMSTBY
• Real Time Apply: Enabled
• Data Guard Protection Mode: Maximum Availability
I successfully completed MANUAL switchover/switchback of database role. Now I'm planning to configure Data Guard Broker for automatic switchover process when primary database goes down.
I've a queston before I do that :
- Let's say broker is working fine and it's doing automatic failover that makes standby to primary. As a DBA, I will bring back the original primary DB. Once original primary db is back, Does Broker again change the roles ?
Please let me know.
Thanks
Edited by: 859875 on Dec 15, 2011 11:09 AM