OraFAQ Forum: RAC & Failsafe » Dropping the 4th undo tablespace from a 3node RAC

Home » Server Options » RAC & Failsafe » Dropping the 4th undo tablespace from a 3node RAC (10gR2, Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Dropping the 4th undo tablespace from a 3node RAC [message #424321]

Thu, 01 October 2009 09:46

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