在使用NFS挂载oracle文件目录时(一般用于RAC存放各节点的归档日志),今天遇到了类似的问题,特记录总结
适用范围
This document is
relevant to all environments using Oracle Clusterware & RAC.
补充说明
The options with
which the NAS systems should be mounted are described. This notedoes notcover
thenew dNFS feature that was introduced in 11g.
描述
RAC including RACone and single instance RAC
In the table below
Binaries is the shared
mount points where the Oracle Home and CRS_HOME is installed.
Datafiles includes Online
Logs, Controlfile and Datafiles
nfsvers and vers are
identical on those OS platforms that has nfsvers. The ver option is
an alternative to the nfsvers option. It is included for compatibility
with other operating systems
Please note that the
mount options on each of the following cells are applicable only to those
type of files listed in the column heading.
For RMAN backup sets,
image copies, and Data Pump dump files, the "NOAC" mount option
should not be specified - that is because RMAN and Data Pump do not check
this option and specifying this can adversely affect performance.
Operating System
Mount options
for Binaries ##
Mount options
for Oracle Datafiles
Mount options
for CRS Voting Disk and OCR
Sun Solaris *
rw,bg,hard,nointr,rsize=32768,
wsize=32768,proto=tcp,noac,
vers=3,suid
rw,bg,hard,nointr,rsize=32768,
wsize=32768,proto=tcp,noac,
forcedirectio, vers=3
rw,bg,hard,nointr,rsize=32768,
wsize=32768,proto=tcp,vers=3,
noac,forcedirectio
AIX (5L) **
rw,bg,hard,nointr,rsize=32768,
wsize=32768,proto=tcp,
vers=3,timeo=600
cio,rw,bg,hard,nointr,rsize=32768,
wsize=32768,proto=tcp,noac,
vers=3,timeo=600
cio,rw,bg,hard,intr,rsize=32768,
wsize=32768,tcp,noac,
vers=3,timeo=600
HPUX 11.23
*** --
rw,bg,vers=3,proto=tcp,noac,
hard,nointr,timeo=600,
rsize=32768,wsize=32768,suid
rw,bg,vers=3,proto=tcp,noac,
forcedirectio,hard,nointr,timeo=600,
rsize=32768,wsize=32768
rw,bg,vers=3,proto=tcp,noac,
forcedirectio,hard,nointr,timeo=600
,rsize=32768,wsize=32768
Windows
Not Supported
Not Supported
Not Supported
Linux x86
#
****
rw,bg,hard,nointr,rsize=32768,
wsize=32768,tcp, vers=3,
timeo=600, actimeo=0
rw,bg,hard,nointr,rsize=32768,
wsize=32768,tcp,actimeo=0,
vers=3,timeo=600
rw,bg,hard,nointr,rsize=32768,
wsize=32768,tcp,noac,actimeo=0,
vers=3,timeo=600
Linux x86-64 #
****
rw,bg,hard,nointr,rsize=32768,
wsize=32768,tcp,vers=3,
timeo=600, actimeo=0
rw,bg,hard,nointr,rsize=32768,
wsize=32768,tcp,actimeo=0,
vers=3,timeo=600
rw,bg,hard,nointr,rsize=32768,
wsize=32768,tcp,noac,vers=3,
timeo=600,actimeo=0
Linux - Itanium
rw,bg,hard,nointr,rsize=32768,
wsize=32768,tcp,vers=3,
timeo=600, actimeo=0
rw,bg,hard,nointr,rsize=32768,
wsize=32768,tcp,actimeo=0,
vers=3,timeo=600
rw,bg,hard,nointr,rsize=32768,
wsize=32768,tcp,noac,vers=3,
timeo=600,actimeo=0
* NFS mount option
“forcedirectio” is required on Solaris platforms when mounting the OCR/CRS files
when using Oracle 10.1.0.4 or 10.2.0.2 or later (Oracle unpublished bug
4466428)
** AIX is only supported with NAS onAIX 5.3 TL04and higher
with Oracle 10.2.0.1 and later
*** NAS devices are only supported withHPUX 11.23or higher
ONLY
# These mount options are for Linux kernels 2.6 and above. For older
kernels please check
## The stated
mount options for binaries are applicable only if the ORACLE HOME is shared.
Due to Unpublished bug 5856342, it is necessary to use the following
init.ora parameter when using NAS with all versions of RAC on Linux (x86 &
X86-64 platforms) until 10.2.0.4. This bug is fixed and included in 10.2.0.4
patchset.
filesystemio_options = DIRECTIO
Single Instance (non-RAC)
Operating System
Mount options for Binaries
Mount options for Oracle
Datafiles
Sun Solaris *
(8, 9, 10, 11)
rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,proto=tcp,suid
rw,bg,hard,rsize=32768,wsize=32768,vers=3,[forcedirectio
or llock],nointr,proto=tcp
AIX (5L) **
rw,bg,hard,rsize=32768,wsize=32768,vers=3,intr,timeo=600,proto=tcp
rw,bg,hard,rsize=32768,wsize=32768,vers=3,cio,intr,timeo=600,proto=tcp
HPUX 11.23 ****
rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,proto=tcp,suid
rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,proto=tcp,
forcedirectio
Windows
Not Supported
Not Supported
Linux x86
#
rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,tcp
rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,tcp
Linux x86-64 #
rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,tcp
rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,tcp
Linux - Itanium
rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,tcp
rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,tcp
示例
下面的示例是 aix下挂载存放oracle归档日志文件的目录
在节点2上将节点1的目录挂载
节点2
mount -o rw,bg,hard,nointr,rsize=32768,wsize=32768,proto=tcp,vers=3,timeo=600 192.24.180.81:/rac1_arch /rac1_arch
* 192.24.180.81是节点1的ip地址,/rac1_arch是节点1的归档日志文件存放目录 ,第二个 /rac1_arch是在节点2的挂载点
参考
Mount Options for Oracle files when used with NFS on NAS devices (文档 ID 359515.1)