Viswamitra's blog

While I was doing expdp on a RAC database I got below errors.

expdp uname/pass directory=Backup_GW tables=instr_hist dumpfile=INST_HIST_%U.dmp parallel=6  logfile=INST_HIST.log

ORA-31693: Table data object “TEST”.”INSTR_HIST”:”P65″ failed to load/unload and is being skipped due to error:
ORA-31617: unable to open dump file “/backup/INST_HIST/INST_HIST_05.dmp” for write
ORA-19505: failed to identify file “/backup/INST_HIST/INST_HIST_05.dmp”
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 5
Additional information: 18

Solution :

In 11gR2 there is a parameter “CLUSTER” which is by default “Y” , this will make the use of the cluster nodes to take expdp.

To take the expdp from only one node (from where we are firing the command) put CLUSTER=N

expdp  directory=Backup_GW tables=instr_hist dumpfile=INST_HIST_%U.dmp parallel=6  logfile=INST_HIST.log CLUSTER=N