pdb迁移和克隆

百里长风 · 发表于 2018-3-25 11:52

---本地克隆pdb，需要把源pdb置于read only模式

alter pluggable database pdb2 open read only;

create pluggable database PDB1 from PDB2 file_name_convert=('/u01/app/oracle/oradata/pdbseed/pdb2/','/u01/app/oracle/oradata/pdbseed/pdb1/');

---远程克隆pdb，pdbadmin为pdb用户，cdb_pdb1为tnsnames.ora定义的字符创，为pdb的数据库名,/u01/app/oracle/oradata/CDB/pdbseed/cdb_pdb1为源pdb目录

create public database link cdb_pdb1_cdb connect to pdbadmin identified by pdbadmin using 'cdb_pdb1';

create pluggable database PROD_PDB1 from cdb_pdb1@cdb_pdb1_cdb file_name_convert=('/u01/app/oracle/oradata/CDB/pdbseed/cdb_pdb1/','/u01/app/oracle/oradata/pdbseed/prod_pdb1/');

远程克隆NON-CDB创建PDB

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname NOCDB -sid NOCDB -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 30 -emConfiguration LOCAL -createAsCon

tainerDatabase false -sysPassword oracle -systemPassword oracle;

create public database link NOCDB connect to system identified by oracle using 'nocdb';

create pluggable database NOCDB_PDB from NOCDB@NOCDB file_name_convert=('/u01/app/oracle/oradata/NOCDB/','/u01/app/oracle/oradata/pdbseed/NOCDB_PDB/');

@?/rdbms/admin/noncdb_to_pdb.SQL;