Database Administration (MOSC)

MOSC Banner

UNDO_2 tablespace in 2 node RAC PDB - 19c

Hello All

We are new to the PDB architecture and have a question on the UNDO tablespace in a RAC PDB

At CDB$ROOT container level we are seeing the 2 UNDO tablespaces as usual

SQL> select inst_id,num,value,display_value from GV$PARAMETER WHERE NAME = 'undo_tablespace';

INST_ID NUM VALUE DISPLAY_VALUE

     1       2589 UNDOTBS1        UNDOTBS1
2 2589 UNDOTBS2 UNDOTBS2

But once we connect to the PDB from either of the nodes, we are seeing this

SQL> select inst_id,num,value,display_value from GV$PARAMETER WHERE NAME = 'undo_tablespace';

SQL> select instance_name from v$instance;

INSTANCE_NAME

prodcont1

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