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
|
|
|
|