CNDBA社区
本实验注意模拟在不同的schema、tablespace,使用remap_schema和remap_tablespace参数
1.RAC端导出数据
[oracle@rac01 backup]$ expdp c##hbhe0316/wwwwww schemas=c##hbhe0316 directory=backup dumpfile=tbs02_20211003.dmp logfile=20211003dmp.log
Export: Release 19.0.0.0.0 - Production on Sun Oct 3 11:18:59 2021
Version 19.12.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
Warning: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.
Starting "C##HBHE0316"."SYS_EXPORT_SCHEMA_01": c##hbhe0316/******** schemas=c##hbhe0316 directory=backup dumpfile=tbs02_20211003.dmp logfile=20211003dmp.log
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
. . exported "C##HBHE0316"."T1" 3.973 MB 72710 rows
Master table "C##HBHE0316"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for C##HBHE0316.SYS_EXPORT_SCHEMA_01 is:
/home/oracle/backup/tbs01_20211003.dmp
Job "C##HBHE0316"."SYS_EXPORT_SCHEMA_01" successfully completed at Sun Oct 3 11:20:28 2021 elapsed 0 00:01:28
2.单实例端创建测试表空间、用户。
SQL> create tablespace tbs02 datafile '/oradata/ORCL/tbs02.dbf' size 1024m;
Tablespace created.
SQL> create user c##hbhe0317 identified by wwwwww default tablespace tbs02 temporary tablespace temp;
User created.
SQL> grant dba to c##hbhe0317;
Grant succeeded.
SQL> grant connect to c##hbhe0317;
Grant succeeded.
SQL> grant resource to c##hbhe0317;
Grant succeeded.
SQL> conn c##hbhe0317/wwwwww
Connected.
3.将导出的数据scp至单机环境
[oracle@rac01 backup]$ scp tbs02_20211003.dmp 192.168.56.100:/oradata/backup
4.导入数据至单实例环境
[oracle@db01 backup]$ impdp c##hbhe0316/wwwwww directory=backup remap_schema=c##hbhe0316:c##hbhe0317 remap_tablespace=tbs01:tbs02 dumpfile=tbs02_20211003.dmp
Import: Release 19.0.0.0.0 - Production on Sun Oct 3 11:27:49 2021
Version 19.12.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
Warning: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.
Master table "C##HBHE0316"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "C##HBHE0316"."SYS_IMPORT_FULL_01": c##hbhe0316/******** directory=backup remap_schema=c##hbhe0316:c##hbhe0317 remap_tablespace=tbs01:tbs02 dumpfile=tbs02_20211003.dmp
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "C##HBHE0317"."T1" 3.973 MB 72710 rows
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Job "C##HBHE0316"."SYS_IMPORT_FULL_01" successfully completed at Sun Oct 3 11:28:16 2021 elapsed 0 00:00:26
5.验证
SQL> conn c##hbhe0317/wwwwww
Connected.
SQL> select count(*) from t1;
COUNT(*)
----------
72710
版权声明：本文为博主原创文章，未经博主允许不得转载。
Linux,oracle
