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:appAdministratorvirtualproduct12.2.0dbhome_2databaseclonepdb.xml';
SQL> select pdb_name, status from cdb_pdbs; 
PDB_NAME STATUS
-------------------- -------------------- PDBTEST NORMAL
PDB$SEED NORMAL
CLONEPDB UNPLUGGED

SQL> select pdb_name, status from cdb_pdbs;

PDB_NAME STATUS -------------------- --------------------
PDBTEST NORMAL
PDB$SEED NORMAL CLONEPDB UNPLUGGED

SQL> drop pluggable database clonepdb keep datafiles;

插接式数据库已删除。

SQL> select pdb_name, status from cdb_pdbs;

PDB_NAME STATUS

PDBTEST NORMAL
PDB$SEED NORMAL 
C:UsersAdministrator>mkdir C:appAdministratorvirtualoradatanewtestclonepdb_plug 
C:UsersAdministrator>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:appAdministratorvirtualproduct12.2.0dbhome_2databaseclonepdb.xml' MOVE 2 FILE_NAME_CONVERT=('C:appAdministratorvirtualoradatanewtestCLONEPDB','C:appAdministratorvirtualoradatanewtestclonepdb_plug'); 
插接式数据库已创建。 
SQL> col status format A20
SQL> col pdb_name format A20
SQL> select pdb_name, status from cdb_pdbs;

PDB_NAME STATUS

PDBTEST NORMAL
PDB$SEED NORMAL
CLONEPDB_PLUG NEW
SQL> show pdbs

CON_ID CON_NAME
OPEN MODE
RESTRICTED

2 PDB$SEED
READ ONLY
NO
3 PDBTEST
READ WRITE NO
4 CLONEPDB_PLUG
MOUNTED
SQL> alter pluggable database CLONEPDB_PLUG open read write;

插接式数据库已变更。

SQL> show pdbs

CON_ID CON_NAME
OPEN MODE
RESTRICTED

2 PDB$SEED
READ ONLY
NO
3 PDBTEST
READ WRITE NO
4 CLONEPDB_PLUG
READ WRITE NO
SQL> select pdb_name, status from cdb_pdbs;

PDB_NAME STATUS

PDBTEST NORMAL
PDB$SEED NORMAL
CLONEPDB_PLUG NORMAL

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