Oracle 使用nfs挂载的目录不能进行归档

在做实验时将Oracle的归档目录放在nfs服务器上，启动数据库就会死掉，也不能进行归档。

在报警日志中发现

WARNING:NFS file system /mnt mounted with incorrect options
WARNING:Expected NFS mount options: rsize>=16384,wsize>=16384,hard,noac/actimeo=0
Wed Apr 17 06:28:15 2013
Errors in file /u01/oracle/admin/sid31/bdump/sid312_arc1_21845.trc:
ORA-19504: failed to create file "/arc/arc1/2_13_812841120.arc"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
ARC1: Error 19504 Creating archive log file to "/arc/arc1/2_13_812841120.arc"
ARC1: Failed to archive thread 2 sequence 13 （19504）
ARCH: Archival stopped, error occurred. Will continue retrying
Wed Apr 17 06:28:18 2013
ORACLE Instance sid312 - Archival Error
Wed Apr 17 06:28:18 2013
ORA-16038: log 3 sequence# 13 cannot be archived

重新修改挂载方式

mount 192.168.1.31:/arc /mnt -o rsize=65534,wsize=65534,hard,noac,actimeo=0 /mnt

在修改后重新启动数据库发现还是起不了

报错内容：

Errors in file /u01/oracle/admin/sid31/udump/sid312_ora_27149.trc:
ORA-19504: failed to create file "/arc/arc1/2_13_812841120.arc"
ORA-27086: unable to lock file - already in use
Linux Error: 37: No locks available
Additional information: 10
Wed Apr 17 06:32:15 2013
ARCH: Error 19504 Creating archive log file to "/arc/arc1/2_13_812841120.arc"
ARCH: Failed to archive thread 2 sequence 13 （19504）

这个再加一个nolock选项就可以了

mount 192.168.1.31:/arc /mnt -o rsize=65534,wsize=65534,hard,noac,actimeo=0,nolock /mnt更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12Windows下NoSQL MongoDB数据库配置篇Oracle最简单的查询表空间的使用量、剩余量的方法相关资讯 NFS挂载 Oracle归档

alter system archive log current （11/26/2014 11:09:24）
Linux NFS挂载时失败，报错：mount （08/01/2014 11:10:24）
Oracle 归档错误案例（05/22/2014 10:49:48）

Oracle在归档模式下删除非系统文件（09/19/2014 06:47:20）
Oracle 10g/11g RAC 启停归档模式（07/22/2014 10:17:32）
Oracle RAC归档管理：修改归档位（03/16/2014 17:31:05）

本文评论查看全部评论（0）