Re: Automation: DG Broker

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.

Regards

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
> <biswas.sourav_at_hotmail.com <mailto: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
>

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