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.

See Data Management: Working With Oracle Transparent Application Failover.