Will the DDL,DML operations fail over to the other node if one instance goes down in RAC 19c
Hi all,
Quick question .
We have converted one node rac to rac database. We are testing the failover .
I'm trying to understand , the following will select , DML operations failover to the other instance 2 and will execute there (meaning resume) if there is failure on the instance1
When we have tested job which is running on node1 , the job failed(when we brought down node1) and when retired it ran successfully on node2/instance2
Does this mean DML operations will fail and will not be resumed unless there is any manual intervention . like retry .
IS this the same case with select , statement , will it failover to the second instance and resume there seemlessly without user knowing there is node failure