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 | _at_zztat_oracle | fb.me/zztat | zztat.net/blog/
>

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