PDB的plugging和unpluged

来源：互联网发布：怎样变更淘宝店的地区编辑：程序博客网时间：2024/06/05 15:19

SQL> show pdbs    CON_ID CON_NAME                       OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------         2 PDB$SEED                       READ ONLY  NO         3 SEED_PDB                       MOUNTED         4 NONCDB_PDP                     MOUNTED         5 CLON_PDB                       MOUNTED         6 TEST_PDB                       READ WRITE NO         7 PDB4                           READ WRITE NO

SQL> Alter pluggable database pdb4 close;Pluggable database altered.SQL> Alter pluggable database pdb4 unplug into '/tmp/pdb4.xml';Pluggable database altered.

SQL> Drop pluggable database pdb4;Pluggable database dropped.SQL> show pdbs;    CON_ID CON_NAME                       OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------         2 PDB$SEED                       READ ONLY  NO         3 SEED_PDB                       MOUNTED         4 NONCDB_PDP                     MOUNTED         5 CLON_PDB                       MOUNTED         6 TEST_PDB                       READ WRITE NO

[oracle@12cr2 pdb4]$ cd /u01/app/oracle/oradata/zylong/pdb4[oracle@12cr2 pdb4]$ lltotal 706588-rw-r----- 1 oracle oinstall 356524032 Jun  4 19:04 sysaux01.dbf-rw-r----- 1 oracle oinstall 262152192 Jun  4 19:04 system01.dbf-rw-r----- 1 oracle oinstall 104865792 Jun  4 19:04 undotbs01.dbf

SQL> Create pluggable database pdb4 using '/tmp/pdb4.xml' copyfile_name_convert=('/u01/app/oracle/oradata/zylong','/u01/app/oracle/oradata/zylong/pdb4');Pluggable database created.SQL> show pdbs;    CON_ID CON_NAME                       OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------         2 PDB$SEED                       READ ONLY  NO         3 SEED_PDB                       MOUNTED         4 NONCDB_PDP                     MOUNTED         5 CLON_PDB                       MOUNTED         6 TEST_PDB                       READ WRITE NO         7 PDB4                           MOUNTED

SQL> Alter pluggable database pdb4 unplug into '/tmp/pdb4.xml';Pluggable database altered.SQL> Drop pluggable database pdb4;Pluggable database dropped.

SQL> Create pluggable database pdb4 using '/tmp/pdb4.xml' nocopy;Pluggable database created.SQL> show pdbs;    CON_ID CON_NAME                       OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------         2 PDB$SEED                       READ ONLY  NO         3 SEED_PDB                       MOUNTED         4 NONCDB_PDP                     MOUNTED         5 CLON_PDB                       MOUNTED         6 TEST_PDB                       READ WRITE NO         8 PDB4                           MOUNTED

SQL> Alter pluggable database pdb4 unplug into '/tmp/pdb4.xml';Pluggable database altered.SQL> Drop pluggable database pdb4;Pluggable database dropped.

SQL> CREATE PLUGGABLE DATABASE pdb4 AS CLONE USING '/tmp/pdb4.xml' NOCOPY TEMPFILE REUSE;Pluggable database created.SQL> show pdbs;    CON_ID CON_NAME                       OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------         2 PDB$SEED                       READ ONLY  NO         3 SEED_PDB                       MOUNTED         4 NONCDB_PDP                     MOUNTED         5 CLON_PDB                       MOUNTED         6 TEST_PDB                       READ WRITE NO         7 PDB4                           MOUNTED

阅读全文

0 0