欢迎光临
我们一直在努力

EXPDP 时ORA-27054 问题处置

现象:

[oracle@oracle1 ~]$ expdp xian/xian schemas=xian directory=dumpdir dumpfile=xian.dmp LOGFILE=xian.log

Export: Release 10.2.0.5.0 – 64bit Production on Friday, 02 December, 2016 20:19:48

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31641: unable to create dump file “/backup/xian.dmp”

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

Additional information: 3

Additional information: 18

原因:

文件夹MOUNT NFS时未加相关参数

需要追加参数:rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0

解决:改成如下

 mount -t nfs -o rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0 10.71.13.109:/oracle/backup/ /backup

赞(0)
【声明】:本博客不参与任何交易,也非中介,仅记录个人感兴趣的主机测评结果和优惠活动,内容均不作直接、间接、法定、约定的保证。访问本博客请务必遵守有关互联网的相关法律、规定与规则。一旦您访问本博客,即表示您已经知晓并接受了此声明通告。