PDB拔插

1.使用SQL DEVELOPER

2.使用语句

SQL> col pdb_name format A20

SQL> col status format A20

SQL> select pdb_name, status from cdb_pdbs;

PDB_NAME STATUS

PDBTEST NORMAL

PDB$SEED NORMAL 

CLONEPDB NORMAL

SQL> alter pluggable database clonepdb close immediate;

SQL> alter pluggable database clonepdb unplug into 'C:\app\Administrator\virtual\product\12.2.0\dbhome_2\database\clonepdb.xml';

SQL> select pdb_name, status from cdb_pdbs; 

-------------------- -------------------- PDBTEST NORMAL

PDB$SEED NORMAL

CLONEPDB UNPLUGGED

PDB_NAME STATUS -------------------- --------------------

PDB$SEED NORMAL CLONEPDB UNPLUGGED

SQL> drop pluggable database clonepdb keep datafiles;

插接式数据库已删除。

C:\Users\Administrator>mkdir C:\app\Administrator\virtual\oradata\newtest\clonepdb_plug 

C:\Users\Administrator>sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on 星期四 12月 14 15:47:00 2017

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

连接到:

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

SQL> create pluggable database clonepdb_plug using 'C:\app\Administrator\virtual\product\12.2.0\dbhome_2\database\clonepdb.xml' MOVE 2 FILE_NAME_CONVERT=('C:\app\Administrator\virtual\oradata\newtest\CLONEPDB','C:\app\Administrator\virtual\oradata\newtest\clonepdb_plug'); 

插接式数据库已创建。 

CLONEPDB_PLUG NEW

SQL> show pdbs

插接式数据库已变更。

CLONEPDB_PLUG NORMAL

     本文转自whshurk 51CTO博客，原文链接：http://blog.51cto.com/shurk/2050640，如需转载请自行联系原作者