They will need to rethink this. There are a number of Oracle-specific ways
to make applications aware of failover/switchover events
(TAF/FAN/Application Continuity) that are able to various degrees to
achieve what you want.
https://docs.oracle.com/database/121/TDPRC/configwlm.htm is a good place
to start. If the client simply wants to redirect new traffic to a "new"
location for the database then I'd have thought a load balancer configured
appropriately might be the appropriate solution.
On Mon, Aug 19, 2019 at 9:42 AM Sourav Biswas <biswas.sourav@xxxxxxxxxxx>
wrote:
Hi Everybody,
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
