# 不同CDB之间迁移PDB

# 测试环境

源环境	目标环境
主机操作系统 Oracle Linux 7.2	主机操作系统 Oracle Linux 7.2
主机名zhankys	主机名zhanky2
Oracle版本 11.2.0.1 x64	Oracle版本 11.2.0.1 x64
IP：172.16.171.214	IP：172.16.171.215
CDB=orcl	CDB=cs
被克隆的PDB=orcl1	克隆后的PDB=cs2

测试思路

1、源端建立CP拥有create pluggable database和create session的权限（在PDB orcle1下创建用户）

2、将源端设置为只读模式（CDB模式下设置）

3、在目标端添加orcl1的tnsnames（在tnsnames.ora中添加）

4、在目标端创建orcle1的dblink：cp_link （在CDB模式下运行）

5、在目标端指定db_create_file_dest路径（在CDB模式下运行，如果目录不存在需事先创建）

6、执行克隆PDB语句（在CDB模式下运行）

7、检查数据是否正确(在PDB模式下运行) 源端 [oracle@zhanky ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Aug 3 16:21:35 2018

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> alter session set container=orcl1; SQL> select * from zky.aa;

# USERNAME

ZKY

1 rows selected.

SQL> create user cp identified by cp;

User created.

SQL> grant create session,create pluggable database to cp;

Grant succeeded.

SQL> alter session set container=CDB$ROOT; SQL> alter pluggable database orcl1 close;

Pluggable database altered.

SQL> show pdbs

CON_ID	CON_NAME	OPEN MODE	RESTRICTED
2	PDB$SEED	READ	ONLY
3	ORCL1	READ	ONLY
4	ORCL2	READ	WRITE

SQL>

目的端

[oracle@zhanky2 ~]$ vi /u01/app/oracle/product/12.2.0/db_1/network/admin/tnsnames.ora [oracle@zhanky2 ~]$ cat /u01/app/oracle/product/12.2.0/db_1/network/admin/tnsnames.ora

tnsnames.ora

# Generated by Oracle configuration tools.

LISTENER_CS = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.171/215)(PORT = 1521))

CS1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.171.215)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = cs1.zhanky.com) ) )

CS = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.171.215)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = cs.zhanky.com) ) )

orcl1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.171.214)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl1.zhanky.com) ) ) [oracle@zhanky2 ~]$ SQL> create database link cp_link connect to cp identified by cp using 'orcl1';

Database link created.

SQL> select count(*) from all_users@cp_link;

# COUNT(*)

SQL> alter system set db_create_file_dest='/u01/app/oracle/oradata/cs/cs2';

System altered.

SQL> create pluggable database cs2 from orcl1@cp_link;

Pluggable database created.

SQL> show pdbs

CON_ID CON_NAME              OPEN MODE  RESTRICTED

 2 PDB$SEED              READ ONLY  NO
 3 CS1                  READ WRITE NO
 4 CS2                  MOUNTED

SQL> alter session set container=cs2;

Session altered.

SQL> startup Pluggable Database opened. SQL> select * from zky.aa;

USERNAME
ZKY

1 rows selected.

SQL>

← mysql expdp 导出 →