How to configure RAC 19c Application Continuity for CC&B 2.7 application. Inflight DML transaction s
I am looking for recommendations or steps to configure 19c RAC application continuity feature.
we have 3 node RAC and application CC&B 2.7
Requirement is during the node/network failure, my inflight transactions (dml) should move to available node and complete.
grant execute on DBMS_APP_CONT to user_name;
srvctl add service -db ORCL -service oracle_service -preferred rac11 -available rac2,rac3 -clbgoal SHORT -rlbgoal SERVICE_TIME -failoverretry 50 -failoverdelay 10 -commit_outcome TRUE -failover_restore LEVEL1 -failovertype TRANSACTION -replay_init_time 1800 -retention 86400 -notification TRUE -drain_timeout 300 -stopoption IMMEDIATE
Please check and let me know, what else we need to perform.