Wednesday, December 29, 2010

11gR2 DataPump Import Errors: ORA-31693/ORA-31640/ORA-19505/ORA-27037

Environment
2-nodes Oracle 11.2.0.2 RAC on OEL 5.5-64bit platform

Problem
Oracle DataPump Import failed with following errors:
impdp system/******** directory=expimp dumpfile=expdp_fpp_xxx2racflo_%U.dmp logfile=impdp_fpp_xxx2racflo-2010-12-28-1707.log job_name=impdp_xxx2racflo_fpp parallel=4


ORA-31693: Table data object "FPP"."FPP_WALT_MATCH" failed to load/unload and is being skipped due to error:
ORA-31640: unable to open dump file "/opt/DBfileLoad/expdp_fpp_blink2racflo_04.dmp" for read
ORA-19505: failed to identify file "/opt/DBfileLoad/expdp_fpp_blink2racflo_04.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3


Cause
According to Oracle Support/Metalink Note 1071373.1 - Cannot run DATAPUMP With PARALLEL > 1 ON 11.2 RAC  , "Datapump on 11.2 RAC with PARALLEL > 1 still hits the following errors though the unpublished Bug 8415620 is fixed into 11.2.",  and "From 11.2, Datapump new parameter CLUSTER is introduced". 


Solution
1
"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:
$ impdp system/******** directory=expimp dumpfile=expdp_fpp_xxx2racflo_%U.dmp logfile=impdp_fpp_xxx2racflo-2010-12-28-1707.log job_name=impdp_xxx2racflo_fpp CLUSTER=N PARALLEL=4



2 Other recommended solutions by Oracle for database between 10.2.0.4 to 11.1.0.7: Impdp Fails with ORA-31693 ORA-29913 ORA-29400 KUP-11010 if Parallel > 1 is Used in RAC Database [ID 762475.1]


2.1. Run the Data Pump import job with parallel=1 (default)

OR

2.2. Run the Data Pump import job if only one instance is started.

Labels: , , ,

1 Comments:

At March 16, 2011 at 12:18 AM , Anonymous Anonymous said...

Good, I encoutered this error and resolved as your instructions

 

Post a Comment

Subscribe to Post Comments [Atom]

<< Home