技术分享 记一次19c本地端克隆pdb到目标端

首先确认目标端与本地端数据库版本一致
$ORACLE_HOME/OPatch/opatch lspatches
1、设置目标端恢复文件存放位置，
alter system set remote_recovery_file_dest='ASM磁盘或文件系统';
2、tns文件添加连接串
cd $ORACLE_HOME/network/admin
vim tnsnames.ora
可以直接把本地端与目标端的连接串互相复制，注意tnsping检查通信
3、目标端进入rman
rman target sys/oracle_4U@orcl auxiliary sys/oracle_4U@orclcdb
4、活动复制
duplicate pluggable database PDB1 to orclcdb from active database;
duplicate pluggable database PDB2 to orclcdb from active database;
duplicate pluggable database PDB3 to orclcdb from active database;
duplicate pluggable database PDB4 to orclcdb from active database;
5、检查pdb能否正常关闭与启动
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
----------
------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE YES
SQL> alter session set container=PDB1;
Session altered.