ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-27054: NFS file system where the file is created ...

ORA-27054: NFS file system where the file is created ...

原创 Linux操作系统 作者:xz43 时间:2013-10-17 08:51:28 0 删除 编辑
由于本地磁盘空间有限,mount挂载在其他远程服务器上的一个共享存储作为数据备份目录,结果发现备份失败:
Export: Release 10.2.0.1.0 - 64bit Production on Thursday, 17 October, 2013 5:30:01

Copyright (c) 2003, 2005, Oracle.  All rights reserved.
;;; 
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/db_backup/zzzdx_XXX.dmp"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3

检查/db_backup 目录,读写权限正常。

通过oracle官方解释说:

Error: ORA-27054 
Text: NFS file system where the file is created or resides is not mounted with correct options
---------------------------------------------------------------------------
Cause: The file was on an NFS partition and either reading the mount tab 
file failed or the partition wass not mounted with the correct 
mount option.

Action: Make sure mount tab file has read access for Oracle user and
the NFS partition where the file resides is mounted correctly. 
For the list of mount options to use refer to your platform 
specific documentation.


*** Important: The notes below are for experienced users - See Note:22080.1

Explanation:
As of Oracle 10.2 the IO interface layer in Oracle tries
to check that the mount options of any NFS mounted disk
used have mount options which ensure that the NFS volume
is safe to use as incorrectly mounted NFS volumes can 
result in data corruption problems.

Diagnosis:
The exact checks used for an NFS mounted disk vary between
platforms but in general the basic checks will include
checking that:
- The mount table (eg; /etc/mnttab) can be read to
check the mount options
- That the NFS mount is mounted with the "hard" option
- The mount options include rsize>=32768 and wsize>=32768
- For RAC environments, where NFS disks are supported, 
that the "noac" mount option is used.

Different platforms may use different or additional checks.
Note that the main checks currently check the mount options
used and not the underlying NFS attributes (as seen from
nfsstat -m on most Unix platforms) and so a disk may appear
to be mounted correctly with nfsstat (-m) but Oracle may 
report ORA-27054 errors if the required options were not
explicitly stated at mount time.

If reporting an ORA-27054 error the additional information
in the error message and the platform. and Oracle version
are all required to help confirm the exact reason for failing
to treat the NFS disk as correctly mounted.

如是,手动重新挂载
# nmount /db_backup
# mount -t nfs -o rw,hard,nointr,tcp,noac,vers=3,timeo=600,rsize=32768,wsize=32768  12.1.1.9:/databak /db_backup
再次备份,恢复正常。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9399028/viewspace-774511/,如需转载,请注明出处,否则将追究法律责任。

上一篇: linux下vi命令大全
请登录后发表评论 登录
全部评论

注册时间:2010-11-16

  • 博文量
    407
  • 访问量
    1732546