将一个pdb库从cdb容器库unplug

环境说明：cdbtest为cdb容器库

                  orcl和test为pdb库
现需将orcl库从cdb库中拔出

1、以sysdba用户连接到cdb容器库

[oracle@test ~]$ export ORACLE_SID=cdbtest
[oracle@test ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Nov 5 05:39:48 2015

Copyright (c) 1982, 2014, Oracle. All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select name,cdb from v$database;

NAME      CDB
--------- ---
CDBTEST   YES

2、确认cdb库中有多少个pdb库和状态

点击(此处)折叠或打开

SQL> show pdbs

    CON_ID CON_NAME              OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
     2 PDB$SEED              READ ONLY  NO
     4 TEST               MOUNTED
     5 ORCL               READ WRITE NO

3、关闭要拔出的orcl数据库

点击(此处)折叠或打开

SQL> alter pluggable database orcl close immediate;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME              OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
     2 PDB$SEED              READ ONLY  NO
     4 TEST               MOUNTED
     5 ORCL               MOUNTED

4、将orcl库从cdb容器库中拔出

SQL> alter pluggable database orcl unplug into '/soft/orcl.xml';

Pluggable database altered.

此步骤需要几分钟，原因是该操作需将orcl库的信息写入到xml文件中

5、清除cdb容器库中的orcl库的信息

点击(此处)折叠或打开

SQL> show pdbs

    CON_ID CON_NAME              OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
     2 PDB$SEED              READ ONLY  NO
     4 TEST               MOUNTED
     5 ORCL               MOUNTED
SQL> drop pluggable database orcl;

Pluggable database dropped.

SQL> show pdbs

    CON_ID CON_NAME              OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
     2 PDB$SEED              READ ONLY  NO
     4 TEST               MOUNTED

注意：drop pluggable database orcl;该命令会相应删除临时文件，从alert日志信息可以看到，执行这条命令的时候，后台日志会有如下信息：

drop pluggable database orcl
Thu Nov 05 05:50:34 2015
Deleted file /oradata/orcl/temp01.dbf
Completed: drop pluggable database orcl

至此pdb库已从cdb库中干净的拔出