資料泵匯出出現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上的並行匯出，確保相同的目錄在兩個節點上同時存在。如果只想在一個節點上執行資料泵的匯出那麼就不要使用並行方式。