从本地pdb克隆一个pdb
在容器数据库CDB1中克隆本地PDB1创建PDB3
PDB1 只读方式打开
SYS@cdb1> show pdbs
SYS@cdb1> alter pluggable database pdb1 close immediate;
SYS@cdb1> alter pluggable database pdb1 open read only;
SYS@cdb1> show pdbs
查看 PDB1 数据文件路径
SYS@cdb1> select file_name from cdb_data_files where con_id=3;
创建pdb3目录
SYS@cdb1> !mkdir /u01/app/oracle/oradata/cdb1/pdb3
创建 pdb3
SYS@cdb1> create pluggable database pdb3 from pdb1 file_name_convert=(‘pdb1’,‘pdb3’);
或者指定绝对路径：
SYS@cdb1> create pluggable database pdb3 from pdb1 file_name_convert=(’/u01/app/oracle/oradata/cdb1/pdb1’,’/u01/app/oracle/oradata/cdb1/pdb3’);
open 打开 pdb3
SYS@cdb1> show pdbs
SYS@cdb1> alter pluggable database pdb3 open;
SYS@cdb1> show pdbs
重新打开 pdb1
SYS@cdb1> alter pluggable database pdb1 close immediate;
SYS@cdb1> alter pluggable database pdb1 open;
SYS@cdb1> show pdbs
