Symptoms
Datapump on 11.2 RAC with PARALLEL > 1 hits the following errors
ORA-31693: Table data object "SCOTT"."ESCSTATUS" failed to load/unload and is being skipped do error:
ORA-31617: unable to open dump file "/ora01/oracle/admin/demo/dpdump/demo_expdp_SCOTT.041911_06_02.dmp" for write
ORA-19505: failed to identify file "/ora01/oracle/admin/demo/dpdump/demo_expdp_SCOTT.041911_16_02.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Cause
From 11.2, Datapump new parameter CLUSTER is introduced.
CLUSTER : Default=Y
Purpose :
Determines whether Data Pump can use Oracle Real Application Clusters (RAC)
resources and start workers on other Oracle RAC instances.
Syntax and Description : CLUSTER=[Y | N]
Purpose :
Determines whether Data Pump can use Oracle Real Application Clusters (RAC)
resources and start workers on other Oracle RAC instances.
Syntax and Description : CLUSTER=[Y | N]
Solution
To force Data Pump to use only the instance where the job is started and to replicate pre-Oracle Database 11g release 2 (11.2) behavior, specify CLUSTER=N.
Example:
$ expdp hr DIRECTORY=dpump_dir1 DUMPFILE=hr_clus%U.dmp CLUSTER=N PARALLEL=3
Example:
$ expdp hr DIRECTORY=dpump_dir1 DUMPFILE=hr_clus%U.dmp CLUSTER=N PARALLEL=3
Hope this help! Rupam
