Re: Automation: DG Broker

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_at_hotmail.com> 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
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l