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@xxxxxxxxx> 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
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@xxxxxxxxxxx>
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.
Thanks and Regards,
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | @zztat_oracle | fb.me/zztat | zztat.net/blog/