PDB拔插
1.使用SQL DEVELOPER
2.使用语句
SQL> col pdb_name format A20
SQL> col status format A20
SQL> select pdb_name, status from cdb_pdbs;
创新互联是专业的丽江网站建设公司,丽江接单;提供成都网站制作、网站建设,网页设计,网站设计,建网站,PHP网站建设等专业做网站服务;采用PHP框架,可快速的进行丽江网站开发网页制作和功能扩展;专业做搜索引擎喜爱的网站,专业的做网站团队,希望更多企业前来合作!
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;
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:\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');
插接式数据库已创建。
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
标题名称:PDB拔插
浏览路径:http://pwwzsj.com/article/poggcg.html