数据泵导出出现ORA-31617错误

客户的Oracle10204 RAC FOR Hp数据库执行EXPDP并行导出时出现了这个错误信息。
导出报错如下:

Export: Release 10.2.0.4.0 - 64bit Production ON Thursday, 12 January, 2012 6:10:00
Copyright (c) 2003, 2007, Oracle.  ALL rights reserved.
Connected TO: Oracle DATABASE 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
WITH the Partitioning, REAL Application Clusters, Oracle Label Security, DATA Mining
AND REAL Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01":  parfile=/home/oracle/backup/moddb_par_mesadmin 
Estimate IN progress USING BLOCKS method...
Processing object TYPE SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation USING BLOCKS method: 72.74 GB
Processing object TYPE SCHEMA_EXPORT/USER
Processing object TYPE SCHEMA_EXPORT/SYSTEM_GRANT
Processing object TYPE SCHEMA_EXPORT/ROLE_GRANT
Processing object TYPE SCHEMA_EXPORT/DEFAULT_ROLE
Processing object TYPE SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object TYPE SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
.
.
.
Processing object TYPE SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object TYPE SCHEMA_EXPORT/TABLE/TRIGGER
ORA-31693: TABLE DATA object "MESADMIN"."S_IFCPRODUCT" 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 "/archive/temp_exp/moddb_exp_mesadmin_3.dmp" FOR wr
Processing object TYPE SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-31693: TABLE DATA object "MESADMIN"."PRODUCTHISTORY" 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 "/archive/temp_exp/moddb_exp_mesadmin_2.dmp" FOR wr
Processing object TYPE SCHEMA_EXPORT/JOB
Processing object TYPE SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
ORA-31693: TABLE DATA object "MESADMIN"."S_R_WIP" 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 "/archive/temp_exp/moddb_exp_mesadmin_2.dmp" FOR wr
ORA-31693: TABLE DATA object "MESADMIN"."C_FGMSIF_PANELINFO" 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 "/archive/temp_exp/moddb_exp_mesadmin_5.dmp" FOR wr
ORA-31693: TABLE DATA object "MESADMIN"."C_AC_PANEL_GRADE" 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 "/archive/temp_exp/moddb_exp_mesadmin_2.dmp" FOR wr
. . exported "MESADMIN"."S_R_MOVEMENT"                   191.2 MB 2070491 ROWS
.
.
.
. . exported "MESADMIN"."USERPROFILEATTRIBUTEHISTORY"        0 KB       0 ROWS
. . exported "MESADMIN"."RTDRULETRACEHISTORY"            1.627 GB 3812462 ROWS
. . exported "MESADMIN"."PRODUCT"                        1.057 GB 2593517 ROWS
Master TABLE "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file SET FOR SYSTEM.SYS_EXPORT_SCHEMA_01 IS:
  /archive/temp_exp/moddb_exp_mesadmin_1.dmp
  /archive/temp_exp/moddb_exp_mesadmin_2.dmp
  /archive/temp_exp/moddb_exp_mesadmin_3.dmp
  /archive/temp_exp/moddb_exp_mesadmin_4.dmp
  /archive/temp_exp/moddb_exp_mesadmin_5.dmp
  /archive/temp_exp/moddb_exp_mesadmin_6.dmp
  /archive/temp_exp/moddb_exp_mesadmin_7.dmp
  /archive/temp_exp/moddb_exp_mesadmin_8.dmp
  /archive/temp_exp/moddb_exp_mesadmin_9.dmp
  /archive/temp_exp/moddb_exp_mesadmin_10.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" completed WITH 5 error(s) at 06:22:57

数据泵的并行度设置为10,同时向10个DUMPFILE中写入数据。在写入时出现ORA-31693、ORA-29913和ORA-31617错误。
发现对于RAC环境而言,Oracle会尝试将并行导出放到两个节点上,而由于DIRECTORY是本地磁盘,且在另外一个节点上没有建立同样的目录,因此打开文件报错的信息。
那么如果想要使用RAC上的并行导出,确保相同的目录在两个节点上同时存在。如果只想在一个节点上执行数据泵的导出那么就不要使用并行方式。

This entry was posted in ORACLE and tagged , , , , . Bookmark the permalink.

One Response to 数据泵导出出现ORA-31617错误

  1. Kamus says:

    可以设置并行实例组来规避此问题。

Leave a Reply

Your email address will not be published. Required fields are marked *