Skip to content

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.

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: