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.
