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.
1 Comments:
Good, I encoutered this error and resolved as your instructions
Post a Comment
Subscribe to Post Comments [Atom]
<< Home