Data Guard Broker For Automatic Failover.
 862878Dec 15 2011 — edited Mar 28 2012
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