FAN or TAF for application switchover/failover?
We are running Oracle 12.1.0.2 RAC on Active DataGuard environment (2 Physical Standby databases - all RAC).
We can easily switchover/failover the database via dgmgrl.
We are looking how to setup application failover/switchover to follow database switchover/failover.
Most of our applications connect to Oracle via OCI. Few of them via JDBC.
What is the best solution to set application switchover/failover for this environment? I am aware that there are few options (like FAN and TAF).
Any recommendation/documentation for those that have already set application switchover/failover in similar environment?
Thanks in advance, Brad.