How to clone an Oracle pluggable database (PDB)

 

Step1> Bring the Source PDB in Read Only Mode

SQL> alter session set container=PDB;
Session altered.

SQL> alter pluggable database close immediate;
Pluggable database altered.

SQL> alter pluggable database open read only;
Pluggable database altered.

SQL> select con_id,name,open_mode,restricted from v$pdbs;
    CON_ID NAME       OPEN_MODE                      RESTRICTE
---------- ---------- ------------------------------ ---------
         2 PDB       READ ONLY                      NO

Step2> Clone the Source PDB

SQL> create pluggable database PDBCL from PDB ;
Pluggable database created.

SQL> select PDB_NAME,STATUS from cdb_pdbs;
PDB_NAME             STATUS
-------------------- ---------------------------
PDB$SEED           NORMAL
PDB                       NORMAL
PDBCL                  NEW

Step3> Open the Clone PDB

SQL> alter pluggable database PDBCL open;
Pluggable database altered.

Step4> Verify the Status of Clone PDB
SQL> select con_id,name,open_mode,restricted from v$pdbs;

Step5> Bring Back the Source PDB in Read Write Mode again
SQL> Alter pluggable database PDB close immediate;
SQL> Alter pluggable database PDB open;