Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is it possible to have three Undo tablespaces for a 2 node RAC ?

MaxOct 12 2012 — edited Oct 12 2012

Version: 11.2.0.2/RHEL 5.4

I was under the impression that you need only one UNDO Tablespace for each instance. But , for our 2-node RAC, I can see three Undo tablespaces. Any idea what is the third one for ?

SQL> select tablespace_name,status from dba_tablespaces where CONTENTS = 'UNDO';

TABLESPACE_NAME                STATUS
------------------------------ ---------
UNDOTBS1                       ONLINE
UNDOTBS2                       ONLINE
UNDOTBS3                       ONLINE

SQL> select distinct inst_id from gv$session;

   INST_ID
----------
         1
         2


$ olsnodes -n
thclst214   1
thclst215   2

This post has been answered by Pierre Forstmann on Oct 12 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 9 2012

Added on Oct 12 2012

#performance-availability, #real-application-clusters

2 comments

533 views