1  说明

When a pluggable database (PDB) is unplugged, all data files associated with a PDB along with the PDB manifest need to be copied or moved individually over to the remote server where it is plugged into another multitenant container database (CDB). With this new feature, a you can choose to create a single PDB archive file, a compressed file with the .pdb extension, that contains the PDB manifest and all of the data files when unplugging a PDB. When plugging in a PDB, the presence of a .pdb file is interpreted and the PDB is plugged into the CDB. You can choose to run the PDB plug-in compatibility test directly on the PDB archive without extracting the PDB manifest file from the archive.http://www.cndba.cn/Expect-le/article/2079

从12.2有了这个新功能，你可以选择创建一个单一的PDB归档文件，一个带有.pdb扩展名的压缩文件，其中包含PDB元数据和PDB的所有数据文件。http://www.cndba.cn/Expect-le/article/2079

这个功能很实用，大大减少了迁移PDB的复杂性。

图1 拔出PDB

2  实验

2.1   Unplug PDB

相应的PDB必须关闭，处于MOUNT状态。

SQL> show pdbs;
    CON_ID CON_NAME	  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
 2 PDB$SEED	  READ ONLY  NO
 3 LEI1   MOUNTED
 4 LEI2   MOUNTED
 5 SIHONG MOUNTED
 6 CNDBA_PDB_REF	  MOUNTED

http://www.cndba.cn/Expect-le/article/2079

2.1.1  导入到归档文件中(.pdb)

The sihong.pdb archive file is a compressed file that includes the XML metadata file and the PDB’s files (such as the data files and wallet file).

http://www.cndba.cn/Expect-le/article/2079

SQL> alter pluggable database sihong unplug into '/software/backup/sihong.pdb';
Pluggable database altered.

--看看文件大小

http://www.cndba.cn/Expect-le/article/2079

[oracle@db12CR2 backup]$ ll -h
total 440M
-rw-r--r-- 1 oracle oinstall 440M Aug  8 11:40 sihong.pdb

版权声明：本文为博主原创文章，未经博主允许不得转载。

PDB Archive Files