19c Unplug a PDB

拔掉PDB为 XML Metadata 格式文件

#ORA-65025: Pluggable database PDB06 is not closed on all instances.
#要拔掉的PDB状态必须为CLOSED,否则报错。
SQL> ALTER PLUGGABLE DATABASE PDB06 CLOSE instances=all;

Pluggable database altered.

SQL> ALTER PLUGGABLE DATABASE pdb06 UNPLUG INTO '/data/bak/pdb06.xml';

Pluggable database altered.

SQL> DROP PLUGGABLE DATABASE  pdb06;

Pluggable database dropped.

拔掉一个PDB为 Archive File格式

ALTER PLUGGABLE DATABASE PDB05 CLOSE instances=all;
ALTER PLUGGABLE DATABASE PDB05 UNPLUG INTO '/data/bak/pdb05.pdb';
DROP PLUGGABLE DATABASE  pdb05;

SQL> !unzip -t /data/bak/pdb05.pdb
Archive:  /data/bak/pdb05.pdb
    testing: system01.dbf             OK
    testing: sysaux01.dbf             OK
    testing: undotbs01.dbf            OK
    testing: users01.dbf              OK
    testing: /data/bak/pdb05.xml      OK
No errors detected in compressed data of /data/bak/pdb05.pdb.