Oracle 19c RAC TAF Demo | Transparent Application Failover with SQL*Plus

In this video, I demonstrate Transparent Application Failover (TAF) in an Oracle 19c RAC environment using SQL*Plus. In the first part of the demo, I show what happens when a RAC service fails over without TAF configured. The service successfully relocates from RACDB1 to RACDB2, but the existing SQL*Plus session is lost. Then I configure TAF on the RAC service and repeat the same failure scenario to demonstrate how the client session can fail over to the surviving RAC instance. Topics covered in this video: • Oracle 19c RAC TAF overview • Difference between service failover and session failover • RAC service configuration using SRVCTL • Preferred and available RAC instances • Configure TAF with `SELECT` failover type • Configure `BASIC` failover method • Configure failover retry and delay • Verify TAF configuration using `srvctl config service` • Connect to RAC using SCAN and service name • Verify client session using `V$SESSION` • Simulate RACDB1 instance failure • Observe service relocation to RACDB2 • Verify SQL*Plus session failover • Compare behavior before and after TAF configuration Lab Environment: Oracle Database 19c RAC Oracle Grid Infrastructure 19c Oracle Linux 8 2-Node RAC Cluster Oracle ASM SCAN Listener SQL*Plus TAF configuration used in this demo: `Failover Type: SELECT` `Failover Method: BASIC` `Failover Retries: 30` `Failover Delay: 5` This demonstration helps explain how Oracle RAC maintains service availability and how TAF can improve client-side availability during an instance failure. If you are learning Oracle RAC, high availability, Clusterware, services, SCAN, or failover concepts, this hands-on demo will help you understand how these features work in a real RAC environment. If you find this video useful, please Like, Subscribe, and share it with other Oracle DBAs. #OracleRAC #Oracle19c #TAF #TransparentApplicationFailover #OracleDBA #OracleClusterware #OracleASM #HighAvailability #SQLPlus #OracleDatabase #RACFailover #OracleLinux8