We will crete new pdb from unplugged database.
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 PLUG19_2 READ WRITE NO
SYS@ORCL19 SQL> alter pluggable database plug19_2 close immediate;
Pluggable database altered.
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 PLUG19_2 MOUNTED
Unplug the database in the pdb archive
SYS@ORCL19 SQL> alter pluggable database plug19_2 unplug into '/tmp/plug19_2.pdb';
Pluggable database altered.
Check the file
[ORCL19 user@host:~]> file /tmp/plug19_2.pdb
/tmp/plug19_2.pdb: Zip archive data, at least v3.0 to extract
We can drop the database including datafiles
SYS@ORCL19 SQL> drop pluggable database plug19_2 including datafiles;
Pluggable database dropped.
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
Create dtabase from the archive
SYS@ORCL19 SQL> create pluggable database plug19_3 using '/tmp/plug19_2.pdb';
Pluggable database created.
SYS@ORCL19 SQL> alter pluggable database plug19_3 open read write;
Pluggable database altered.
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
5 PLUG19_3 READ WRITE NO
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 PLUG19_2 READ WRITE NO
SYS@ORCL19 SQL> alter pluggable database plug19_2 close immediate;
Pluggable database altered.
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
4 PLUG19_2 MOUNTED
Unplug the database in the pdb archive
SYS@ORCL19 SQL> alter pluggable database plug19_2 unplug into '/tmp/plug19_2.pdb';
Pluggable database altered.
Check the file
[ORCL19 user@host:~]> file /tmp/plug19_2.pdb
/tmp/plug19_2.pdb: Zip archive data, at least v3.0 to extract
We can drop the database including datafiles
SYS@ORCL19 SQL> drop pluggable database plug19_2 including datafiles;
Pluggable database dropped.
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
Create dtabase from the archive
SYS@ORCL19 SQL> create pluggable database plug19_3 using '/tmp/plug19_2.pdb';
Pluggable database created.
SYS@ORCL19 SQL> alter pluggable database plug19_3 open read write;
Pluggable database altered.
SYS@ORCL19 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PLUG19 READ WRITE NO
5 PLUG19_3 READ WRITE NO