Data Guard Extended...Broker Method Configuartion.!!!

Make Sure Your Data guard configuration works fine..Logs shipping and Log applying is happening continuously.

My Primary Database is  DB11G
My Standby Database is  DB11G_STBY

Enable Broker Process
On Primary and Stand By server You need to enable broker process.

SQL> ALTER SYSTEM SET DG_BROKER_START=TRUE SCOPE=BOTH;

Edit Listener.ora

Then you will edit listner.ora file on Both Primary and Stand by servers

 Make Sure that the GLOBAL_DBNAME is set to db_unique_name_DGMGRL.

Create Broker Configuration.

DGMGRL>Connect sys/oracle

DGMGRL>CREATE CONFIGURATION 'GenesisDR' AS PRIMARY DATABASE IS 'DB11G' CONNECT IDENTIFIER IS 'DB11G' ;

Add the Standby database to the configuration

 DGMGRL>ADD DATABASE  'DB11G_STBY'  AS CONNECT IDENTIFIER IS 'DB11G_STBY';

Enable Configuration

DGMGRL>Enable Configuration

View Primary and Stand by Server Properties.

DGMGRL>show database DB11G

DGMGRL>show database DB11G_STBY

even though its in the database configuration it says "object "db11g" not found ".

So what I did was as follows;

single quotations were required.

DGMGRL>show database 'DB11G'

DGMGRL>show database 'DB11G_STBY'

Performing a switchover;

DGMGRL>switchover to 'DB11G_STBY'

That is  it. :) now you can perform switch overs using broker utility. :)