Undo Tablespace in RAC

In RAC there must be one UNDO tablepsace for each instance. The entry in pfile must be (for 2 node instance prod1 and prod2)


prod1.undo_tablespace=UNDOTBS1

prod2.undo_tablespace=UNDOTBS2

• Each instance can use only one undo tablespace at a time (store undo information for that instance only).


• All instances can read block from any or all undo tablespaces for the purpose of Read consistency.


• Undo management mode must be same for all instances. Either Auto or Manual.

Thanks