dbdao吧 关注:1,186贴子:4,073
  • 5回复贴,共1

使用IMPDP导入数据 HANG住没有报错

只看楼主收藏回复

环境是10G到11G 字符集从zhs16gbk到al32utf8
我们采用CSSCAN的命令的工具做了一次信息采集 采集了需要修改的表结构信息,手动修了修改表结构的语句
然后执行了导出
expdp system/******** schemas=tmuser directory=data_pump_dir dumpfile=20150912_tmuser_%U.dmp logfile=20150910_tmuser.log parallel=8 content=data_only
结果正常,传送至目标端进行导如
impdp ********/******** directory=dump_calltmuser logfile=impdp_tmuser_20150915_1.log dumpfile=20150912_TMUSER_%U.DMP remap_schema=tmuser:tmuser parallel=8
导入开始很顺利 然后一共1636张表 执行到800多张表的时候HANG主了
ALTER日志从HANG开始就不写了
但是数据库并没有HANG主 可以手动切换日志 ALTER日志里面也能正常记录
ATTACH收集的信息如下


IP属地:上海1楼2015-09-15 16:22回复
    Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    Job: SYS_IMPORT_FULL_02
    Owner: DBOPER
    Operation: IMPORT
    Creator Privs: TRUE
    GUID: 1FC43FCACEBE28BDE0533F6C656D3E32
    Start Time: Tuesday, 15 September, 2015 14:25:33
    Mode: FULL
    Instance: cmchina
    Max Parallelism: 8
    EXPORT Job Parameters:
    CLIENT_COMMAND system/******** schemas=tmuser directory=data_pump_dir dumpfile=20150912_tmuser_%U.dmp logfile=20150910_tmuser.log parallel=8 content=data_only
    INCLUDE_METADATA 0
    IMPORT Job Parameters:
    Parameter Name Parameter Value:
    CLIENT_COMMAND dboper/******** directory=dump_calltmuser logfile=impdp_tmuser_20150915_1.log dumpfile=20150912_TMUSER_%U.DMP remap_schema=tmuser:tmuser parallel=8
    State: EXECUTING
    Bytes Processed: 12,505,214,288
    Percent Done: 99
    Current Parallelism: 8
    Job Error Count: 0
    Dump File: /u01/app/oracle/oradata/calldb_20150912/20150912_TMUSER_%u.DMP
    Dump File: /u01/app/oracle/oradata/calldb_20150912/20150912_TMUSER_01.DMP
    Dump File: /u01/app/oracle/oradata/calldb_20150912/20150912_TMUSER_02.DMP
    Dump File: /u01/app/oracle/oradata/calldb_20150912/20150912_TMUSER_03.DMP
    Dump File: /u01/app/oracle/oradata/calldb_20150912/20150912_TMUSER_04.DMP
    Dump File: /u01/app/oracle/oradata/calldb_20150912/20150912_TMUSER_05.DMP
    Dump File: /u01/app/oracle/oradata/calldb_20150912/20150912_TMUSER_06.DMP
    Dump File: /u01/app/oracle/oradata/calldb_20150912/20150912_TMUSER_07.DMP
    Dump File: /u01/app/oracle/oradata/calldb_20150912/20150912_TMUSER_08.DMP
    Worker 1 Status:
    Process Name: DW00
    State: EXECUTING
    Object Schema: TMUSER
    Object Name: PRPTCARDEVICEDTO
    Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
    Completed Objects: 438
    Completed Bytes: 9,040
    Worker Parallelism: 1
    Worker 2 Status:
    Process Name: DW01
    State: WORK WAITING
    Worker 3 Status:
    Process Name: DW02
    State: WORK WAITING
    Worker 4 Status:
    Process Name: DW03
    State: EXECUTING
    Object Schema: TMUSER
    Object Name: INSURANCE_STATUS
    Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
    Completed Objects: 11
    Completed Bytes: 28,044,040
    Worker Parallelism: 1
    Worker 5 Status:
    Process Name: DW04
    State: EXECUTING
    Object Schema: TMUSER
    Object Name: POLICYSTATUS
    Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
    Completed Objects: 8
    Completed Bytes: 29,057,984
    Worker Parallelism: 1
    Worker 6 Status:
    Process Name: DW05
    State: EXECUTING
    Object Schema: TMUSER
    Object Name: PRPTCARDRIVERDTO
    Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
    Completed Objects: 17
    Completed Bytes: 3,404,296
    Worker Parallelism: 1
    Worker 7 Status:
    Process Name: DW06
    State: WORK WAITING
    Worker 8 Status:
    Process Name: DW07
    State: EXECUTING
    Object Schema: TMUSER
    Object Name: PRPCENGAGEDTO
    Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
    Completed Objects: 10
    Completed Bytes: 16,250,024
    Worker Parallelism: 1


    IP属地:上海2楼2015-09-15 16:23
    回复
      请问刘大 还需要收集什么信息么


      IP属地:上海3楼2015-09-15 16:23
      回复
        多次 status 并给出结果


        IP属地:日本4楼2015-09-16 10:34
        收起回复
          http://pan.baidu.com/s/1ntGgEtr
          HANG主时候AWR报告


          IP属地:上海5楼2015-09-16 11:42
          回复