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 文件系统中写入。