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.