Configuring a connection failover

Building a configuration in which database clients are able to automatically connect to a new primary database after a role change is vital in Data Guard. If we skip this important aspect, it may be very hard to configure connections of all database users to the new primary database.

Now, let's learn about the important connection failover terms – Transparent Application Failover (TAF), Fast Connection Failover (FCF), and Fast Application Notification (FAN).

Transparent Application Failover (TAF)

TAF is a connection failover configuration of Oracle Call Interface (OCI) that is used for high-availability environments such as Oracle Data Guard, Oracle Real Application Clusters (RAC), and Oracle Fail Safe.

When using this configuration, clients can automatically establish a prespecified connection to the database after a failure of the database instance. In RAC, this means connecting to one of the surviving instances and in Data Guard it means connecting to the...