I am migrating at ~5TB schema to Exadata using datapump.
Successfully created a datapump export with parallel completed ~10hrs.
Now its time to import it on Exadata.
So i fired the impdp command
impdp '"/ as sysdba"' directory=DATAPUMPDIR schemas=PLANPROC dumpfile=planprocforgg_%U.dmp logfile=planprocimp.log parallel=10
but…. Linux-x86_64 Error: 2: No such file or directory.
ORA-31693: Table data object "PLANPROC"."PLAN_TABLE" failed to load/unload and is being skipped due to error: ORA-31640: unable to open dump file "/backup/exabackup/forexa/planprocforgg_03.dmp" for read ORA-19505: failed to identify file "/backup/exabackup/forexa/planprocforgg_03.dmp" ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3
so i search metalink for any notes and found one.
How to Prevent ORA-39000 ORA-31640 ORA-27037 Errors When Performing DataPump Export/Import [ID 784566.1]
solution is to drop and create the directory and grant some privs.
but since im using sys, no need to grant just drop and create.
drop directory DATAPUMPDIR; CREATE DIRECTORY planprocforgg as '/backup/exabackup/forexa';
fired again the same command
impdp '"/ as sysdba"' directory=planprocforgg schemas=PLANPROC dumpfile=planprocforgg_%U.dmp logfile=planprocimp.log parallel=10
but same error.
now i dont know what to do, facebook time… and i remember that my source is a single instance and may target is an 8node RAC.
and my backup directory is only mounted on 1st node, so i modified the impdp command and specify CLUSTER=NO
impdp '"/ as sysdba"' directory=planprocforgg schemas=PLANPROC dumpfile=planprocforgg_%U.dmp logfile=planprocimp.log parallel=10 cluster=no