Data pump import hangs in RAC
Import data pump hangs for a couple days and never completed. I have to do a schema refresh periodically and was able to complete the import using the REMAP_SCHEMA about 5 times with no problem.
I am using the same export dmp files (4 dmp files) and the same parfile (except the log file date changed), but now my import just hangs at the same point:
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
When I checked processes "ps -ef | grep impdb" I can see the process is running.
When checked "select JOB_NAME,JOB_MODE,STATE,OPERATION from dba_datapump_jobs;" I see my import in status "EXECUTING" even it hangs a couple of days.