In a RAC database, if you are taking export with the parallel option and the datapump directory is not shared between the nodes, then export might fail with below error Because the remote node is unable to write the dumps to that directory.
ORA-31617: unable to open dump file “/dumparea/TEST/asset_75.dmp” for write
ORA-19505: failed to identify file “/dumparea/TEST/asset_75.dmp”
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
So to avoid this, Use CLUSTER=N parameter, with which, the export will run worker processes only on the local node.
CLUSTER
Utilize cluster resources and distribute workers across the Oracle RAC [YES].
Parfile will look like below:
dumpfile=asset_%U.dmp logfile=asset.log directory=VEN parallel=32 cluster=N