Re: Automation: DG Broker

From: Stefan Knecht <>
Date: Mon, 19 Aug 2019 16:56:14 +0700
Message-ID: <>

They way this was normally done is with 2 simple things:

This works with single instance data guard setups as well as RAC data guard setups.

No need to fiddle around with application servers or DNS at all.

Have a quick good on Oracle's MAA (maximum availabiltity architecture) - there's loads of documentation on this out there.

On Mon, Aug 19, 2019 at 3:41 PM 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

zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at | _at_zztat_oracle | |

Received on Mon Aug 19 2019 - 11:56:14 CEST

Original text of this message