Application failover to the correct Oracle DB instance (Data Guard, not RAC cluster)

Using an Oracle Data Guard with a Primary and Standby database instance, is there a way to use a JDBC driver to send to the correct DB instance (or more specifically, to allow the application to fail over to the Standby  database instance if the primary is down)

I examined the documentation and the JDBC drivers appear to be for a RAC cluster as opposed to the Data Guard Primary and Standby

Can some one please help clarify ?

Thanks
NCSU44Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

65tdRetiredCommented:
A fail over or switch over will bring the standby db online and become the primary db and application should reconnect.
The standby db is only available to the Primary DB in a DataGuard cluster.

See Oracle link on failover and switch over:  https://docs.oracle.com/cd/B28359_01/server.111/b28295/sofo.htm#CHDEHEEF

Data Guard broker:  https://docs.oracle.com/cd/B28359_01/server.111/b28295/concepts.htm#i1013106
0
Geert GOracle dbaCommented:
a standby isn't active
by default you can't connect to it

with dataguard, you could setup the option to open the standby database read only at certain times
this if for running reports, and other read only items

don't consider the standby as an active component in your databases
it's sleeping
0
NCSU44Author Commented:
Yes, I understand in Data Guard, the Primary is active and the Standby is passive until there is a failover on the database side

There are two failovers

1> the database failover:  when the Primary fails over to the Standby

2> the application failover to the correct DB instance

What I am asking about is 2> application failover

In an application failover, do you have to rely upon a GSLB to reroute the traffic to the currently active instance, or can you use a JDBC driver or other driver on the application end ?

Thanks
0
slightwv (䄆 Netminder) Commented:
I'm not a Data Guard Expert in that I don't know everything there is to know about it.

What are you tying to get out of "application to fail over"?  Do you want queries to continue, DML to eventually commit, etc. (Transparent Application Failover - TAF) or just current connections to stop and reconnect/start over on the standby?

With JDBC there appears to be something called  Fast Connection Failover (FCF).  In some quick reading there appears to be some extra setup and system engineering to get it all working.

Seamless Application Failover with Oracle Data Guard
http://www.oracle.com/technetwork/database/availability/s316927-1-175930.pdf

Client Failover Best Practices for Highly Available Oracle Databases Oracle Database 12c
http://www.oracle.com/technetwork/database/availability/client-failover-2280805.pdf
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.