Re: Automation: DG Broker

From: Dba DBA <>
Date: Thu, 22 Aug 2019 08:53:47 -0400
Message-ID: <>

If you dont want to use oracle services or a trigger to handle this, you will need a shell script on primary/standby to poll the db to see if its primary/standby and use that to notify the server.

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

Received on Thu Aug 22 2019 - 14:53:47 CEST

Original text of this message