By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
This is related to RAC/TAF. I understand that when an instance fails, any active transaction will be rolled back after the failover completes and any select statements that were in progress when the failure happened will be replayed transparently after the failover. I would like to know what happens to any db calls (query or DML) that were done during the failover, i.e., the time after the instance failed and before the connection was established with the new instance. Are they lost? Or are they suspended and replayed after the failover?
I am not sure what you mean by transactions initiated after the failure and before the re-establishment of the session on the surviving node. You are correct that if TAF is configured properly most SELECT statements that were executing during the failure will be re-initiated on the surviving node and other statements such as uncommitted DML will be rolled back. However, by definition, after the instance has failed no additional transactions can be executed from that instance, so there would be no calls during the failover. Any transactions on the surviving node will be uneffected. Now, it's entirely possible I am not understanding your question so if that is the case please explain with an example or additional detail and I will be happy to provide a followup. Thanks.