Configuring Data Guard Broker

Before configure dg broker create standby redo logs in primary & standby database

1.ALTER SYSTEM SET dg_broker_start=true;

2.dgmgrl sys/SYS123@neft

3.DGMGRL> CREATE CONFIGURATION my_dg_config AS PRIMARY DATABASE IS neft CONNECT IDENTIFIER IS neft;

4.DGMGRL> ADD DATABASE neft_dr AS CONNECT IDENTIFIER IS neft_dr MAINTAINED AS PHYSICAL;

5.DGMGRL> ENABLE CONFIGURATION;

6.DGMGRL> show configuration;

                     Configuration at standby database side

 

 

     Performing Switchover and Switch back using dg broker

 

Standby database become primary database

 

Switch back:

We can perform switch back from primary side, But you should connect to standby database using tnsname (i.e neft_dr)  from primary database.

 

 

We have to Start the standby database in mount state