IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    11.2.0.1 impdp问题

    admin发表于 2015-06-12 03:21:22
    love 0

    数据库版本为11.2.0.1 ,遇到导入报错:
    impdp时发生job stopped due to fatal error

    检查alert日志,发现如下错误:
    Sun Jun 21 15:48:44 2015
    Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x10] [PC:0x643F8F4, kupfuDecompress()+2088] [flags: 0x0, count: 1]
    Errors in file /opt/oracle/diag/rdbms/orcl/orcl/trace/orcl_dw00_28637.trc (incident=32769):
    ORA-07445: exception encountered: core dump [kupfuDecompress()+2088] [SIGSEGV] [ADDR:0x10] [PC:0x643F8F4] [Address not mapped to object] []
    Incident details in: /opt/oracle/diag/rdbms/orcl/orcl/incident/incdir_32769/orcl_dw00_28637_i32769.trc

    查看metalik,发现如下bug:
    Bug 9395500 Dump [kupfuDecompress] importing large table from compressed DMP file This note gives a brief overview of bug 9395500.
    The content was last updated on: 28-JUN-2013
    Click here for details of each of the sections below.

    Affects:

    Product (Component) Oracle Server (Rdbms)
    Range of versions believed to be affected Versions BELOW 12.1
    Versions confirmed as being affected
    • 11.2.0.1
    • 11.1.0.7
    Platforms affected Generic (all / most platforms affected)

    Fixed:

    This issue is fixed in
    • 12.1.0.1 (Base Release)
    • 11.2.0.2 (Server Patch Set)
    • 11.2.0.1 Bundle Patch 7 for Exadata Database
    • 11.2.0.1 Patch 2 on Windows Platforms

    Symptoms:

    Related To:

    • Process May Dump (ORA-7445) / Abend / Abort
    • Dump in or under kupfuDecompress
    • Datapump Export/Import

    Description

    When importing a large table from a compressed dump file set using Data Pump
    import then a dump can occur. This typically occurs if the degree of 
    parallelism used for the import is set to a value of 1.
     
    Workaround
     In some cases running the import again using a degree of 
     parallelism greater than 1 can bypass the issue, but this is
     not a guaranteed workaround.
     
    

    HOOKS DUMP:kupfuDecompress LIKELYAFFECTS XAFFECTS_11.1.0.6 XAFFECTS_V11010006 AFFECTS=11.1.0.6 XAFFECTS_11.1.0.7 XAFFECTS_V11010007 AFFECTS=11.1.0.7 XAFFECTS_11.2.0.1 XAFFECTS_V11020001 AFFECTS=11.2.0.1 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMS XCOMP_RDBMS COMPONENT=RDBMS TAG_DUMP TAG_EXPDP DUMP EXPDP FIXED_11.2.0.1.BP07 FIXED_11.2.0.2 FIXED_12.1.0.1 FIXED_WIN:B201P02

    解决办法:打补丁,或者设置impdp ,parallel>1试试,导入是否成功。



沪ICP备19023445号-2号
友情链接