Home » Server Options » RAC & Failsafe » connection (RAC 10g)
connection [message #323932] Fri, 30 May 2008 01:30 Go to next message
maoro
Messages: 310
Registered: May 2005
Senior Member
hello

if there is a RAC configuration, with 3 nodes and one shared storage
and one user is connected to this RAC database
and one of these nodes fails,

does this user have to reconnect and lose the transactions that
he did not commit yet?

thanks
Re: connection [message #323974 is a reply to message #323932] Fri, 30 May 2008 03:27 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
you said "node" and if the failing node is the one user was connected to then all work that are not yet committed will be lost.

if it's the instance that is failing and if you have configured TAF or FCF then user doesn't have to reconnect but still have to rerun the transaction of uncommitted work. With TAF you can have the select statements failover and continue from where they left off.
Re: connection [message #324369 is a reply to message #323932] Mon, 02 June 2008 03:38 Go to previous message
maoro
Messages: 310
Registered: May 2005
Senior Member
that was helpful thanks
Previous Topic: rac question
Next Topic: Real Application Clusters (merged)
Goto Forum:
  


Current Time: Sat Dec 03 22:39:49 CST 2016

Total time taken to generate the page: 0.09706 seconds