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