Why PARALLEL in EXPDP gives unable to write error
Oracle Version : 11.2.0.3
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object “ADD”.”CAND”:”CAND_17″ failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file “/u02/backup/exp/add/add1_51_241_2_20131002_023649.dmp” for write
ORA-19505: failed to identify file “/u02/backup/exp/add/add1_51_241_2_20131002_023649.dmp”
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Cause:
Error triggered, because it is RAC and consists of two nodes, and used local directory.
If datapump had started without parallel option, it would not go to other db node, and everything would go well.
If we try run the Export script without PARALLEL option considering the current Production DB size and also hundreds of Table partitions no doubt that would run for more than 15 to 20 hours and also if we are trying to export huge dumps then no ETA for that dump. So Datapump is started in parallel mode, and it tries to start parallel processes in ALL nodes of the cluster.
Solution:
In order to prevent to start the parallel process in other node. I have explicitly given running node SID while exporting
But it still continue to give the same error.
Here’s the solution:
expdp $USERID/$PASSWORD@$TNSNAMES DIRECTORY=$DIRECTORY DUMPFILE=$USERID$CLIENTID$DATE0 LOGFILE=$USERID$CLIENTID$LOGDATE0 INCLUDE=\(SEQUENCE\) FLASHBACK_TIME=\”TO_TIMESTAMP\(\’$FLASHBACK_TIME1 $FLASHBACK_TIME2\’,\’DD-MM-YYYY HH24:MI:SS\’\)\” PARALLEL=6 CLUSTER=N
Leave a Reply