rman在nfs文件系统上备份报错（NFS file system where the file is created or resides is not mounted with correct ）

背景描述

使用rman的0，1，2级备份方式，备份文件存放在一个搭建了NFS_SERVER的远程计算机上。

在使用rman备份的时候报错

ORA-19504: failed to create file "/Oracle_BAK/oradataback/backupsets/db_level1_20170531_0ms5keql_1_1"

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

确保磁盘没有写入数据之后，卸载磁盘

[root@csicn20db01 ~]# umount /Oracle_BAK/

umount.nfs: /Oracle_BAK: device is busy

umount.nfs: /Oracle_BAK: device is busy

如果出现device is buy

[root@csicn20db01 etc]# umount /Oracle_BAK/

umount.nfs: /Oracle_BAK: device is busy

umount.nfs: /Oracle_BAK: device is busy

可以使用强制断掉所有的dmsg（确保设备没有生产的数据写入）

[root@csicn20db01 etc]# fuser -km  /Oracle_BAK/

卸载磁盘

[root@csicn20db01 etc]# umount /Oracle_BAK/

[root@csicn20db01 etc]# df -h

Filesystem                    Size  Used Avail Use% Mounted on

/dev/mapper/VolGroup-lv_root  518G   21G  472G   5% /

tmpfs                          31G  360M   31G   2% /dev/shm

/dev/sda1                     485M   40M  420M   9% /boot

加入参数指定挂载的方式

[root@csicn20db01 etc]# mount -t nfs -o rw,bg,noac,hard,nointr,rsize=32768,wsize=32768,proto=tcp,actimeo=0,vers=3,timeo=600 10.227.40.4:/Oracle_BAK/ /Oracle_BAK/

[root@csicn20db01 etc]# df -h

Filesystem                    Size  Used Avail Use% Mounted on

/dev/mapper/VolGroup-lv_root  518G   21G  472G   5% /

tmpfs                          31G  360M   31G   2% /dev/shm

/dev/sda1                     485M   40M  420M   9% /boot

10.227.40.4:/Oracle_BAK/      1.8T  1.6G  1.8T   1% /Oracle_BAK

查看新挂载的刷新信息

[root@csicn20db01 etc]# more /etc/mtab

/dev/mapper/VolGroup-lv_root / ext4 rw 0 0

proc /proc proc rw 0 0

sysfs /sys sysfs rw 0 0

devpts /dev/pts devpts rw,gid=5,mode=620 0 0

tmpfs /dev/shm tmpfs rw 0 0

/dev/sda1 /boot ext4 rw 0 0

none /proc/sys/fs/binfmt_misc binfmt_misc rw 0 0

sunrpc /var/lib/nfs/rpc_pipefs rpc_pipefs rw 0 0

nfsd /proc/fs/nfsd nfsd rw 0 0

10.227.40.4:/Oracle_BAK/ /Oracle_BAK nfs rw,bg,noac,hard,nointr,rsize=32768,wsize=32768,proto=tcp,actimeo=0,vers=3,timeo=600,addr=10.227.40.4 0 0

 

测试rman备份

archived log file name=+DATA/arch/1_41_943628398.dbf RECID=55 STAMP=945341337

archived log file name=+DATA/arch/2_36_943628398.dbf RECID=58 STAMP=945341387

archived log file name=+DATA/arch/1_42_943628398.dbf RECID=56 STAMP=945341352

archived log file name=+DATA/arch/1_43_943628398.dbf RECID=57 STAMP=945341385

archived log file name=+DATA/arch/1_44_943628398.dbf RECID=61 STAMP=945344770

archived log file name=+DATA/arch/2_37_943628398.dbf RECID=59 STAMP=945344768

archived log file name=+DATA/arch/2_38_943628398.dbf RECID=60 STAMP=945344769

archived log file name=+DATA/arch/1_45_943628398.dbf RECID=62 STAMP=945360922

archived log file name=+DATA/arch/1_46_943628398.dbf RECID=63 STAMP=945387705

archived log file name=+DATA/arch/2_39_943628398.dbf RECID=64 STAMP=945408359

archived log file name=+DATA/arch/1_47_943628398.dbf RECID=65 STAMP=945428908

archived log file name=+DATA/arch/2_40_943628398.dbf RECID=66 STAMP=945438013

archived log file name=+DATA/arch/1_48_943628398.dbf RECID=68 STAMP=945441110

archived log file name=+DATA/arch/2_41_943628398.dbf RECID=67 STAMP=945441109

archived log file name=+DATA/arch/2_42_943628398.dbf RECID=70 STAMP=945441115

archived log file name=+DATA/arch/1_49_943628398.dbf RECID=69 STAMP=945441112

Finished backup at 31-MAY-17

 

released channel: c1

 

 

RMAN> exit;

 

Recovery Manager complete.

 

End Full Database Backup at 2017-05-31 14:34:03

 

备份正常。

 

修改rc.local选项（开机自动启动）

[root@csicn20db01 etc]# more /etc/rc.local

mount -t nfs -o rw,bg,noac,hard,nointr,rsize=32768,wsize=32768,proto=tcp,actimeo=0,vers=3,timeo=600 10.227.40.4:/Oracle_BAK/ /Oracle_BAK/

Note： rw,bg,noac,hard,nointr,rsize=32768,wsize=32768,proto=tcp,actimeo=0,vers=3,timeo=600是oracle官方文档里linux x86-64的设置。