dbdao吧 关注:1,183贴子:4,074
  • 8回复贴,共1

AIX oracle 11.2.0.3 expdp 导出分区表时卡住

取消只看楼主收藏回复

刘大,你好,我遇到以下问题,求助!
AIX oracle 11.2.0.3 expdp 导出分区表时卡住,一直处在以下界面,status查看一直在处理对象,但是很慢,schema下有45张表,表分区有1万5千多

用exp能正常导出
这是什么原因呐?


1楼2015-12-23 19:58回复
    刘大,辛苦!
    我重新测试了下
    ============================表分区信息如下============================
    select count(*) from dba_tab_partitions where table_owner='TT'
    count(*)
    15615
    select count(*) from dba_tab_subpartitions where table_owner='TT'
    count(*)
    765135
    ===========================EXPDP============================================
    expdp system/passwd directory=dump_dir dumpfile=TT_20151224_%U.dmp logfile=TT_20151224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no parallel=8 compression=all trace=480300
    Export: Release 11.2.0.3.0 - Production on Thu Dec 24 09:18:37 2015
    Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
    Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
    Data Mining and Real Application Testing options
    FLASHBACK automatically enabled to preserve database integrity.
    Starting "SYSTEM"."EXPDP_TT_JOB": system/******** directory=dump_dir dumpfile=TT_20151224_%U.dmp logfile=TT_20151224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no parallel=8
    Estimate in progress using BLOCKS method...
    Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
    Export> status
    Job: EXPDP_TT_JOB
    Operation: EXPORT
    Mode: SCHEMA
    State: EXECUTING
    Bytes Processed: 0
    Current Parallelism: 8
    Job Error Count: 0
    Dump File: /app/backup/temp/TT_20151224_01.dmp
    bytes written: 4,096
    Dump File: /app/backup/temp/TT_20151224_%u.dmp
    Worker 1 Status:
    Process Name: DW00
    State: EXECUTING
    Object Schema: TT
    Object Name: TT_208
    Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
    Completed Objects: 146,000
    Worker Parallelism: 1
    Export> status
    Job: EXPDP_TT_JOB
    Operation: EXPORT
    Mode: SCHEMA
    State: EXECUTING
    Bytes Processed: 0
    Current Parallelism: 8
    Job Error Count: 0
    Dump File: /app/backup/temp/TT_20151224_01.dmp
    bytes written: 4,096
    Dump File: /app/backup/temp/TT_20151224_%u.dmp
    Worker 1 Status:
    Process Name: DW00
    State: EXECUTING
    Object Schema: TT
    Object Name: TT_208
    Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
    Completed Objects: 148,960
    Worker Parallelism: 1
    Export> status
    Job: EXPDP_TT_JOB
    Operation: EXPORT
    Mode: SCHEMA
    State: EXECUTING
    Bytes Processed: 0
    Current Parallelism: 8
    Job Error Count: 0
    Dump File: /app/backup/temp/TT_20151224_01.dmp
    bytes written: 4,096
    Dump File: /app/backup/temp/TT_20151224_%u.dmp
    Worker 1 Status:
    Process Name: DW00
    State: EXECUTING
    Object Schema: TT
    Object Name: TT_208
    Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
    Completed Objects: 152,000
    Worker Parallelism: 1
    Export> status
    Job: EXPDP_TT_JOB
    Operation: EXPORT
    Mode: SCHEMA
    State: EXECUTING
    Bytes Processed: 0
    Current Parallelism: 8
    Job Error Count: 0
    Dump File: /app/backup/temp/TT_20151224_01.dmp
    bytes written: 4,096
    Dump File: /app/backup/temp/TT_20151224_%u.dmp
    Worker 1 Status:
    Process Name: DW00
    State: EXECUTING
    Object Schema: TT
    Object Name: TT_302
    Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
    Completed Objects: 188,000
    Worker Parallelism: 1
    Export> status
    Job: EXPDP_TT_JOB
    Operation: EXPORT
    Mode: SCHEMA
    State: EXECUTING
    Bytes Processed: 0
    Current Parallelism: 8
    Job Error Count: 0
    Dump File: /app/backup/temp/TT_20151224_01.dmp
    bytes written: 4,096
    Dump File: /app/backup/temp/TT_20151224_%u.dmp
    Worker 1 Status:
    Process Name: DW00
    State: EXECUTING
    Object Schema: TT
    Object Name: TT_103
    Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
    Completed Objects: 254,000
    Worker Parallelism: 1
    Export> status
    Job: EXPDP_TT_JOB
    Operation: EXPORT
    Mode: SCHEMA
    State: EXECUTING
    Bytes Processed: 0
    Current Parallelism: 8
    Job Error Count: 0
    Dump File: /app/backup/temp/TT_20151224_01.dmp
    bytes written: 4,096
    Dump File: /app/backup/temp/TT_20151224_%u.dmp
    Worker 1 Status:
    Process Name: DW00
    State: EXECUTING
    Object Schema: TT
    Object Name: TT_201
    Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
    Completed Objects: 256,000
    Worker Parallelism: 1
    Export>
    一直缓慢进行,就算一晚上过去还是这个状态......


    3楼2015-12-24 12:55
    回复
      2026-01-06 04:29:41
      广告
      不感兴趣
      开通SVIP免广告
      =============================TRACE=====================================
      System name: AIX
      Node name: DB1
      Release: 1
      Version: 7
      Machine:
      Instance name: node1
      Redo thread mounted by this instance: 1
      Oracle process number: 228
      Unix process pid: 22676206, image: oracle@DB1 (DM00)
      *** 2015-12-24 09:18:43.132
      *** SESSION ID:(498.8381) 2015-12-24 09:18:43.132
      *** CLIENT ID:() 2015-12-24 09:18:43.132
      *** SERVICE NAME:(SYS$USERS) 2015-12-24 09:18:43.132
      *** MODULE NAME:(Data Pump Master) 2015-12-24 09:18:43.132
      *** ACTION NAME:(EXPDP_TT_JOB) 2015-12-24 09:18:43.132
      KUPC: Setting remote flag for this process to FALSE
      prvtaqis - Enter
      prvtaqis subtab_name upd
      prvtaqis sys table upd
      KUPP: Initialization complete for master process DM00
      *** 2015-12-24 09:18:44.273
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656144 lascn 22
      *** 2015-12-24 09:18:46.098
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656144 lascn 22
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      *** 2015-12-24 09:18:46.726
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257654983 lascn 22
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656144 lascn 22
      *** 2015-12-24 09:30:21.802
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656144 lascn 22
      kwqberlst !retval block
      *** 2015-12-24 09:49:42.929
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      *** 2015-12-24 09:49:47.822
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      *** 2015-12-24 09:50:07.283
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      *** 2015-12-24 09:50:28.695
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      *** 2015-12-24 09:54:38.869
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      *** 2015-12-24 09:54:42.299
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      *** 2015-12-24 10:03:05.511
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      *** 2015-12-24 10:03:21.178
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      *** 2015-12-24 12:19:21.934
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      *** 2015-12-24 12:26:42.559
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst !retval block
      kwqberlst rqan->lagno_kwqiia 8
      kwqberlst rqan->lascn_kwqiia > 0 block
      kwqberlst rqan->lascn_kwqiia 8
      kwqberlst ascn -257656164 lascn 22
      ===================================EXP======================================
      exp system/passwd file=/app/backup/temp/TT_20151223.dmp log=/app/backup/temp/TT_20151223.log OWNER=TT
      导出大小:64G
      导出时间:8小时
      未能分析出原因所在!


      4楼2015-12-24 12:57
      回复
        关掉并行有日志显示,搜集table,partition,subpartition信息:
        expdp system/passwd directory=dump_dir dumpfile=TT_20151224.dmp logfile=TT_20151224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no trace=480300
        Export: Release 11.2.0.3.0 - Production on Thu Dec 24 09:18:37 2015
        Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
        Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
        With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
        Data Mining and Real Application Testing options
        FLASHBACK automatically enabled to preserve database integrity.
        Starting "SYSTEM"."EXPDP_TT_JOB": system/******** directory=dump_dir dumpfile=TT_20151224.dmp logfile=TT_20151224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no trace=480300
        Estimate in progress using BLOCKS method...
        Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
        Export> status
        Job: EXPDP_TT_JOB
        Operation: EXPORT
        Mode: SCHEMA
        State: EXECUTING
        Bytes Processed: 0
        Current Parallelism: 1
        Job Error Count: 0
        Dump File: /app/backup/temp/TT_20151224.dmp
        bytes written: 4,096
        Worker 1 Status:
        Process Name: DW00
        State: EXECUTING
        Object Schema: TT
        Object Name: TT_209
        Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
        Completed Objects: 160,000
        Worker Parallelism: 1
        Export> status
        Job: EXPDP_TT_JOB
        Operation: EXPORT
        Mode: SCHEMA
        State: EXECUTING
        Bytes Processed: 0
        Current Parallelism: 1
        Job Error Count: 0
        Dump File: /app/backup/temp/TT_20151224.dmp
        bytes written: 4,096
        Worker 1 Status:
        Process Name: DW00
        State: EXECUTING
        Object Schema: TT
        Object Name: TT_302
        Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
        Completed Objects: 194,000
        Worker Parallelism: 1


        7楼2015-12-24 16:30
        回复
          Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
          With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
          Data Mining and Real Application Testing options
          ORACLE_HOME = /app/oracle/product/11.2.0/db_1
          System name: AIX
          Node name: DB1
          Release: 1
          Version: 7
          Machine:
          Instance name: node1
          Redo thread mounted by this instance: 1
          Oracle process number: 729
          Unix process pid: 9765324, image: oracle@DB1 (DW00)
          *** 2015-12-24 14:54:08.646
          *** SESSION ID:(2971.10545) 2015-12-24 14:54:08.646
          *** CLIENT ID:() 2015-12-24 14:54:08.646
          *** SERVICE NAME:(SYS$BACKGROUND) 2015-12-24 14:54:08.646
          *** MODULE NAME:() 2015-12-24 14:54:08.646
          *** ACTION NAME:() 2015-12-24 14:54:08.646
          KUPP:14:54:08.639: Current trace/debug flags: 00480300 = 4719360
          *** MODULE NAME:(Data Pump Worker) 2015-12-24 14:54:08.646
          *** ACTION NAME:(EXPDP_TT_JOB) 2015-12-24 14:54:08.646
          KUPW:14:54:08.646: 0: ALTER SESSION ENABLE PARALLEL DML called.
          KUPW:14:54:08.646: 0: ALTER SESSION ENABLE PARALLEL DML returned.
          *** 2015-12-24 14:54:08.668
          KUPC:14:54:08.668: Setting remote flag for this process to FASSE
          prvtaqis - Enter
          prvtaqis subtab_name upd
          prvtaqis sys table upd
          KUPW:14:54:08.758: 0: KUPP$PROC.WHATS_MY_ID called.
          KUPW:14:54:08.758: 1: KUPP$PROC.WHATS_MY_ID returned.
          KUPW:14:54:08.759: 1: worker max message number: 1000
          KUPW:14:54:08.761: 1: Cluster access disabled - all workers and slaves local
          KUPW:14:54:08.762: 1: Original job start time: 15-DEC-24 02:54:07 PM
          KUPW:14:54:08.765: 1: Seqno 63 is SCHEMA_EXPORT/TABLE/TABLE_DATA
          KUPW:14:54:08.765: 1: Seqno 243 is SCHEMA_EXPORT/TABLE/INDEX/TABLE_DATA
          KUPW:14:54:08.765: 1: KUPP$PROC.WHATS_MY_NAME called.
          KUPW:14:54:08.765: 1: KUPP$PROC.WHATS_MY_NAME returned. Process name: DW00
          KUPW:14:54:08.765: 1: KUPV$FT_INT.GET_INSTANCE_ID called.
          KUPW:14:54:08.765: 1: KUPV$FT_INT.GET_INSTANCE_ID returned. Instance name: SCDB1:gzsthxzg1
          KUPW:14:54:08.767: 1: ALTER SESSION ENABLE RESUMABLE called.
          KUPW:14:54:08.768: 1: ALTER SESSION ENABLE RESUMABLE returned.
          KUPW:14:54:08.769: 1: KUPF$FILE.INIT called.
          KUPW:14:54:08.784: 1: KUPF$FILE.INIT returned.
          KUPW:14:54:08.787: 1: KUPF$FILE.GET_MAX_CSWIDTH called.
          KUPW:14:54:08.787: 1: KUPF$FILE.GET_MAX_CSWIDTH returned.
          KUPW:14:54:08.787: 1: Max character width: 4
          KUPW:14:54:08.787: 1: Max clob fetch: 8181
          KUPW:14:54:08.787: 1: Max varchar2a size: 8181
          KUPW:14:54:08.787: 1: Max varchar2 size: 1990
          KUPW:14:54:08.787: 1: In procedure GET_PARAMETERS
          KUPW:14:54:08.789: 1: In procedure GET_METADATA_FILTERS
          KUPW:14:54:08.790: 1: In procedure GET_METADATA_TRANSFORMS
          KUPW:14:54:08.791: 1: In procedure GET_DATA_FILTERS
          KUPW:14:54:08.792: 1: In procedure GET_DATA_REMAPS
          KUPW:14:54:08.792: 1: In procedure PRINT_MT_PARAMS
          KUPW:14:54:08.792: 1: Master table : "SYSTEM"."EXPDP_TT_JOB"
          KUPW:14:54:08.792: 1: Metadata job mode : SCHEMA_EXPORT
          KUPW:14:54:08.792: 1: Debug enable : TRUE
          KUPW:14:54:08.792: 1: Profile enable : FASSE
          KUPW:14:54:08.792: 1: Transportable enable : FASSE
          KUPW:14:54:08.792: 1: Metrics enable : FASSE
          KUPW:14:54:08.793: 1: db version : 11.2.0.3.0
          KUPW:14:54:08.793: 1: job version : 11.2.0.0.0
          KUPW:14:54:08.793: 1: service name :
          KUPW:14:54:08.793: 1: Current Edition : ORA$BASE
          KUPW:14:54:08.793: 1: Job Edition :
          KUPW:14:54:08.793: 1: Abort Step : 0
          KUPW:14:54:08.793: 1: Access Method : AUTOMATIC
          KUPW:14:54:08.793: 1: Data Options : 0
          KUPW:14:54:08.793: 1: Dumper directory :
          KUPW:14:54:08.793: 1: Master only : FASSE
          KUPW:14:54:08.793: 1: Data Only : FASSE
          KUPW:14:54:08.793: 1: Metadata Only : FASSE
          KUPW:14:54:08.793: 1: Estimate : BLOCKS
          KUPW:14:54:08.793: 1: Data error logging table :
          KUPW:14:54:08.793: 1: Remote Link :
          KUPW:14:54:08.793: 1: Dumpfile present : TRUE
          KUPW:14:54:08.793: 1: Table Exists Action :
          KUPW:14:54:08.793: 1: Partition Options : NONE
          KUPW:14:54:08.793: 1: Tablespace Datafile Count: 0
          KUPW:14:54:08.793: 1: Metadata Filter Index : 1 Count : 8
          KUPW:14:54:08.793: 1: 1 Name - INCLUDE_USER
          KUPW:14:54:08.793: 1: Value - TRUE
          KUPW:14:54:08.793: 1: Object Name - SCHEMA_EXPORT
          KUPW:14:54:08.793: 1: 2 Name - SCHEMA_EXPR
          KUPW:14:54:08.793: 1: Value - IN ('TT')
          KUPW:14:54:08.793: 1: 3 Name - ORDERED
          KUPW:14:54:08.793: 1: Value - FASSE
          KUPW:14:54:08.793: 1: Object - TABLE_DATA
          KUPW:14:54:08.793: 1: 4 Name - NO_XML
          KUPW:14:54:08.793: 1: Value - TRUE
          KUPW:14:54:08.793: 1: Object - XMSSCHEMA/EXP_XMSSCHEMA
          KUPW:14:54:08.793: 1: 5 Name - XML_OUTOFLINE
          KUPW:14:54:08.793: 1: Value - FASSE
          KUPW:14:54:08.793: 1: Object - TABLE/TABLE_DATA
          KUPW:14:54:08.793: 1: 6 Name - XDB_GENERATED
          KUPW:14:54:08.793: 1: Value - FASSE
          KUPW:14:54:08.793: 1: Object - TABLE/TRIGGER
          KUPW:14:54:08.793: 1: 7 Name - XDB_GENERATED
          KUPW:14:54:08.793: 1: Value - FASSE
          KUPW:14:54:08.794: 1: Object - TABLE/RSS_POLICY
          KUPW:14:54:08.794: 1: 8 Name - PRIVILEGED_USER
          KUPW:14:54:08.794: 1: Value - TRUE
          KUPW:14:54:08.794: 1: MD remap schema Index : 4 Count : 0
          KUPW:14:54:08.794: 1: MD remap other Index : 5 Count : 0
          KUPW:14:54:08.794: 1: MD Transform ddl Index : 2 Count : 11
          KUPW:14:54:08.794: 1: 1 Name - DBA
          KUPW:14:54:08.794: 1: Value - TRUE
          KUPW:14:54:08.794: 1: Object - JOB
          KUPW:14:54:08.794: 1: 2 Name - EXPORT
          KUPW:14:54:08.794: 1: Value - TRUE
          KUPW:14:54:08.794: 1: 3 Name - PRETTY
          KUPW:14:54:08.794: 1: Value - FASSE
          KUPW:14:54:08.794: 1: 4 Name - SQLTERMINATOR
          KUPW:14:54:08.794: 1: Value - FASSE
          KUPW:14:54:08.794: 1: 5 Name - CONSTRAINTS
          KUPW:14:54:08.794: 1: Value - FASSE
          KUPW:14:54:08.794: 1: Object - TABLE
          KUPW:14:54:08.794: 1: 6 Name - REF_CONSTRAINTS
          KUPW:14:54:08.794: 1: Value - FASSE
          KUPW:14:54:08.794: 1: Object - TABLE
          KUPW:14:54:08.794: 1: 7 Name - OID
          KUPW:14:54:08.794: 1: Value - TRUE
          KUPW:14:54:08.794: 1: Object - TABLE
          KUPW:14:54:08.794: 1: 8 Name - RESET_PARALLEL
          KUPW:14:54:08.794: 1: Value - TRUE
          KUPW:14:54:08.794: 1: Object - INDEX
          KUPW:14:54:08.794: 1: 9 Name - OID
          KUPW:14:54:08.794: 1: Value - TRUE
          KUPW:14:54:08.794: 1: Object - TYPE
          KUPW:14:54:08.794: 1: 10 Name - OID
          KUPW:14:54:08.794: 1: Value - TRUE
          KUPW:14:54:08.794: 1: Object - INC_TYPE
          KUPW:14:54:08.794: 1: 11 Name - REVOKE_FROM
          KUPW:14:54:08.794: 1: Value - SYSTEM
          KUPW:14:54:08.795: 1: Object - ROLE


          8楼2015-12-24 16:38
          回复
            一直就处在这个阶段,很慢很慢!


            10楼2015-12-24 16:44
            回复
              node1_dm00_7995838.trc
              Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
              With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
              Data Mining and Real Application Testing options
              ORACLE_HOME = /app/oracle/product/11.2.0/db_1
              System name: AIX
              Node name: DB1
              Release: 1
              Version: 7
              Machine:
              Instance name: node1
              Redo thread mounted by this instance: 1
              Oracle process number: 725
              Unix process pid: 7995838, image: oracle@SB1 (DM00)
              *** 2015-12-24 14:54:06.995
              *** SESSION ID:(2481.4441) 2015-12-24 14:54:06.995
              *** CLIENT ID:() 2015-12-24 14:54:06.995
              *** SERVICE NAME:(SYS$USERS) 2015-12-24 14:54:06.995
              *** MODULE NAME:() 2015-12-24 14:54:06.995
              *** ACTION NAME:() 2015-12-24 14:54:06.995
              KUPP:14:54:06.987: Current trace/debug flags: 00480300 = 4719360
              *** MODULE NAME:(Data Pump Master) 2015-12-24 14:54:07.015
              *** ACTION NAME:(EXPDP_TT_JOB) 2015-12-24 14:54:07.015
              KUPC:14:54:07.015: Setting remote flag for this process to FALSE
              prvtaqis - Enter
              prvtaqis subtab_name upd
              prvtaqis sys table upd
              KUPM:14:54:07.071: Attached to control queue as MCP
              KUPM:14:54:07.072: While starting, control queue subscriber count is: 2
              KUPP:14:54:07.072: Initialization complete for master process DM00
              KUPM:14:54:07.087: Entered main loop
              KUPM:14:54:07.096: ****IN DISPATCH at 53647, request type=1001
              KUPM:14:54:07.096: Current user is: SYSTEM
              KUPM:14:54:07.096: hand := DBMS_DATAPUMP.OPEN ('EXPORT', 'SCHEMA', '', 'EXPDP_TT_JOB', '', '2');
              KUPM:14:54:07.211: Resumable enabled
              KUPM:14:54:07.218: Entered state: DEFINING
              KUPM:14:54:07.218: initing file system
              KUPM:14:54:07.236: ****OUT DISPATCH, request type=1001, response type =2041
              kwqberlst !retval block
              kwqberlst rqan->lagno_kwqiia 8
              kwqberlst rqan->lascn_kwqiia > 0 block
              kwqberlst rqan->lascn_kwqiia 8
              kwqberlst ascn -249373909 lascn 22
              KUPM:14:54:07.269: ****IN DISPATCH at 53647, request type=1035
              KUPM:14:54:07.269: Current user is: SYSTEM
              KUPM:14:54:07.269: DBMS_DATAPUMP.SET_PARAMETER (hand, 'TRACE', 4719360);
              KUPM:14:54:07.269: In Check_param_dependency with name: TRACE
              KUPM:14:54:07.271: ****OUT DISPATCH, request type=1035, response type =2041
              kwqberlst !retval block
              kwqberlst rqan->lagno_kwqiia 8
              kwqberlst rqan->lascn_kwqiia > 0 block
              kwqberlst rqan->lascn_kwqiia 8
              kwqberlst ascn -249373909 lascn 22
              KUPM:14:54:07.353: ****IN DISPATCH at 53647, request type=1022
              KUPM:14:54:07.353: Current user is: SYSTEM
              KUPM:14:54:07.353: DBMS_DATAPUMP.ADD_FILE (hand, 'TT_20151224.log', 'DUMP_DIR', 0, , 3);
              KUPM:14:54:07.358: ****OUT DISPATCH, request type=1022, response type =2041
              kwqberlst !retval block
              kwqberlst rqan->lagno_kwqiia 8
              kwqberlst rqan->lascn_kwqiia > 0 block
              kwqberlst rqan->lascn_kwqiia 8
              kwqberlst ascn -249373909 lascn 22
              KUPM:14:54:07.374: ****IN DISPATCH at 53647, request type=1012
              KUPM:14:54:07.375: Current user is: SYSTEM
              KUPM:14:54:07.375: DBMS_DATAPUMP.LOG_ENTRY (hand, ';;;
              Export: Release 11.2.0.3.0 - Production on Thu Dec 24 14:54:03 2015
              Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
              ', 1);
              KUPM:14:54:07.375: Log message received from shadow:
              KUPM:14:54:07.375: RQ,KUPC$C_1_20151224145406,KUPC$A_1_145406787940000,MCP,4,Y
              KUPM:14:54:07.375: ;;;
              Export: Release 11.2.0.3.0 - Production on Thu Dec 24 14:54:03 2015
              Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
              KUPM:14:54:07.375: ****OUT DISPATCH, request type=1012, response type =2041
              kwqberlst !retval block
              kwqberlst rqan->lagno_kwqiia 8
              kwqberlst rqan->lascn_kwqiia > 0 block
              kwqberlst rqan->lascn_kwqiia 8
              kwqberlst ascn -249373909 lascn 22
              KUPM:14:54:07.390: ****IN DISPATCH at 53647, request type=1012
              KUPM:14:54:07.390: Current user is: SYSTEM
              KUPM:14:54:07.390: DBMS_DATAPUMP.LOG_ENTRY (hand, ';;;
              Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
              With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
              Data Mining and Real Applicati
              KUPM:14:54:07.391: on Testing options', 1);
              KUPM:14:54:07.391: Log message received from shadow:
              KUPM:14:54:07.391: RQ,KUPC$C_1_20151224145406,KUPC$A_1_145406787940000,MCP,5,Y
              KUPM:14:54:07.391: ;;;
              Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
              With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
              Data Mining and Real Application Testing options
              KUPM:14:54:07.391: ****OUT DISPATCH, request type=1012, response type =2041
              kwqberlst !retval block
              kwqberlst rqan->lagno_kwqiia 8
              kwqberlst rqan->lascn_kwqiia > 0 block
              kwqberlst rqan->lascn_kwqiia 8
              kwqberlst ascn -249373909 lascn 22
              KUPM:14:54:07.407: ****IN DISPATCH at 53647, request type=1035
              KUPM:14:54:07.407: Current user is: SYSTEM


              11楼2015-12-24 16:49
              回复
                KUPM:14:54:07.407: DBMS_DATAPUMP.SET_PARAMETER (hand, 'COMMAND_LINE_CLIENT', 1);
                KUPM:14:54:07.407: In Check_param_dependency with name: COMMAND_LINE_CLIENT
                KUPM:14:54:07.408: ****OUT DISPATCH, request type=1035, response type =2041
                kwqberlst !retval block
                kwqberlst rqan->lagno_kwqiia 8
                kwqberlst rqan->lascn_kwqiia > 0 block
                kwqberlst rqan->lascn_kwqiia 8
                kwqberlst ascn -249373909 lascn 22
                KUPM:14:54:07.424: ****IN DISPATCH at 53647, request type=1035
                KUPM:14:54:07.424: Current user is: SYSTEM
                KUPM:14:54:07.424: DBMS_DATAPUMP.SET_PARAMETER (hand, 'CLIENT_COMMAND', 'system/******** directory=dump_dir dumpfile=TT_20151224.dmp
                logfile=TT_20151224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no trace=480300 ');
                KUPM:14:54:07.424: In Check_param_dependency with name: CLIENT_COMMAND
                KUPM:14:54:07.426: ****OUT DISPATCH, request type=1035, response type =2041
                kwqberlst !retval block
                kwqberlst rqan->lagno_kwqiia 8
                kwqberlst rqan->lascn_kwqiia > 0 block
                kwqberlst rqan->lascn_kwqiia 8
                kwqberlst ascn -249373909 lascn 22
                KUPM:14:54:07.446: ****IN DISPATCH at 53647, request type=1032
                KUPM:14:54:07.446: Current user is: SYSTEM
                KUPM:14:54:07.446: In metadata filter....
                KUPM:14:54:07.446: DBMS_DATAPUMP.METADATA_FILTER (hand, 'SCHEMA_LIST', ''TT'', '');
                KUPM:14:54:07.466: ****OUT DISPATCH, request type=1032, response type =2041
                kwqberlst !retval block
                kwqberlst rqan->lagno_kwqiia 8
                kwqberlst rqan->lascn_kwqiia > 0 block
                kwqberlst rqan->lascn_kwqiia 8
                kwqberlst ascn -249373909 lascn 22
                KUPM:14:54:07.496: ****IN DISPATCH at 53647, request type=1022
                KUPM:14:54:07.496: Current user is: SYSTEM
                KUPM:14:54:07.496: DBMS_DATAPUMP.ADD_FILE (hand, 'TT_20151224.dmp', 'DUMP_DIR', 0, , 1);
                KUPM:14:54:07.608: ****OUT DISPATCH, request type=1022, response type =2041
                kwqberlst !retval block
                kwqberlst rqan->lagno_kwqiia 8
                kwqberlst rqan->lascn_kwqiia > 0 block
                kwqberlst rqan->lascn_kwqiia 8
                kwqberlst ascn -249373909 lascn 22
                KUPM:14:54:07.627: ****IN DISPATCH at 53647, request type=1003
                KUPM:14:54:07.627: Current user is: SYSTEM
                KUPM:14:54:07.627: DBMS_DATAPUMP.START_JOB (hand, 0, 0, , 0);
                KUPM:14:54:07.630: ...defaulting parameter ESTIMATE
                KUPM:14:54:07.631: ...defaulting parameter COMPRESSION
                KUPM:14:54:07.633: ...defaulting parameter DATA_ACCESS_METHOD
                KUPM:14:54:07.633: ...defaulting parameter DATA_OPTIONS
                KUPM:14:54:07.634: ...defaulting parameter INCLUDE_METADATA
                KUPM:14:54:07.634: ...defaulting parameter KEEP_MASTER
                KUPM:14:54:07.634: ...defaulting parameter MASTER_ONLY
                KUPM:14:54:07.634: ...defaulting parameter METRICS
                KUPM:14:54:07.635: ...defaulting parameter REUSE_DATAFILES
                KUPM:14:54:07.635: ...defaulting parameter SKIP_UNUSABLE_INDEXES
                KUPM:14:54:07.635: ...defaulting parameter STREAMS_CONFIGURATION
                KUPM:14:54:07.635: ...defaulting parameter TABLE_CONSISTENCY
                KUPM:14:54:07.636: ...defaulting parameter TABLE_EXISTS_ACTION
                KUPM:14:54:07.636: ...defaulting parameter TTS_FULL_CHECK
                KUPM:14:54:07.636: ...defaulting parameter USER_METADATA
                *** 2015-12-24 14:54:07.668
                KUPM:14:54:07.668: Log message received from MCP
                KUPM:14:54:07.668: FLASHBACK automatically enabled to preserve database integrity.
                kwqberlst rqan->lascn_kwqiia > 0 block
                kwqberlst rqan->lascn_kwqiia 7
                kwqberlst ascn -249373885 lascn 22
                KUPM:14:54:07.671: Safe SCN asserted on start with cookie: S:8:GZSTHXZG:
                KUPM:14:54:08.072: Stmt to load DATAPUMP_PATHS is: INSERT INTO "SYSTEM"."EXPDP_TT_JOB" (process_order, duplicate, object_path_se
                qno, object_type_path, object_name) SELECT :1, ROWNUM, seq_num, full_path, object_path FROM SYS.DATAPUMP_PATHS WHERE HET_TYPE =
                KUPM:14:54:08.072: :2
                KUPM:14:54:08.280: Stmt to load DATAPUMP_PATHMAP is: INSERT INTO "SYSTEM"."EXPDP_TT_JOB" (process_order, duplicate, object_path_
                seqno, object_name) SELECT :1, ROWNUM, seq_num, het_type FROM (SELECT p.seq_num seq_num, m.het_type het_type FROM DATAPUMP_PATHMAP
                KUPM:14:54:08.280: m, SYS.DATAPUMP_PATHS p WHERE m.object_path = p.full_path AND p.object_path = p.full_path AND p.het_type = :2)
                KUPM:14:54:08.442: In BUILD_MTABLE_INDEXES
                KUPM:14:54:08.505: Trying to create master table index: CREATE INDEX SYS_MTABLE_00028EDEF_IND_1 ON "SYSTEM"."EXPDP_TT_JOB" (obje
                ct_schema, object_name, object_type)
                KUPM:14:54:08.529: Trying to create master table index: CREATE INDEX SYS_MTABLE_00028EDEF_IND_2 ON "SYSTEM"."EXPDP_TT_JOB" (base
                _process_order)
                KUPM:14:54:08.543: Indexes have been built.
                KUPM:14:54:08.555: Entered state: EXECUTING
                KUPM:14:54:08.555: Log message received from MCP
                KUPM:14:54:08.555: Starting "SYSTEM"."EXPDP_TT_JOB": system/******** directory=dump_dir dumpfile=TT_20151224.dmp logfile=TT_201
                51224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no trace=480300
                kwqberlst rqan->lascn_kwqiia > 0 block
                kwqberlst rqan->lascn_kwqiia 7


                12楼2015-12-24 16:53
                回复
                  2026-01-06 04:23:41
                  广告
                  不感兴趣
                  开通SVIP免广告
                  8楼补充:
                  KUPW:14:54:08.795: 1: Data Filter Index : 6 Count : 0
                  KUPW:14:54:08.795: 1: Data Remap Index : 7 Count : 0
                  KUPW:14:54:08.795: 1: MD remap name Index : 8 Count : 0
                  KUPW:14:54:08.795: 1: In procedure DISPATCH_WORK_ITEMS
                  KUPW:14:54:08.796: 1: In procedure SEND_MSG. Fatal=0
                  KUPW:14:54:08.796: 1: KUPC$QUEUE.TRANSCEIVE called.
                  kwqberSSt !retval block
                  kwqberSSt rqan->lagno_kwqiia 8
                  kwqberSSt rqan->lascn_kwqiia > 0 block
                  kwqberSSt rqan->lascn_kwqiia 8
                  kwqberSSt ascn -249373820 lascn 22
                  kwqberSSt !retval block
                  kwqberSSt rqan->lagno_kwqiia 8
                  KUPW:14:54:08.807: 1: KUPC$QUEUE.TRANSCEIVE returned. Received 2011
                  KUPW:14:54:08.807: 1: DBMS_LOB.CREATETEMPORARY called.
                  KUPW:14:54:08.807: 1: DBMS_LOB.CREATETEMPORARY returned.
                  KUPW:14:54:08.809: 1: Flags: 18
                  KUPW:14:54:08.809: 1: Start sequence number:
                  KUPW:14:54:08.809: 1: End sequence number:
                  KUPW:14:54:08.809: 1: Metadata Parallel: 1
                  KUPW:14:54:08.809: 1: Primary worker id: 1
                  KUPW:14:54:08.811: 1: In procedure GET_TABLE_DATA_OBJECTS
                  KUPW:14:54:08.811: 1: In procedure CREATE_MSG
                  KUPW:14:54:08.811: 1: KUPV$FT.MESSAGE_TEXT called.
                  KUPW:14:54:08.811: 1: KUPV$FT.MESSAGE_TEXT returned.
                  KUPW:14:54:08.811: 1: In procedure SEND_MSG. Fatal=0
                  KUPW:14:54:08.812: 1: KUPC$QUEUE_INT.SEND called.
                  kwqberSSt !retval block
                  kwqberSSt rqan->lagno_kwqiia 8
                  kwqberSSt rqan->lascn_kwqiia > 0 block
                  kwqberSSt rqan->lascn_kwqiia 8
                  kwqberSSt ascn -249373820 lascn 22
                  kwqberSSt !retval block
                  kwqberSSt rqan->lagno_kwqiia 8
                  KUPW:14:54:08.813: 1: KUPC$QUEUE_INT.SEND returned.
                  KUPW:14:54:08.813: 1: Estimate in progress using BLOCKS method...
                  KUPW:14:54:08.814: 1: In procedure CONFIGURE_METADATA_UNLOAD
                  KUPW:14:54:08.814: 1: Phase: ESTIMATE_PHASE Filter Name: Filter Value:
                  KUPW:14:54:08.814: 1: DBMS_METADATA.OPEN11.2.0.0.0 called.
                  KUPW:14:54:09.358: 1: DBMS_METADATA.OPEN11.2.0.0.0 returned. Source handle: 100001
                  KUPW:14:54:09.358: 1: DBMS_METADATA.SET_FILTER called. metadata_phase: ESTIMATE_PHASE
                  KUPW:14:54:09.358: 1: DBMS_METADATA.SET_FILTER returned. In function GET_NOEXP_TABLE
                  KUPW:14:54:09.365: 1: DBMS_METADATA.SET_PARSE_ITEM called.
                  KUPW:14:54:09.565: 1: DBMS_METADATA.SET_PARSE_ITEM returned.
                  KUPW:14:54:09.565: 1: DBMS_METADATA.SET_COUNT called.
                  KUPW:14:54:09.569: 1: DBMS_METADATA.SET_COUNT returned.
                  KUPW:14:54:09.569: 1: In FETCH_XML_OBJECTS
                  KUPW:14:54:09.569: 1: KUPF$FILE.OPEN_CONTEXT called.
                  KUPW:14:54:09.570: 1: KUPF$FILE.OPEN_CONTEXT returned.
                  KUPW:14:54:09.570: 1: DBMS_METADATA.FETCH_XML_CLOB called. Handle: 100001
                  *** 2015-12-24 15:05:12.055
                  KUPW:15:05:12.054: 1: DBMS_METADATA.FETCH_XML_CLOB returned.
                  KUPW:15:05:12.055: 1: Object seqno fetched: 63
                  KUPW:15:05:12.055: 1: Object path fetched: SCHEMA_EXPORT/TABLE/TABLE_DATA
                  KUPW:15:05:12.055: 1: In procedure COMPLETE_EXP_OBJECT
                  KUPW:15:05:12.055: 1: KUPF$FILE.FLUSH_LOB called.
                  KUPW:15:05:12.055: 1: KUPF$FILE.FLUSH_LOB returned.
                  KUPW:15:05:12.055: 1: In procedure UPDATE_TYPE_COMPLETION_ROW
                  KUPW:15:05:12.055: 1: Old Seqno: 0 New Path: SCHEMA_EXPORT/TABLE/TABLE_DATA PO Num: -5 New Seqno: 63
                  KUPW:15:05:12.059: 1: Created type completion for duplicate 63
                  KUPW:15:05:12.059: 1: In procedure CREATE_MSG
                  KUPW:15:05:12.059: 1: KUPV$FT.MESSAGE_TEXT called.
                  KUPW:15:05:12.059: 1: KUPV$FT.MESSAGE_TEXT returned.
                  KUPW:15:05:12.059: 1: In procedure SEND_MSG. Fatal=0
                  KUPW:15:05:12.059: 1: KUPC$QUEUE_INT.SEND called.
                  kwqberSSt !retval block
                  kwqberSSt rqan->lagno_kwqiia 8
                  kwqberSSt rqan->lascn_kwqiia > 0 block
                  kwqberSSt rqan->lascn_kwqiia 8
                  kwqberSSt ascn -249373820 lascn 22
                  kwqberSSt !retval block
                  kwqberSSt rqan->lagno_kwqiia 8
                  KUPW:15:05:12.062: 1: KUPC$QUEUE_INT.SEND returned.
                  KUPW:15:05:12.062: 1: Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
                  KUPW:15:05:12.066: 1: In procedure CREATE_TABLE_DATA_OBJECT_ROWS
                  KUPW:15:05:12.066: 1: In function GATHER_PARSE_ITEMS
                  KUPW:15:05:12.066: 1: In function CHECK_FOR_REMAP_NETWORK
                  KUPW:15:05:12.066: 1: Nothing to remap
                  KUPW:15:05:12.066: 1: In procedure BUILD_OBJECT_STRINGS
                  KUPW:15:05:12.066: 1: In DETERMINE_BASE_OBJECT_INFO
                  KUPW:15:05:12.066: 1: TABLE_DATA
                  KUPW:15:05:12.066: 1: TT
                  KUPW:15:05:12.066: 1: TT_T1
                  KUPW:15:05:12.066: 1:
                  KUPW:15:05:12.066: 1:
                  KUPW:15:05:12.066: 1: TABLE
                  KUPW:15:05:12.066: 1: TT
                  KUPW:15:05:12.066: 1: TT_T1
                  KUPW:15:05:12.076: 1: In procedure LOCATE_DATA_FILTERS
                  KUPW:15:05:12.076: 1: In function NEXT_PO_NUMBER
                  KUPW:15:05:12.095: 1: In function GATHER_PARSE_ITEMS
                  KUPW:15:05:12.095: 1: In function CHECK_FOR_REMAP_NETWORK
                  KUPW:15:05:12.095: 1: Nothing to remap
                  KUPW:15:05:12.095: 1: In procedure BUILD_OBJECT_STRINGS
                  KUPW:15:05:12.095: 1: In DETERMINE_BASE_OBJECT_INFO
                  KUPW:15:05:12.095: 1: TABLE_DATA
                  ............


                  13楼2015-12-24 17:28
                  回复