Skip to content

Archive for

ORA-65036: pluggable database HRPDB not open in required mode

when i trying to clone the pluggable database, i am getting below error

SQL> CREATE PLUGGABLE DATABASE salespdb FROM hrpdb;
CREATE PLUGGABLE DATABASE salespdb FROM hrpdb
*
ERROR at line 1:
ORA-65036: pluggable database HRPDB not open in required mode

Solution :

If a PDB is in local undo mode, then the source PDB can be open in read/write mode during the operation, referred to as hot cloning.

local undo mode
The use of a separate set of undo data files for each PDB in a CDB.

hot cloning
Cloning a PDB while the source PDB is open in read/write mode.

SQL> show pdbs;

CON_ID CON_NAME                       OPEN MODE  RESTRICTED

     2 PDB$SEED                       READ ONLY  NO
     3 ORAPDB                         READ WRITE NO
     4 HRPDB                          MOUNTED

SQL> alter pluggable database hrpdb open;

Pluggable database altered.

SQL> show pdbs;

CON_ID CON_NAME                       OPEN MODE  RESTRICTED

     2 PDB$SEED                       READ ONLY  NO
     3 ORAPDB                         READ WRITE NO
     4 HRPDB                          READ WRITE NO

SQL> CREATE PLUGGABLE DATABASE salespdb FROM hrpdb;

Pluggable database created.