oracle导出到nfs未响应,Oracle 11.2.0.1 expdp data to NFS 失败处理一例

Database Envrioment : oracle 11.2.0.1 standalone with ASM on solaris 10 sp2

expdp 导出报错

chndsora9:/export/home/oracle\> expdp \'/as sysdba\' directory=datapump full=y  dumpfile=cdwii01_fullexp.dmp logfile=cdwii01_fullexp.log

Export: Release 11.2.0.1.0 - Production on Sat Jan 18 11:15:14 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, Automatic Storage Management and Real Application Testing options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31641: unable to create dump file "/expdump/cdwii01/cdwii01_fullexp.dmp"

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

Additional information: 3

此时alert 日志报错如下：

DM00 started with pid=92, OS id=10839, job SYS.SYS_EXPORT_FULL_01

WARNING:NFS mount of file /expdump/cdwii01/cdwii01_fullexp.dmp on filesystem /expdump done with incorrect options

WARNING:Expected NFS mount options: rsize>=32768,wsize>=32768,hard,

检查NFS mount 属性 无问题：

10.64.34.40:/expdump  -    /expdump        nfs   2 yes rw,bg,noac,rsize=32768,wsize=32768,hard,actimeo=0,nointr,vers=4,timeo=600

umount之后重新mount

mount -F nfs -o rw,hard,nointr,noac,vers=3,rsize=32768,wsize=32768 10.64.34.40:/expdump /expdump

【注意】 通过mos 可以找到该 ORA-27054 会存在一个bug，bug NO.4968488

mount成功后，执行expdp 恢复正常，数据库可往NFS 文件系统中写入。