Database Administration (MOSC)

MOSC Banner

how to specify undo tablespace for a PDB (instance) in RAC?

edited Dec 10, 2018 10:42PM in Database Administration (MOSC) 5 commentsAnswered

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:

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