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

来源：互联网发布：上海办公软件培训编辑：程序博客网时间：2024/05/22 03:25

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 2016ALTER 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 2016DM00 started with pid=80, OS id=15357, job SYSTEM.SYS_IMPORT_SCHEMA_05Wed Sep 28 10:10:31 2016DW00 started with pid=84, OS id=15414, wid=1, job SYSTEM.SYS_IMPORT_SCHEMA_05Wed Sep 28 10:11:01 2016DW01 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=2Import: Release 11.2.0.4.0 - Production on Wed Sep 28 10:09:54 2016Copyright (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 ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsStarting "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_DATATotal estimation using BLOCKS method: 1.385 GBProcessing object type SCHEMA_EXPORT/USERProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type SCHEMA_EXPORT/TABLESPACE_QUOTAProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/DB_LINKProcessing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCEProcessing 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 rowsProcessing object type SCHEMA_EXPORT/TABLE/COMMENTProcessing object type SCHEMA_EXPORT/PROCEDURE/PROCEDUREProcessing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE

0 0