重庆思庄Oracle、Redhat认证学习论坛

标题: 在同一个cdb中unplug 并 plugg pdb [打印本页]

作者: 郑全 时间: 2019-2-10 00:13
标题: 在同一个cdb中unplug 并 plugg pdb
1.查看pdb情况

SQL> show pdbs
CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
      3 ERP                         READ WRITE NO
      4 CRM                         READ WRITE NO

2.unplugg pdb

SQL> alter pluggable database crm close;
Pluggable database altered.

SQL> alter pluggable database crm unplug into '/u01/app/oracle/unplugdb.xml';
Pluggable database altered.

SQL> select pdb_name,status from dba_pdbs

PDB_NAME                      STATUS
------------------------------ ----------
ERP                         NORMAL
PDB$SEED                      NORMAL
CRM                         UNPLUGGED

SQL> show pdbs;
CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
      3 ERP                         READ WRITE NO
      4 CRM                         MOUNTED

SQL> drop pluggable database crm;
Pluggable database dropped.

SQL> show pdbs;
CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
      3 ERP                         READ WRITE NO

3.重新plugg pdb

SQL> CREATE PLUGGABLE DATABASE crm using '/u01/app/oracle/unplugdb.xml' nocopy TEMPFILE REUSE;
Pluggable database created.
SQL> show pdbs
CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      READ ONLY  NO
      3 ERP                         READ WRITE NO
      4 CRM                         MOUNTED
SQL>

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)