记一次19c本地端克隆pdb到目标端

mahan

首先确认目标端与本地端数据库版本一致
$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.

SQL>alter pluggable database PDB1 close;

SQL>alter pluggable database PDB1 open;

6、PDB保存打开状态，下次重启CDB，自动启动PDB
alter pluggable databse all save state;