how to specify undo tablespace for a PDB (instance) in RAC?
Hi all,
Our CDB using local undo tablespace for each PDB.
I've create a new undo tablespace (in PDB1 session) and add it to an PDB instance, but when shutdown/startup PDB, all two instances using them same undo tablespace and the later start one will fail to start with message: "ORA-30013: undo tablespace 'UNDOTBS2' is currently in use"
on node 2, which currently open:
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
4 PDB1 READ WRITE NO
SQL> show parameter undo_tablespace
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_tablespace string UNDOTBS2
on node 1, which is close and need to open: