Friday, March 27, 2009

ORA-27054 on NFS file system on AIX for backup

On AIX 5.3 ML4 and up which is the supported version to be used with NAS devices and database 10gR2 allthough you create nfs filesystems rman reports the following error :

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

This is happenig because on Oracle 1gR2 Oracle checks the options with which a NFS mount is mounted on the filesystem.
Correct option for AIX datafiles and backup are :
cio,rw,bg,hard,nointr,rsize=32768,wsize=32768,proto=tcp,noac,vers=3,timeo=600

If you mount your NFS filesystems and you got on this error this is due to bug 5146667

If availiable apply patch. Else use the follwoing work arround:

1) set the Event 10298 in the init file event="10298 trace name context forever, level 32"

If you are using the spfile then :
SQL> alter system set event='10298 trace name context forever, level 32'scope= spfile sid='*';
Once you set the above parameter restart the instance.
Check as follows
SQL> select name, value from v$parameter where name = 'event';
NAME VALUE
---------- ------------------------------------------------------------
Event 10298 trace name context forever, level 32

Then try the backups again.

sid='*' is for RAC. For single instance do not use it.

1 comment:

  1. Thanks! I had this problem and your write-up resolved it for me. My problem was the mount was not mounted with the correct options.

    mount -o rw,bg,hard,nointr,rsize=32768,wsize=32768,proto=tcp,vers=3,timeo=600 10.10.10.10:/ /your/mount/point

    ReplyDelete