Re: Automation: DG Broker

From: <>
Date: Mon, 19 Aug 2019 10:16:01 +0100
Message-ID: <>

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

Received on Mon Aug 19 2019 - 11:16:01 CEST

Original text of this message