NFS and Oracle Backups

Oracle while taking backup using datapump or RMAN autobackup, checks for options set on the mount point if it is enaled for backup or not. If correct options are not set, it does not dump the backup file. Same script can backup on a cooked file system or even on NFS log file is written. Issue comes only in case of dump files.

Following error appears in case of incorrect mount point options.


In case of datapump

Datapump export unable to write to dump file NFS

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/u01/app/oracle/admin/ges/export/dmp/expdp.ges1.full.xrows.20090126.11244801.dm
p"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
In case of RMAN backup

RMAN-03009: failure of Control File and SPFILE Autobackup command on c1 channel at 02/12/2009 13:41:26
ORA-19504: failed to create file "/apps/warehouse2/rman/wbeqdrac07p_ges/cf_c-1576423539-20090212-03.bak"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3



To correct the problem,
set the following options in /etc/fstab file and umount the mount point and again mount it.

rw,bg,nfsvers=3,tcp,timeo=600,rsize=32768,wsize=32768,hard,nolock,intr,noac,addr=10.110.116.243

Mandetory options are
hard, rsize>=32768 and wsize>=32768

noac is required on RAC servers.

Options can be checked using
mount -v

Also it is necessary that following services to be running on NFS server and NFS client



> service nfs status
rpc.mountd (pid 25815) is running...
nfsd (pid 25812 25811 25810 25809 25808 25807 25806 25805) is running...

> service portmap status
portmap (pid 16735) is running...

> service nfslock status
rpc.statd (pid 16774) is running...

> ps -efgrep rpc.rquotad
root 6593 5730 0 11:46 pts/0 00:00:00 grep rpc.rquotad
root 23692 1 0 11:26 ? 00:00:00 rpc.rquotad
root 23727 1 0 11:26 ? 00:00:00 rpc.rquotad
root 25801 1 0 11:31 ? 00:00:00 rpc.rquotad


After these options are set, backup was successful for RMAN as well as datapump