Home » Server Options » RAC & Failsafe » Dropping the 4th undo tablespace from a 3node RAC (10gR2, Linux)
Dropping the 4th undo tablespace from a 3node RAC [message #424321] Thu, 01 October 2009 09:46 Go to next message
efachim
Messages: 42
Registered: July 2008
Member
I migrated a 4 instance RAC database from a 4 node server to a 3 node RAC database server. However, I still have the 4th undo tablespace and the 4th redo log thread. Are there any precautions I need to take before dropping the 4th undo tablespace? Must I also drop the 4th redo log thread, or will the database function properly even without a 4th node to go with the 4th thread?

I presume I have to also disable the 4th public thread? Is this the command below?

Alter database disable public thread=4;

[Updated on: Thu, 01 October 2009 09:53]

Report message to a moderator

Re: Dropping the 4th undo tablespace from a 3node RAC [message #424616 is a reply to message #424321] Sun, 04 October 2009 20:46 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Yes, you should disable the thread of the fourth node with the command you posted and drop the undo tablespace associated with the fourth node.
Previous Topic: Oracle9i&10g RAC
Next Topic: Problem in JDBC Connection (RAC in 11G Release 2 )
Goto Forum:
  


Current Time: Tue Jul 29 06:54:03 CDT 2014

Total time taken to generate the page: 0.08356 seconds