oracle导出数据特别慢_impdp导入速度缓慢问题,专家帮忙会诊 - Oracle数据库管理 - Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗...

最新推荐文章于 2025-05-20 11:04:02 发布

weixin_39951112

最新推荐文章于 2025-05-20 11:04:02 发布

阅读量493

点赞数

CC 4.0 BY-SA版权

文章标签： oracle导出数据特别慢

本文链接：https://blog.youkuaiyun.com/weixin_39951112/article/details/111480863

在RAC数据库中，当使用PARALLEL > 1时，Data Pump导入出现错误orA-31693、orA-29913、orA-29400和KUP-11010。问题在于数据泵dump文件存储的目录并非所有实例都能访问。解决方案包括在所有实例都能访问的共享存储上创建Data Pump目录，或者运行平行度为1的导入作业，或者仅启动一个实例进行导入作业。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Impdp Fails with orA-31693 orA-29913 orA-29400 KUP-11010 if Parallel > 1 is Used in RAC Database [ID 762475.1]

修改时间 17-APR-2012 类型 PROBLEM 状态 PUBLISHED

In this Document

Symptoms

Cause

Solution

References

Applies to:

oracle Server - Enterprise Edition - Version 10.2.0.4 to 11.1.0.7 [Release 10.2 to 11.1]

Information in this document applies to any platform.

*** Checked for relevance on 17-Apr-2012 ***

oracle Server Enterprise Edition - Version: 10.2.0.4 to 11.1.0.7

Symptoms

In a RAC database Data Pump import generates the following errors if PARALLEL > 1 is used:

orA-31693: Table data object ""."" failed to load/unload and is being skipped due to error:

orA-29913: error in executing ODCIEXTTABLEOPEN callout

orA-29400: data cartridge error

KUP-11010: unable to open at least one dump file for load

The directory where Data Pump dump file is stored is *not* accessible from all instances in RAC.

Cause

This issue was analyzed in:

Bug 6990731 - IMPDP 10.2.0.4 ERROR WHEN PARALLEL > 1 orA-31693 orA-29913 orA-29400 KUP-11010

currently suspended.

In this bug there was referenced the "Note" from Bug 5472417 - EXPDP on RAC

fails with orA-39014 / orA-12801 (error signaled in parallel query server) fixed in 10.2.0.4 and 11.1.0.6 (see Note 5472417.8).

This note specifies:

"In order for a Data Pump job start up and work properly in parallel a RAC environment make sure the specified directory object points to shared storage that is accessible from all instances in the RAC cluster".

In 10.2.0.4 and 11g RAC databases this is mandatory for a proper behavior of parallel (parallel>1) Data Pump export/import jobs that the specified directory is on a shared disk accessible from all instances in the RAC cluster.

Solution

1. Create the Data Pump directory on a shared storage accessible from all the instances in the RAC cluster.

2. Run the Data Pump import job with parallel=1 (default)

3. Run the Data Pump import job if only one instance is started.

References

BUG:5472417 - EXPDP ON RAC ABORTS DUE TO orA-12801 (ERROR SIGNALED IN PARALLEL QUERY SERVER)

NOTE:5472417.8 - Bug 5472417 - EXPDP on RAC fails with orA-39014 / orA-12801 (error signaled in parallel query server)

BUG:6990731 - IMPDP 10.2.0.4 ERROR WHEN PARALLEL > 1: orA-31693 orA-29913 orA-29400 KUP-11010