ORA-31617 error in Data pump export

Export:release 11.2.0.4.0-production on Sat June 11 01:00:02 2016

Copyright (c) 1982, 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 was 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 was 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

The data pump is set to a degree of parallelism of 10 while writing data to 10 dumpfile. ORA-31693, ORA-29913, and ORA-31617 errors occurred while writing.

In the case of a RAC environment, Oracle attempts to put parallel exports on two nodes, and because directory is a local disk and does not have the same directory on another node, open file error messages.

So if you want to use parallel exports on a RAC, make sure that the same directory exists on two nodes at the same time. If you only want to perform a data pump export on one node then do not use parallel mode.

This article is from the "Travel Life" blog, please be sure to keep this source http://felixgzf.blog.51cto.com/4108324/1787886

ORA-31617 error in Data pump export