數據泵導出出現ORA-31617錯誤

Export: Release 11.2.0.4.0 - Production on Sat Jun 11 01:00:02 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

;;; 

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

Starting "SYS"."SYS_EXPORT_SCHEMA_04":  "/******** AS SYSDBA" directory=bak_dump dumpfile=exp_unspaydb_20160611.dmp logfil

e=exp_unspaydb_20160611.log schemas=vnv parallel=6 

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 21.77 GB

Processing object type SCHEMA_EXPORT/USER

. . exported "VNV"."TRANSACTION_HIS"                     2.949 GB 10892506 rows

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/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION

Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE

Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION

Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

. . exported "VNV"."TRANSACTION"                         2.193 GB 5947080 rows

. . exported "VNV"."T_BANK_TRANS_DC_HIS"                 1.938 GB 1316266 rows

ORA-31693: Table data object "VNV"."TRANSACTION_BAK_0518" failed to load/unload and is being skipped due to error:

ORA-31617: unable to open dump file "/data/orabackup/exp/exp_unspaydb_20160611.dmp" for write

ORA-19505: failed to identify file "/data/orabackup/exp/exp_unspaydb_20160611.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

ORA-31693: Table data object "VNV"."ID_CARD_INFO" failed to load/unload and is being skipped due to error:

ORA-31617: unable to open dump file "/data/orabackup/exp/exp_unspaydb_20160611.dmp" for write

ORA-19505: failed to identify file "/data/orabackup/exp/exp_unspaydb_20160611.dmp"

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

數據泵的并行度設置為10，同時向10個DUMPFILE中寫入數據。在寫入時出現ORA-31693、ORA-29913和ORA-31617錯誤。

發現對于RAC環境而言，Oracle會嘗試將并行導出放到兩個節點上，而由于DIRECTORY是本地磁盤，且在另外一個節點上沒有建立同樣的目錄，因此打開文件報錯的信息。

那么如果想要使用RAC上的并行導出，確保相同的目錄在兩個節點上同時存在。如果只想在一個節點上執行數據泵的導出那么就不要使用并行方式。