使用RMAN DUPLICATE复制数据库(Oracle 12c)到本机

来源：互联网发布：华为网络机柜编辑：程序博客网时间：2024/06/05 14:26

--使用RMAN DUPLICATE复制数据库(Oracle 12c)到本机

--克隆CDB的方法与11g相同。
--PDB的克隆比CDB的克隆要简单且快。
--步骤
--1.克隆本机pdb
--create pluggable database pdb_new from pdb_old file_name_convert=('pdb_old路径','pdb_new路径')；
--*但是pdb_old需要在只读状态，alter pluggable database pdb_old close;
--2.克隆远程pdb
--create database link old12c connect to sys identified by oracle using 'tns_old_12c';
--create pluggable database pdb_new from pdb_old@old12c file_name_convert=('pdb_old路径','pdb_new路径')；

--实验--1.本机复制seed数据库为pdb1SQL> select con_id,name from v$datafile where con_id=2;  --容器编号为2的是seed库    CON_ID NAME---------- ------------------------------------------------------------ 2 /u01/oracle/oradata/wyzc/pdbseed/system01.dbf 2 /u01/oracle/oradata/wyzc/pdbseed/sysaux01.dbfSQL> select name,open_mode from v$pdbs;  --SEED库在只读状态NAME       OPEN_MODE------------------------------ ----------PDB$SEED       READ ONLYPDBWYZC        MOUNTEDSQL> create pluggable database pdb1 admin user pdb1 identified by oracle file_name_convert=('/u01/oracle/oradata/wyzc/pdbseed/','/u01/oracle/oradata/wyzc/pdb1/');Pluggable database created.克隆完成。--2.本机复制pdbwyzc到pdb2SQL> select name,open_mode from v$pdbs;NAME     OPEN_MODE------------------------------------------------------------ ----------PDB$SEED     READ ONLYPDBWYZC      MOUNTEDPDB1     MOUNTEDSQL> alter pluggable database pdbwyzc open read only;Pluggable database altered.SQL> select name,open_mode from v$pdbs;NAME     OPEN_MODE------------------------------------------------------------ ----------PDB$SEED     READ ONLYPDBWYZC      READ ONLYPDB1     MOUNTEDSQL> select con_id,name from v$pdbs;    CON_ID NAME---------- ------------------------------------------------------------ 2 PDB$SEED 3 PDBWYZC 4 PDB1SQL> select name from v$datafile where con_id=3;NAME------------------------------------------------------------/u01/oracle/oradata/wyzc/pdbwyzc/system01.dbf/u01/oracle/oradata/wyzc/pdbwyzc/sysaux01.dbf/u01/oracle/oradata/wyzc/pdbwyzc/SAMPLE_SCHEMA_users01.dbf/u01/oracle/oradata/wyzc/pdbwyzc/example01.dbfSQL> create pluggable database pdb2 from pdbwyzc file_name_convert=('/u01/oracle/oradata/wyzc/pdbwyzc/','/u01/oracle/oradata/wyzc/pdb2/');Pluggable database created.

0 0