数据库版本为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.
Product (Component) Oracle Server (Rdbms) Range of versions believed to be affected Versions BELOW 12.1 Versions confirmed as being affected Platforms affected Generic (all / most platforms affected)
This issue is fixed in
Symptoms:
|
Related To:
|
|
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.
解决办法:打补丁,或者设置impdp ,parallel>1试试,导入是否成功。