在Linux系统下,将另一台aix机器上的存储mount到linux下通过nfs,然后在linux下使用expdp导出数据存储在mount到linux下的磁盘上报错
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 6
解决访问
Alter system set events '10298 trace name context forever,level 32'
执行这个命令，不需要重新启动,但在下次数据库重新启动后就失效了，需要再次手工执行。
如果想数据库重新启动后，自动执行这个命令，则执行下面的命令：
SQL>alter system set event='10298 trace name context forever,level 32' scope=spfile;
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-------------------------------另一例-------------------------------
今天在虚拟机环境下做实验，在将RAC环境修改为flashback on时，报出了ORA-27054错误，错误代码如下：
Errors in file /u01/app/oracle/admin/racdb/udump/racdb2_ora_25551.trc:
ORA-38701: Flashback database log 2 seq 1 thread 2: "/u01/flashback/RACDB/flashback/o1_mf_%u_.flb"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
从错误描述可以看出，闪回目录是通过nfs文件系统来实现的，而系统挂载nfs时，采用了错误的参数选项，导致oracle报错。上网查资料，通过文档359515.1顺利解决问题。整理部分内容如下：
* NFS mount option “forcedirectio” is required on Solaris platforms when mounting the OCR/CRS files when using Oracle 10.1.0.4 or 10.2.0.2 or later (Oracle unpublished bug 4466428)
** AIX is only supported with NAS on AIX 5.3 TL04 and higher with Oracle 10.2.0.1 and later (NetApp)
*** NAS devices are only supported with HPUX 11.23 or higher ONLY
# These mount options are for Linux kernels 2.6 and above for older kernels please check Note 279393.1
* actime=0 or noac can be used
参照上文，修改mount参数如下：
[root@node2 bdump]# cat /etc/rc.d/rc.local
#!/bin/sh
#
# This script will be executed *after* all the other init scripts.
# You can put your own initialization stuff in here if you don't
# want to do the full Sys V style init stuff.
touch /var/lock/subsys/local
service iscsi restart
#start_udev
modprobe hangcheck-timer
mount -t nfs -o rw,bg,noac,hard,nointr,rsize=32768,wsize=32768,nolock,proto=tcp,actimeo=0,vers=3,timeo=600 192.168.2.31:/u01/flashback/ /u01/flashback/
问题成功解决！
另外，在网上查到资料，还可以使用如下方式解决
1：设置事件10298 level 32
alter system set event='10298 trace name context forever,level 32' scope=spfile;
重新启动数据库后生效.
2：打补丁:5146667
我没有试验，有兴趣的朋友可以试试，