ORA-31693 ORA-31617 ORA-19505 ORA-27054

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s