Re: Automation: DG Broker

Sourav ,
Client automatic failover is totally fine through role based services (11g+/Oracle restart).
Here is a detailed example I previously described in my blog https://koussilicious.blogspot.com/2019/02/deploying-oracle-active-data-guard-12c_12.html

Check the section "7.2 :CONFIGURATION OF THE FAILOVER CLIENT" you may find what you are looking for.

Regards
Koss

On Tue, Aug 20, 2019 at 2:29 PM Sourav Biswas <biswas.sourav_at_hotmail.com> wrote:

> Thank you very much, Stefan and Rakesh !!!
>
> I would certainly discuss these options with my clients.
>
>
>
>
>
>
> Best Regards,
> Sourav Biswas
> +91-9650017306
>
> ------------------------------
> *From:* Rakesh Ra <rakeshra.tr_at_gmail.com>
> *Sent:* Monday, August 19, 2019 5:48 PM
> *To:* knecht.stefan_at_gmail.com <knecht.stefan_at_gmail.com>
> *Cc:* biswas.sourav_at_hotmail.com <biswas.sourav_at_hotmail.com>; Oracle-L
> Freelists <oracle-l_at_freelists.org>
> *Subject:* Re: Automation: DG Broker
>
> Yes as Steve mentioned role based services can do the trick if you are in
> 11.2 and above.. this doesn't requires a manual intervention.
>
> On Mon, Aug 19, 2019, 15:27 Stefan Knecht <knecht.stefan_at_gmail.com> wrote:
>
> They way this was normally done is with 2 simple things:
>
> - services which are tied to the database role
> - connection strings that use the service (as opposed to SID) and
> reference both the primary and standby site with a proper timeout
>
> 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 <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
>
>
>
> --
> //
> zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
> Visit us at zztat.net
> <https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fzztat.net%2F&data=02%7C01%7C%7C8b72c2f41df544316a5508d7249f5240%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637018139003098690&sdata=MsHcI1hKVqm4QDIY8LgLBzgH0zk8wIxM8nroeuFwRJQ%3D&reserved=0> |
> _at_zztat_oracle | fb.me/zztat
> <https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Ffb.me%2Fzztat&data=02%7C01%7C%7C8b72c2f41df544316a5508d7249f5240%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637018139003118701&sdata=aLOvbhzr6IB49SoX3dGdcBEvcvCmA0f9A1IsWwpksX0%3D&reserved=0>
> | zztat.net/blog/
> <https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fzztat.net%2Fblog%2F&data=02%7C01%7C%7C8b72c2f41df544316a5508d7249f5240%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637018139003138712&sdata=vp6iExZVYwApn77sFEwU6dwvl0DO6A8Bb9D%2BcUBGSlo%3D&reserved=0>
>
>

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