Re: Automation: DG Broker

From: Sourav Biswas <>
Date: Tue, 20 Aug 2019 18:28:12 +0000
Message-ID: <BM1PR0101MB1394848FC91E458A0EE5662CF0AB0_at_BM1PR0101MB1394.INDPRD01.PROD.OUTLOOK.COM>

Thank you very much, Stefan and Rakesh !!!

I would certainly discuss these options with my clients.

Best Regards,
Sourav Biswas

From: Rakesh Ra <> Sent: Monday, August 19, 2019 5:48 PM
To: <> Cc: <>; Oracle-L Freelists <> 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 <<>> 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 <<>> 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

zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at<> | _at_zztat_oracle |<> |<>

Received on Tue Aug 20 2019 - 20:28:12 CEST

Original text of this message