Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent, 2 instances on same server, instance failover scenario..
> You also have tansparent application failover where if node 1 drops
> processing of the process can be picked up and continued on another
> node. But this has to be coded into your applicaion.
> HTH -- Mark D Powell --
What Mark appears to be hinting at or (to most of us familiar with TAF limitations) stating is that most applications that are useful to business users are not SELECT only.
Any active, non-committed transaction ( aka INSERT, UPDATE, or DELETE ) is rolled back at the time of failure, because TAF cannot preserve active transactions after failover.
The application will receive an error message until a rollback command is submitted.
Since Mr. Morgan does not appear to be familiar with this ... ( it means you have to code this into your applications ) ... does this help Mr. Morgan? Received on Mon Jul 18 2005 - 08:12:59 CDT