Re: Automation: DG Broker

From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Thu, 22 Aug 2019 08:53:47 -0400
Message-ID: <CAE-dsO+0K=BzwR1R=bYEceuGkFjwzWn-SCRnuxqMNC07k6uzPw_at_mail.gmail.com>



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> 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
Received on Thu Aug 22 2019 - 14:53:47 CEST

Original text of this message