客户的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上的并行导出，确保相同的目录在两个节点上同时存在。如果只想在一个节点上执行数据泵的导出那么就不要使用并行方式。