RAC Ora-27054 导致使用NFS的日志不能归档

简介: 日志错误如下 WARNING:NFS file system /archive mounted with incorrect optionsWARNING:Expected NFS mount options: rsize>=16384,wsize>=1638...

日志错误如下

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
Sat Sep 22 18:29:43 2012
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
Sat Sep 22 18:29:43 2012
ARCH: Failed to archive thread 1 sequence 5 (19504)
Sat Sep 22 18:29:43 2012
Errors in file /home/oracle/product/admin/rac/udump/rac1_ora_23076.trc:
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


OR

- 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

这里还有一个文章可以参考http://blog.163.com/rocolex/blog/static/6844641020102994639992/

相关实践学习
日志服务之使用Nginx模式采集日志
本文介绍如何通过日志服务控制台创建Nginx模式的Logtail配置快速采集Nginx日志并进行多维度分析。
相关文章
|
3月前
|
存储 运维 应用服务中间件
[运维日志] Web 服务器日志依日期归档(Powershell 实现,附源代码)
[运维日志] Web 服务器日志依日期归档(Powershell 实现,附源代码)
74 0
|
3月前
|
Go
Golang日志切割归档
Golang日志切割归档
30 0
|
9月前
|
监控 关系型数据库 Shell
[翻译]PG15新特性-加速WAL日志归档
[翻译]PG15新特性-加速WAL日志归档
101 0
|
11月前
|
存储 运维 Java
[powershell运维] Web 服务器日志依日期归档
本文记录了一个以 Jboss 服务器日志归档的 powershell 示范项目。该项目只需要略加修改,即可用于所有类似需要归档日志的场景。
106 0
|
Oracle 关系型数据库 Linux
DM8重做日志文件和归档管理
重做日志文件,用来保存redo日志,redo日志默认2个,循环使用,不断覆盖,联机日志由系统自动切换,不能手动切换,联机日志过小,会制造日志频繁切换,过大则浪费磁盘空间。
DM8重做日志文件和归档管理
rac 归档路径设置
rac 归档路径设置
98 0
|
SQL 分布式计算 监控
SLS投递到OSS不仅仅是归档!借助DLA元信息发现功能一键激活日志数据的分析价值
为了降低存储成本,不少客户会选择SLS数据搭配OSS进行冷热分离,把全量数据投递到OSS,近实时数据查询使用SLS。但是这些投递到OSS的数据难以分析,目前基于DLA的元信息发现功能一键激活日志数据的分析价值,然后搭配DLA的Serverless Presto和Spark进行数据处理和分析。
SLS投递到OSS不仅仅是归档!借助DLA元信息发现功能一键激活日志数据的分析价值
|
监控 Shell Linux