Oracle 11g R2 RAC Datapump error while import, ORA-31693, ORA-29913, ORA-31640, ORA-19505, ORA-27037

Oracle 11g R2 RAC Datapump error while import, ORA-31693, ORA-29913, ORA-31640, ORA-19505, ORA-27037


While importing in Oracle 11g R2 two node RAC setup on Linux machine following error occured –


ORA-31693 ****************


ORA-29913 ****************


ORA-31640 ****************


ORA-19505 ****************


ORA-27037 ****************


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]



Solution


To force DataPump 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




Above Cause and Action is available in the metalink note :


Cannot Run DataPump With PARALLEL > 1 On 11.2 RAC [ID 1071373.1]

티스토리 툴바