Re: Automation: DG Broker

From: Mladen Gogala <>
Date: Thu, 22 Aug 2019 11:12:41 -0400
Message-ID: <>

Of course, using automated fail-over is a terrible ide. Any power outage will trigger a fail-over. And contrary to what people are told, minor power outages do happen. After a fail-over you have to rebuild because fail-over does resetlogs.


On 8/22/19 8:53 AM, Dba DBA wrote:
> 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 - 17:12:41 CEST

Original text of this message