从NO-CDB 使用网络模式通过 full transportable export/import方式实现数据传输到PDB

当前位置：首页 > 新闻中心 > 疑问回答 > 从NO-CDB 使用网络模式通过 full transportable export/import方式实现数据传输到PDB

重庆思庄精品课程

RHCSA认证培训 RHCE RHCA认证培训

OCP OCM MySQL认证培训

CCNA CCNP CCIE

疑问回答

咨询电话

在线留言/报名

课程咨询 : 023-68429836

考试咨询 : 023-68037655

公司地址 :

重庆市九龙坡区科园三路南方花园B区银杉楼2单元10-1#

从NO-CDB 使用网络模式通过 full transportable export/import方式实现数据传输到PDB

发布时间：2021-10-20 00:00:00

1.在源端库（orcl）把表空间设置为只读
alter tablespace tsp_sztech read only;
alter tablespace users read only;
alter tablespace baseitem read only;

2. 创建公共db LINK,
   一定是公共link，否则，认不到
SQL> create public database link linkorcl
         connect to system identified by system
         using 'orcl';
3.拷贝对应只读表空间的数据文件到目标库（pdb1）所在位置
  scp file hostname:/u02/oradata/CDB1/pdb1/.

4.目标库导入

[oracle@dbserver admin]$
         impdp system/oracle_4U@192.168.133.134:1521/pdb1
         network_link=linkorcl
         transportable=always
         full=y
         transport_datafiles='/u02/oradata/CDB1/pdb1/baseitem01.dbf',
                                       '/u02/oradata/CDB1/pdb1/tsp_sztech01.dbf',
                                       '/u02/oradata/CDB1/pdb1/users01.dbf'
         logfile=imp2.log

Import: Release 19.0.0.0.0 - Production on Fri Mar 26 00:26:20 2021
Version 19.10.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYSTEM"."SYS_IMPORT_FULL_04":  system/********@192.168.133.134:1521/pdb1 network_link=linkorcl transportable=always full=y transport_datafiles=/u02/oradata/CDB1/pdb1/baseitem01.dbf,/u02/oradata/CDB1/pdb1/tsp_sztech01.dbf,/u02/oradata/CDB1/pdb1/users01.dbf logfile=imp2.log
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/PLUGTS_FULL/FULL/PLUGTS_TABLESPACE
Processing object type DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 5.796 MB
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists

... 此处略 300字

Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
Job "SYSTEM"."SYS_IMPORT_FULL_04" completed with 8 error(s) at Fri Mar 26 00:32:42 2021 elapsed 0 00:06:22

5.验证