| connection [message #323932] |
Fri, 30 May 2008 01:30  |
maoro
Messages: 312
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  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
