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

时间: 2024-11-06 07:34:46

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

【Oracle 集群】11G RAC 知识图文详细教程之RAC在LINUX上使用NFS安装前准备(六)

RAC在LINUX上使用NFS安装前准备(六) 介绍                                   回到顶部 下载软件 l  Oracle Enterprise Linux 5.7 l  Oracle 11 g版本2(11.2)和修改和数据库软件 回到顶部 操作系统安装 本文使用Oracle Enterprise Linux 5.7. 一般的图形操作系统安装指南在这里. 更具体地说,它应该是一个服务器安装的2 g交换(最好是3-4G),Linux禁用防火墙和安全. Orac

ORA-16038的解决(日志无法归档)

ORA-16038的解决 数据库装载完毕. ORA-16038: 日志 3 序列号 5035 无法归档 ORA-19809: 超出了恢复文件数的限制 ORA-00312: 联机日志 3 线程 1: ......REDO03.LOG' DB是归档模式, 每个日志组只有一个文件(新太公司的人通常使用的方法,FT), 没办法, 搜寻文档和晚上的资料, 有如下的解决方法: 损坏非当前联机日志: 1.启动数据库,遇到ORA-00312 or ORA-00313错误,如: ORA-00313: open f

[20170309]关于在线日志与归档1.txt

[20170309]关于在线日志与归档1.txt --//当日志写满了,或者执行手工了切换,再或者rman备份时有时也会触发日志切换: alter system switch logfile ; alter system archive log current ; --//本文简单探究日志归档是如何保存的.先探查os块. 1.环境: --//启动到mount状态. SYS@book> @ &r/ver BANNER --------------------------------------

[20170309]关于在线日志与归档2.txt

[20170309]关于在线日志与归档2.txt --//当日志写满了,或者执行手工了切换,再或者rman备份时有时也会触发日志切换: alter system switch logfile ; alter system archive log current ; --//本文简单探究日志归档是如何保存的.探查日志文件头块. 1.环境: --//启动到mount状态. SYS@book> @ &r/ver BANNER ------------------------------------

[20170310]关于在线日志与归档4.txt

[20170310]关于在线日志与归档4.txt --//如果你顺便看归档日志目录,在线日志50M,你可以发现最大归档43M上下.也就是在线日志大于45M后面这些块基本不会写入日志记录信息. --//比如查询如下: #  ls -l -S -h /data/log/ORCL/archivelog/| head -10 total 27G -rw-r----- 1 oracle oinstall  43M 2017-03-02 10:53:07 0001_0000051850_628034536.

RAC的undo_management导致数据库mount报ORA-01105 ORA-01606

环境Linux 5.8 10.2.0.5 RAC,两个节点只能一个节点mount,如果尝试mount另外节点就报ORA-01105和ORA-01606错误 数据库版本  代码如下 复制代码 SQL> select * from v$version;   BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2

DELETE OBSOLETE不删除归档日志以及归档的备份集

今天遇到一个奇怪的事情,使用OBSOLETE不删除归档日志,而且也不删除过期的归档的BACKUP SET 从delete obsolete的概念来看如下: The REPORT OBSOLETE and DELETE OBSOLETE commands work in two steps:                                                                                                         

【RAC】Oracle RAC环境的日志体系

在Oracle RAC环境中比单个系统的日志体系要复杂:见下图: 简单介绍一下有关Oracle集群环境中日志体系结构,在遇到问题时,可以快速查找所需的日志文件,及时的定位问题~ 1.Oracle集群日志的文件路径 Oracle集群涉及的日志主要位于"$GRID_HOME/log"和"$ORACLE_HOME/log"目录中. 2.日志目录结构 clusterware 层的日志结构: grid@rac1:/home/grid>tree -d $ORACLE_HO

oracle 11g rac 添加重做日志文件

1)实验思路: [1]查看当前联机重做日志文件信息 [2]实验前进行必要的文件备份 [3]增加两组联机重做日志文件,每个文件大小为2G [4]查看oracle运行状态,每个实例各一个,这样每个实例一共各有5个日志文件 [5]再次增加一组日志文件,每个实例各一个,这样每个实例一共有5个日志文件 [6]删除原来的两组300MB的日志文件 [7]增加两组2G的日志文件 2)首先查看当前联机日志文件状态 从数据库的逻辑层面查看 export ORACLE_SID=rac1 sqlplus /nolog