SYED MANUAL CLONING PDB

ALTER PLUGGABLE DATABASE PDBTEST3 CLOSE;
ALTER PLUGGABLE DATABASE PDBTEST3 OPEN READ ONLY;

CREATE PLUGGABLE DATABASE PDBTEST4 FROM PDBTEST3
  FILE_NAME_CONVERT=('/data/oracle/oradata/CDBTES/PDBTEST3/','/data/oracle/oradata/CDBTES/PDBTEST4/');

ALTER PLUGGABLE DATABASE PDBTEST4 OPEN READ WRITE;

-- Switch the source PDB back to read/write
ALTER PLUGGABLE DATABASE PDBTEST3 CLOSE;
ALTER PLUGGABLE DATABASE PDBTEST3 OPEN READ WRITE;

============================================================================================
SQL> SELECT name, open_mode
  FROM   v$pdbs
  ORDER BY name;  2    3

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
PDBTEST1                       READ WRITE
PDBTEST2                       READ WRITE
PDBTEST3                       READ WRITE
SQL> ALTER PLUGGABLE DATABASE PDBTEST3 CLOSE;

Pluggable database altered.

SQL> ALTER PLUGGABLE DATABASE PDBTEST3 OPEN READ ONLY;

Pluggable database altered.

SQL> CREATE PLUGGABLE DATABASE PDBTEST4 FROM PDBTEST3
  FILE_NAME_CONVERT=('/data/oracle/oradata/CDBTES/PDBTEST3/','/data/oracle/oradata/CDBTES/PDBTEST4/');
  2
Pluggable database created.

SQL> ALTER PLUGGABLE DATABASE PDBTEST4 OPEN READ WRITE;

Pluggable database altered.

SQL> ALTER PLUGGABLE DATABASE PDBTEST3 OPEN READ WRITE;
ALTER PLUGGABLE DATABASE PDBTEST3 OPEN READ WRITE