重庆思庄Oracle、Redhat认证学习论坛

标题: 记一次19c本地端克隆pdb到目标端 [打印本页]

作者: mahan 时间: 2022-10-28 09:02
标题: 记一次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.

SQL>alter pluggable database PDB1 close;

SQL>alter pluggable database PDB1 open;

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

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)