今天导出数据的时候,遇到一个错误。数据库是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如下:
摘录一小段:
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;
即可