Database - RAC/Scalability (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center