Cloning a pluggable database

Not going to reinvent the wheel, all the information you need here :

https://oracle-base.com/articles/12c/multitenant-hot-clone-remote-pdb-or-non-cdb-12cr2

Some quick notes:

SQL> select con_id, name, open_mode, RESTRICTED from v$pdbs where NAME like 'MDS5FA%';

CON_ID NAME OPEN_MODE RES

---------- ------------------------------ ---------- ---
34 MDS5FA1 READ WRITE NO
39 MDS5FA1_20190626 MOUNTED
47 MDS5FA1_2JUN019 MOUNTED

SQL> alter session set container = MDS5FA1;

Session altered.

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------
34 MDS5FA1 READ WRITE NO

SQL> shutdown immediate;

Pluggable Database closed.

SQL> alter session set container = CDB$ROOT;

Session altered.

SQL> select con_id, name, open_mode, RESTRICTED from v$pdbs where NAME like 'MDS5FA%';

CON_ID NAME OPEN_MODE RES

---------- ------------------------------ ---------- ---
34 MDS5FA1 MOUNTED
39 MDS5FA1_20190626 MOUNTED
47 MDS5FA1_2JUN2019 MOUNTED

-- Use read only so no worries about date changes.

SQL> alter pluggable database MDS5FA1 open read only force;

Pluggable database altered.

SQL> create pluggable database MDS5FA1_10JUN2019 from MDS5FA1;