Oracle Data Backup process in case of BUG_ORA-27054NFSfilesystem

Oracle fault ORA-27054NFSfilesystemwherethefileiscreatedorresidesisnotmountedwithcorrectoptions in Data Backup

Oracle fault ORA-27054 NFS file system where the file is created or resides is not mounted with correct options in Data Backup

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

During the data backup process, the NFS file system is used, so a BUG occurs during the import. The error is as follows:

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/exp/bak/expdp_01.dmp"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 6

Query the metalink id: 387700.1

There are several possible problems in this document:
A) The mount table (eg;/etc/mnttab) can be read to check the mount options
B) The NFS mount is mounted with the "hard" option
C) The mount options include rsize> = 32768 and wsize> = 32768
D) For RAC environments, where NFS disks are supported, the "noac" mount option is used.

It is pointed out in the document that you can avoid it by setting event 10298 events. However, to set event 10298, You need to restart the database to take effect. Currently, it is the production environment, which cannot be used.

By adjusting the preceding parameters, hard, rsize, and wsize cannot be solved.

Finally, check the NFS configuration and find that no entries of the mount nfs file system are added to/etc/filesystems on the client.

Add the following entries and mount them again.

# Vi/etc/filesystems
/Exp:
Dev =/exp
Vfs = nfs
Nodename = 192.168.1.20
Mount = true
Options = rw, bg, hard, intr, proto = tcp, vers = 3, rsize = 65536, wsize = 65536, timeo = 600
Account = false

# Umount/oraexp
# Mount/oraexp

We recommend that you check the/etc/filesystems file first if you encounter a similar problem later. This problem is caused by the following methods used to mount nfs.

Mount-o rw, bg, hard, intr, proto = tcp, vers = 3, rsize = 65536, wsize = 65536, timeo = 600 192.168.1.20:/exp

// Related metalink documents are as follows:

ORA-19504 ORA-27054 Errors mounting NFS file system [ID 370513.1]
RMAN Backup Fails With RMAN-03009 ORA-19504 ORA-27054 NFS file system where the file is created or resides is not mounted with correct options [ID 1472448.1]
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options [ID 781349.1]

// The process of setting 10298 is as follows:

1) set the Event 10298 in the init file
Event = "10298 trace name context forever, level 32"
If you are using the spfile then the following can be done

SQL> alter system set event = '2014 trace name context forever, level 32 'scope = spfile;

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

1 row selected.

For more information about Oracle, see the Oracle topic page? Tid = 12