目标端为rac 并行+network_link导入测试

最新推荐文章于 2025-06-18 09:32:04 发布

原创最新推荐文章于 2025-06-18 09:32:04 发布 · 514 阅读

0 ·

CC 4.0 BY-SA版权

本文记录了一次针对Oracle RAC环境的目标端进行并行导入测试的过程，包括环境配置、导入脚本、日志输出等内容，并对测试中遇到的问题进行了记录。

目标端为rac 并行+network_link导入测试

drop user DF cascade;
drop user RPORT cascade;

drop tablespace DF_TRAC  including contents and datafiles;
drop tablespace RPORT_TRAC  including contents and datafiles;

create tablespace DF_TRAC datafile '+DATA' size 3G;
create tablespace RPORT_TRAC datafile '+DATA' size 2G;

扩展闪回

ALTER SYSTEM SET db_recovery_file_dest_size=6G scope=both;

tnsname.ora
[oracle@node1 ~]$ cat /u01/app/oracle/product/11.2.4/db_1/network/admin/tnsnames.ora

    # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.4/db_1/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.

    RACDB =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = scan-vip)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = racdb)
        )
      )

expdp 脚本

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK 
time impdp  system/oracle321 schemas=DF,RPORT remap_tablespace=DF_TBS:DF_TRAC,RPORT_TBS:RPORT_TRAC DIRECTORY=EXPDP network_link=link_imp211racdb logfile=racdb_2userimpdp_test.log EXCLUDE=STATISTICS CLUSTER=N PARALLEL=2

日志输出

Warning: VKTM detected a time drift.
Time drifts can result in an unexpected behavior such as time-outs. Please check trace file for more details.
Wed Sep 28 10:10:06 2016
ALTER SYSTEM SET service_names='SYS$SYS.KUPC$C_1_20160928100957.RACDB' SCOPE=MEMORY SID='racdb1';
ALTER SYSTEM SET service_names='SYS$SYS.KUPC$C_1_20160928100957.RACDB','SYS$SYS.KUPC$S_1_20160928100957.RACDB' SCOPE=MEMORY SID='racdb1';
Wed Sep 28 10:10:14 2016
DM00 started with pid=80, OS id=15357, job SYSTEM.SYS_IMPORT_SCHEMA_05
Wed Sep 28 10:10:31 2016
DW00 started with pid=84, OS id=15414, wid=1, job SYSTEM.SYS_IMPORT_SCHEMA_05

Wed Sep 28 10:11:01 2016
DW01 started with pid=85, OS id=16081, wid=2, job SYSTEM.SYS_IMPORT_SCHEMA_05

–************************************************************************************–
导出过程

[oracle@node1 ~]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK 
[oracle@node1 ~]$ time impdp  system/oracle321 schemas=DF,RPORT remap_tablespace=DF_TBS:DF_TRAC,RPORT_TBS:RPORT_TRAC DIRECTORY=EXPDP network_link=link_imp211racdb logfile=racdb_2userimpdp_test.log EXCLUDE=STATISTICS CLUSTER=N PARALLEL=2
Import: Release 11.2.0.4.0 - Production on Wed Sep 28 10:09:54 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_05":  system/******** schemas=DF,RPORT remap_tablespace=DF_TBS:DF_TRAC,RPORT_TBS:RPORT_TRAC DIRECTORY=EXPDP network_link=link_imp211racdb logfile=racdb_2userimpdp_test_201609281.log EXCLUDE=STATISTICS CLUSTER=N PARALLEL=2 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 1.385 GB
Processing object type SCHEMA_EXPORT/USER
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/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . imported "DF"."DF_WHITE_LIST"                        284993 rows
. . imported "DF"."DF_ORDERS"                            364106 rows
. . imported "DF"."DF_CARD_LIMIT"                       1375449 rows
. . imported "DF"."DF_LOG"                               745312 rows
. . imported "DF"."DF_TRXS"                              362646 rows
. . imported "DF"."DF_IDENTIFY_ACCOUNT"                  150524 rows
. . imported "RPORT"."BALANCE_CUSTOMER_ACC_CHECK"       732161 rows
. . imported "RPORT"."BALANCE_TIME_POINT"               734952 rows
. . imported "DF"."DF_BATCH"                             191342 rows
. . imported "DF"."DF_TRADE"                              97444 rows
. . imported "DF"."DF_ACCOUNT_COMMAND_SAF"                97444 rows
. . imported "DF"."DF_SETTLE"                             97444 rows
. . imported "DF"."DF_MERCHANT_CARD_LIMIT"                97444 rows
. . imported "RPORT"."STL_TRADE"                         59537 rows
. . imported "DF"."DF_ROUTE_CONFIG_LOG"                    3735 rows
. . imported "DF"."DF_WHITE_BATCH"                       184127 rows
. . imported "RPORT"."ACCOUNT_TIME_POINT"                 1808 rows
. . imported "RPORT"."FT_SRV_FOOT_SETTING"                1813 rows
. . imported "DF"."DF_SYN"                                 2739 rows
. . imported "RPORT"."FT_TRADE"                            605 rows
. . imported "RPORT"."RISK_DEPOSIT_GOLD_INFO"              731 rows
. . imported "DF"."DF_MERCHENT_CONFIG"                       17 rows
. . imported "DF"."DF_ROUTE_CONFIG"                         168 rows
. . imported "DF"."DF_RATE_CONFIG_INFO"                      16 rows
. . imported "RPORT"."BALANCE_TEMP_AMOUNT"                   9 rows
. . imported "RPORT"."BF_CCB_CHECKRPT"                       1 rows
. . imported "RPORT"."BF_CCB_RPT"                            2 rows
. . imported "RPORT"."FT_LIQUIDATE"                        106 rows
. . imported "RPORT"."MONITOR_SMS_TIMES"                    33 rows
. . imported "RPORT"."RISK_CUSTOMER"                         2 rows
. . imported "RPORT"."TAB_0_0"                              19 rows
. . imported "RPORT"."TAB_0_4"                              75 rows
. . imported "RPORT"."TAB_1_11"                              1 rows
. . imported "RPORT"."TAB_1_12"                              1 rows
. . imported "RPORT"."TAB_1_9"                               1 rows
. . imported "RPORT"."TAB_1_5"                               1 rows
. . imported "RPORT"."TAB_IN_OUT_MONEY"                     10 rows
. . imported "RPORT"."TAB_IN_OUT_MONEY_CHANNEL"              6 rows
. . imported "DF"."DF_TSTNEWATE_CONFIG_INFO"                  0 rows
. . imported "RPORT"."STL01"                                 0 rows
. . imported "RPORT"."STL02"                                 0 rows
. . imported "RPORT"."STL03"                                 0 rows
. . imported "RPORT"."STL04"                                 0 rows
. . imported "RPORT"."STL06"                                 0 rows
. . imported "RPORT"."STL07"                                 0 rows
. . imported "RPORT"."STL08"                                 0 rows
. . imported "RPORT"."TAB_0_1"                               0 rows
. . imported "RPORT"."TAB_0_2"                               0 rows
. . imported "RPORT"."TAB_0_3"                               0 rows
. . imported "RPORT"."TAB_1_1"                               0 rows
. . imported "RPORT"."TAB_1_10"                              0 rows
. . imported "RPORT"."TAB_1_2"                               0 rows
. . imported "RPORT"."TAB_1_3"                               0 rows
. . imported "RPORT"."TAB_1_4"                               0 rows
. . imported "RPORT"."TAB_1_6"                               0 rows
. . imported "RPORT"."TAB_IN_OUT_MONEY_CUST"                 0 rows
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE