实验环境：

SQL> select * from v$version;

BANNER                                                                               CON_ID

-------------------------------------------------------------------------------- ----------

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production              0

PL/SQL Release 12.2.0.1.0 - Production                                                    0

CORE    12.2.0.1.0      Production

TNS for Linux: Version 12.2.0.1.0 - Production                                           0

NLSRTL Version 12.2.0.1.0 - Production                                                    0

 

一、 手工创建 PDB

SQL>SELECT NAME,CDBFROM V$DATABASE;

SQL>show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 PDB01                          READ WRITE NO

SQL> alter session set container=pdb$seed;

SQL> 

set lin 400;

col name for a60;

select * from v$dbfile;

     FILE# NAME                                                             CON_ID

---------- ------------------------------------------------------------ ----------

         5 /home/oracle/app/oracle/oradata/ANDYCDB/datafile/o1_mf_syste          2

           m_djsz1z31_.dbf

         6 /home/oracle/app/oracle/oradata/ANDYCDB/datafile/o1_mf_sysau          2

           x_djsz1z2x_.dbf

         8 /home/oracle/app/oracle/oradata/ANDYCDB/datafile/o1_mf_undot          2

           bs1_djsz1z34_.dbf

SQL> create pluggable database pdb02 admin user pdb02 identified by pdb02

file_name_convert=('pdbseed','pdb02');

ORA-65005: missing or invalid file name pattern for file -

/home/oracle/app/oracle/oradata/ANDYCDB/datafile/o1_mf_system_djsz1z31_.dbf

SQL> alter session set db_create_file_dest='/home/oracle/app/oracle/oradata/';

SQL> create pluggable database pdb02 admin user pdb02 identified by pdb02;

Pluggable database created.

说明：使用了OMF格式的文件名，目标库无法使用convert转换，只能配置db_create_file_dest同样对于该PDB使用OMF。

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED  READ ONLY  NO

3 PDB01  READ WRITE NO

4 PDB02  MOUNTED

SQL> alter pluggable database pdb02 open;

Pluggable database altered.

二、手工删除 PDB

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED  READ ONLY  NO

3 PDB01  READ WRITE NO

4 PDB02  READ WRITE NO

SQL> alter session set container=pdb02;

Session altered.

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/home/oracle/app/oracle/oradata/ANDYCDB/ANDYCDB/4F21240B3F45400BE0531019640A46FB

/datafile/o1_mf_system_dk4oy9tr_.dbf

/home/oracle/app/oracle/oradata/ANDYCDB/ANDYCDB/4F21240B3F45400BE0531019640A46FB

/datafile/o1_mf_sysaux_dk4oy9xy_.dbf

/home/oracle/app/oracle/oradata/ANDYCDB/ANDYCDB/4F21240B3F45400BE0531019640A46FB

/datafile/o1_mf_undotbs1_dk4oy9y1_.dbf

SQL> alter session set container=cdb$root;

Session altered.

drop pdb 方式一：including DATAFILES

SQL> drop pluggable database pdb02 including datafiles;

ERROR at line 1:   > 报错说明删除pdb，这个pdb要在 close 状态。 

ORA-65025: Pluggable database PDB02 is not closed on all instances.

SQL> alter pluggable database pdb02 close immediate;

Pluggable database altered.

SQL> drop pluggable database pdb02 including datafiles;

Pluggable database dropped.

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED  READ ONLY  NO

3 PDB01  READ WRITE NO

[oracle@12c01 ~]cd  /home/oracle/app/oracle/oradata/ANDYCDB/ANDYCDB/4F21240B3F45400BE0531019640A46FB/datafile

[oracle@12c01 datafile]$ ll

total 0     > 操作系统层对应的文件也一并删除了

drop pdb 方式二：keep DATAFILES

SQL> show pdbs

    CON_ID CON_NAME  OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED  READ ONLY  NO

3 PDB01  READ WRITE NO

SQL> alter session set container=pdb01;

Session altered.

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/home/oracle/app/oracle/oradata/ANDYCDB/4ECF8621E3DA38EEE0531019640AA598/datafil

e/o1_mf_system_djszmxhq_.dbf

/home/oracle/app/oracle/oradata/ANDYCDB/4ECF8621E3DA38EEE0531019640AA598/datafil

e/o1_mf_sysaux_djszmxkb_.dbf

/home/oracle/app/oracle/oradata/ANDYCDB/4ECF8621E3DA38EEE0531019640AA598/datafil

e/o1_mf_users_djszpsmt_.dbf

/home/oracle/app/oracle/oradata/ANDYCDB/4ECF8621E3DA38EEE0531019640AA598/datafil

e/o1_mf_undo_1_djz4jq1z_.dbf

NAME

--------------------------------------------------------------------------------

SQL> alter session set container=cdb$root;

Session altered.

SQL> alter pluggable database pdb01 close immediate;

Pluggable database altered.

SQL>alter pluggable database pdb01 unplug into '/home/oracle/pdb01.xml';

Pluggable database altered.

SQL> drop pluggable database pdb01 keep datafiles;

Pluggable database dropped.

[oracle@12c01 ~]cd /home/oracle/app/oracle/oradata/ANDYCDB/4ECF8621E3DA38EEE0531019640AA598/datafile

[oracle@12c01 datafile]$ ll

total 775720

-rw-r-----. 1 oracle oinstall 408952832 May 10 18:02 o1_mf_sysaux_djszmxkb_.dbf

-rw-r-----. 1 oracle oinstall 272637952 May 10 18:02 o1_mf_system_djszmxhq_.dbf

-rw-r-----. 1 oracle oinstall 104865792 May 10 18:02 o1_mf_undo_1_djz4jq1z_.dbf > 操作系统层对应的文件没有被删除

-rw-r-----. 1 oracle oinstall   7872512 May 10 18:02 o1_mf_users_djszpsmt_.dbf

说明：在drop PDB的时候，有2种方式 keep DATAFILES 和 including DATAFILES,默认是KEEP