Home » Server Options » RAC & Failsafe » Undo tablespace usage in rac env. (oracle 9.2.0.1.0. o/s : hp-ux 11:23 )
Undo tablespace usage in rac env. [message #391851] Sat, 14 March 2009 00:08 Go to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

Dear sir,

we have 2 nodes, and one undo tablespace per node. ( undotbs1 , undotbs2 )we have one more undo tablespace for instance2 which is not active( i.e. not set at instance level ) say undotbs3
if undotbs2 in instance2 is full, what will happen ?
the next available active undo tablespace undotbs1 ( in instance1 ) will be used for node 2 ?

pls adv.

kesavan.

[Updated on: Sat, 14 March 2009 01:49] by Moderator

Report message to a moderator

Re: Undo tablespace usage in rac env. [message #391858 is a reply to message #391851] Sat, 14 March 2009 01:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, only one undo tablespace is active per instance.

Regards
Michel
Re: Undo tablespace usage in rac env. [message #391872 is a reply to message #391858] Sat, 14 March 2009 02:43 Go to previous messageGo to next message
kesavansundaram
Messages: 181
Registered: October 2007
Location: MUMBAI
Senior Member

ok....then if node2 is not able to use the undo tablespace of node1 (i.e. undotbs1 ) , then node2 will use system rollback segments....? at database level...?

pls adv ?

thank you
kesavan

[Updated on: Sat, 14 March 2009 03:51] by Moderator

Report message to a moderator

Re: Undo tablespace usage in rac env. [message #391887 is a reply to message #391872] Sat, 14 March 2009 03:52 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't use code tags if it is not for code or formatted output.

No, it will not.

Regards
Michel
Previous Topic: RAC Load Balancing
Next Topic: Oracle Cluster Registry and Voting Files
Goto Forum:
  


Current Time: Fri Dec 09 11:35:07 CST 2016

Total time taken to generate the page: 0.18249 seconds