RAC Ora-27054 導緻使用NFS的日志不能歸檔

日志錯誤如下

WARNING:NFS file system /archive mounted with incorrect options

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

Sat Sep 22 18:29:43 2012

Errors in file /home/oracle/product/admin/rac/udump/rac1_ora_23076.trc:

ORA-19504: failed to create file "/archive/1_5_794627553.dbf"

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

Additional information: 3

ARCH: Error 19504 Creating archive log file to '/archive/1_5_794627553.dbf'

ARC2 started with pid=28, OS id=23112

ARC2: Archival started

ARC0: STARTING ARCH PROCESSES COMPLETE

ARC0: Becoming the heartbeat ARCH

ARCH: Failed to archive thread 1 sequence 5 (19504)

ORA-16038: log 2 sequence# 5 cannot be archived

ORA-19504: failed to create file ""

ORA-00312: online log 2 thread 1: '+DATA/rac/redo02.log'

如此可以看到是歸檔出現了錯誤。

metalink 說明如下:

Receiving error Ora-27054 When Running Rman With NFS [ID 424785.1] 轉到底部 

--------------------------------------------------------------------------------

修改時間:2011-11-29類型:PROBLEM狀态:MODERATED優先級:3 注釋 (0)    

In this Document

  Symptoms

  Changes

  Cause

  Solution

  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later   [Release: 10.2 and later ]

Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later    [Release: 10.2 and later]

Information in this document applies to any platform.

***Checked for relevance on 29-Nov-2011***

Symptoms

Receiving error ora-27054 while running RMAN with NFS.

Changes

Cause

Improper NFS mount options are used. This behaviour has been observed on Solaris Linux and AIX Platforms.

BUG:5146667 ORA-27054 ERRORS WHEN RUNNING RMAN WITH NFS

Solution

Workarounds:

- Use the event 10298 (It can have a side effect of disabling direct IO on RAC using regular files on NFS mounts)

Reference : NOTE:387700.1 ORA-27054 ERRORS WHEN RUNNING RMAN WITH NFS

OR

Apply Patch 5146667

- Set the mount options explictly.

Here are the mount options that need to be used for nfs volumes on Linux.

Use :

rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0

- default rsize and wsize for NFS is 4096 Blocks

so if you have rsize=32k and wsize=32k then NFS would be able to read and write large datagram as compared to deafult one

- TCP option will make sure that your client are getting the data or not

- Hard & INTR

The program accessing a file on a NFS mounted file system will hang when the

server crashes. The process cannot be interrupted or killed unless you also specify intr. When

the NFS server is back online the program will continue undisturbed from where it was.

- actimeo is for access timeout and it should be 0