Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is so special about TAF (compared to the normal failover) ?

T.BoydOct 3 2015 — edited Oct 5 2015

GI version: 11.2.0.4

OS : Oracle Linux 6.5

Question1.

By default (without TAF), when an instance crashes, the queries are failed over to another node. So, what advantage does Transparent Application Failover bring ?

Below is what 11.2 documentation says

http://docs.oracle.com/cd/E11882_01/network.112/e10836/advcfg.htm#NETAG338

"TAF can operate in one of two modes, Session Failover and Select Failover. Session Failover re-creates lost connections and sessions. Select Failover replays queries that were in progress."

I assume the regular failover (without TAF configured) has only Session failover. Am I right ? Are there any other advantages for TAF ?

Question2.

     The below doc says

http://docs.oracle.com/cd/E11882_01/java.112/e16548/ocitaf.htm#JJDBC28836

"Transparent Application Failover (TAF) is a feature of the Java Database Connectivity (JDBC) Oracle Call Interface (OCI) driver. "

The connection we make to the database using Development GUI tools like Toad, SQL Developer, Allround PL/SQL Developer use OCI driver. Right ?

This post has been answered by JohnWatson2 on Oct 5 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2015
Added on Oct 3 2015
3 comments
821 views