Database - RAC/Scalability (MOSC)

MOSC Banner

move undo tablespace in RAC

edited Feb 26, 2014 12:00PM in Database - RAC/Scalability (MOSC) 7 commentsAnswered

DB: Oracle 11gr2

RAC: 6 nodes

Existing TS = UNDOTBS_1

NEW TS     = UNDOTBS_01

I recently created new sets of UNDO tablespace in my RAC database for each instance.

Steps:

1. Created new tablespace UNDOTBS_01

2. ALTER SYSTEM SET undo_tablespace='UNDOTBS_01' scope=BOTH;

note: I ran this statement in each instance for their respective undo tablespace.

ie. in instance 1, alter system set undo_tablespace='UNDOTBS_01' scope=BOTH;

ie. in instance 2, alter system set undo_tablespace='UNDOTBS_02' scope=BOTH;

ie. in instance 1, alter system set undo_tablespace='UNDOTBS_03' scope=BOTH;

Questions: When I bounce the instance yesterday, I see the undo_tablespace parameter changed back to old TS UNDOTBS_1.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center