Automation: DG Broker

This is a client requirement related to Oracle Dataguard.

DG Broker is configured to perform "Failover". Which works fine and fails over to Physical Standby when the conditions are met. Now, the client wants, that once DG Broker performs "Failover" its should also notify the Application DNS Server to redirect its traffic to new Primary Database.

This is part of automation workflow, where client wants to ensure there is no manual intervention with Database Failover as well as Application switch to new Primary Database.

Please suggest.

Thanks and Regards,
Sourav Biswas
+91-9650017306