RAC环境本地归档备份失败问题

李少鹏,现就职于北京海天起点技术服务股份有限公司,具有多年oracle数据库维护经验,有11G OCP认证,致力于帮助客户解决生产环境出现的各种问题。

 

环境介绍

环境为两台IBM power系列组成的RAC环境,系统环境均为AIX 6.1,数据库版本为oracle 10.2.0.5.0,两节点的归档日志分别存放在本地空间,然后通过NFS挂载到另一节点的机器。备份任务全部在一节点运行。

故障介绍

为客户巡检时发现归档日志备份失败,客户这边备份在一节点运行,定时任务为每天晚上23:30备份归档日志

归档日志备份脚本

归档日志的备份日志

查看挂载状态

检查发现二节点的归档日志所在磁盘已经挂在到一节点上,并且读写都没有问题

故障处理

查看挂载方式为普通挂载方式,未添加任何参数,查询官方文档,使用推荐参数重新挂载依旧未能解决

检查NFS的配置,发现客户端的/etc/filesystems中未加入mount nfs文件系统的条目,增加以下条目后,重新mount,解决

总结

建议大家以后遇到类似问题,先检查/etc/filesystems文件,查看配置文件中有无相关的NFS条目,正确配置之后再一步步验证问题所在。

参考文档

查了Metalink(Doc ID:359515.1),适用于10.1.0.2以上版本,供参考:

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.
  • The non-shared GI HOME and ORACLE HOME on non-shared NFS mount point is not tested, so although noac may not be needed, its absence still cause problems at runtime because the RDBMS (and ASM) code
    contains validations of the NFS mount options, so this configuration should not be used.
  • 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.
  • In 12.2, both OCR and voting disks must reside in ASM. Refer to Document 2201844.1
  • The NFS storage for asm diskgroup (not quorum disks) that has the OCR and voting disk must use the mount options listed for CRS Voting Disk and OCR
  • The NFS storage for asm diskgroup (not quorum disks) that does not have the OCR and voting disk must use the mount options listed for Oracle Datafiles
Operating System Mount options for    Binaries ## Mount options for Oracle Datafiles

The NFS storage for asm diskgroup (not quorum disks) that does not have
the OCR and voting disk must also use this mount options

Mount options for CRS Voting Disk and OCR (12.1 and lower)
In 12.2, both OCR and voting disks must reside in ASM.
Refer to Document 2201844.1
The NFS storage for asm diskgroup (not quorum disks) that has the OCR
and voting disk must also use this mount options
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
(Use dNFS if needed.
Refer to
Document 1468114.1
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 on AIX 5.3 TL04 and higher with Oracle 10.2.0.1 and later
*** NAS devices are only supported with HPUX 11.23 or higher ONLY


# These mount options are for Linux kernels 2.6 and above. For older kernels please check Note 279393.1

## 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

未经允许不得转载:Oracle一体机用户组 » RAC环境本地归档备份失败问题

相关推荐