oracle归档nfs路径,RAC归档配置方案：使用NFS共享存储保存归档文件

1、第一次切换不成功

SYS@RACDB2> alter system archive log current;

$ tail /u01/admin/RACDB/bdump/*.log

Current log# 3 seq# 25 mem# 0: +DG1/racdb/redo03.log

Sun Jul  6 17:02:14 2014

WARNING:NFS file system /u01/rac_arch mounted with incorrect options

WARNING:Expected NFS mount options: rsize>=16384,wsize>=16384,hard,noac/actimeo=0

Sun Jul  6 17:02:14 2014

Errors in file /u01/admin/RACDB/bdump/racdb2_arc1_6756.trc:

ORA-19504: failed to create file "/u01/rac_arch/arch_0000000024_0851859689_0002.arc"

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

Additional information: 3

ARC1: Error 19504 Creating archive log file to '/u01/rac_arch/arch_0000000024_0851859689_0002.arc'

2、在两个节点上重新remount

[root@rac1 ~]# mount -t nfs -o remount,rsize=65534,wsize=65534,hard,noac,actimeo=0 192.168.1.101:/u01/arch

/u01/rac_arch

[root@rac2 ~]# mount -t nfs -o remount,rsize=20480000,wsize=20480000,hard,noac,actimeo=0 192.168.1.101:/u01/arch

/u01/rac_arch

[root@rac1 ~]＃ vim fstab

3、第二次切换成功

SYS@RACDB2> alter system archive log current;

[root@rac2 ~]# mount|grep rac_arch

192.168.1.101:/u01/arch on /u01/rac_arch type nfs (rw,hard,nointr,tcp,noac,timeo=600,nolock,addr=192.168.1.101)

192.168.1.101:/u01/arch on /u01/rac_arch type nfs

(rw,remount,rsize=65534,wsize=65534,hard,noac,actimeo=0,addr=192.168.1.101)

[root@rac2 ~]# ll /u01/rac_arch

total 1236

-rw-rw---- 1 oracle oinstall 1257984 Jul  6 17:12 arch_0000000022_0851859689_0001.arc

-rw-r--r-- 1 oracle oinstall       0 Jul  6 11:42 oracle_test

4、在rac1-rac2两个节点上设置开机自动挂载

[root@rac1 ~]＃ vim /etc/rc.local

mount -t nfs -o remount,rsize=20480000,wsize=20480000,hard,noac,actimeo=0 192.168.1.101:/u01/arch /u01/rac_arch

[root@rac2 ~]＃ vim /etc/rc.local

mount -t nfs -o remount,rsize=20480000,wsize=20480000,hard,noac,actimeo=0 192.168.1.101:/u01/arch /u01/rac_arch

5、reboot两节点进一步验证

zcs0237

2014.07.06

More cleaner and more efficient!