关闭

Oracle RAC expdp 错误一例 ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout

5224人阅读 评论(0) 收藏 举报
分类:

今天导出数据的时候,遇到一个错误。数据库是linux下面的两节点的RAC, 10.2.0.4.0。

错误消息如下:

ORA-31693: Table data object "ABC"."AAAA" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-31617: unable to open dump file "/dba_mount/aaaa/expdp_test_02.dmp" for
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
  /dba_mount/aaaa/expdp_test_01.dmp
  /dba_mount/aaaa/expdp_test_02.dmp
  /dba_mount/aaaa/expdp_test_03.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" completed with 1 error(s) at 06:07:48

 

网上找了一下,有个URL适用。是因为两个节点用的mount point, 在/etc/fstab里面配置不一样造成的。修改,重新mount,即可。

 

参考URL如下:

http://www.dbquotient.com/blogs/?page_id=25

摘录一小段:

 

What is the root cause of ORA-31693 and ORA-31617 when doing expdp in RAC environment?

The following error happens in RAC environment if someone ran export with PARALLEL=X.
The rootcause is that you are trying to export in a RAC environment with parallel clause
but the directory (FS) is not available on all RAC node clusters. You should use a NAS/SAN mount
that is shared to all RAC nodes when using expdp with PARALLEL clause otherwise you will end up with this error.

ORA-31693: Table data object “DINA.ABCD” failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-31617: unable to open dump file “/opt/oracle/exp/dina.dmp”

 

 === 又记

昨天导出,遇到错误如下:

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
ORA-31693: Table data object "OWNER"."TABLES" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-39079: unable to enqueue message RQ,KUPC$C_2_20140507102039,KUPC$A_1_20140507102108
Processing object type SCHEMA_EXPORT/TABLE/TABLE

 

修改如下:

alter system set aq_tm_processes=1 scope=memory;

即可


 

 

 

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:874273次
    • 积分:10758
    • 等级:
    • 排名:第1554名
    • 原创:264篇
    • 转载:155篇
    • 译文:0篇
    • 评论:21条
    文章分类