Understanding Transparent Application Failover for SQR
This section describes Transparent Application Failover (TAF) for SQR.
TAF is a feature supported by Oracle Call Interface driver (OCI). SQR reports which are mostly read-only can take advantage of the TAF configuration. This enables the SQR reports to use failover and connect to the next available DB node to re-execute SQL queries automatically when there is a node failure.
The SQR engine code is modified to reconnect to the available DB nodes in the event of a DB node failure and execute the SQR Reports session specific variables, which would have been otherwise lost in the case of a DB node failure.
In addition, the SQR Engine writes informational messages to the SQR report log files to indicate the TAF fail over details for the SQR report.