This discussion is archived

1 2 3 Previous Next 36 Replies Latest reply: May 30, 2011 12:21 AM by ADaniel

10gR2 "database backup" to nfs mounted dir results in ORA-27054 NFS error

451702 Sep 7, 2005 11:27 AM

Currently Being Moderated

All db and archive files reside on normal non-nfs file systems, but do to old space limitations we pointed the "database backup" command to write to an nfs mounted file system.

This was never an issue until we registered a new 10gR2 db in rman. All other db's backup fine, but the 10gR2 db results in the following error:

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

I've found some documentation for oracle on linux (we're Solaris also) that suggests special mount options are required:

http://download-uk.oracle.com/docs/cd/B19306_01/install.102/b15660/app_nas.htm#BCFEAHIC

specifically hard,rsize,wsize, and noac

But this doc is for linux, and appears to be geared to DB datafiles, and i'm not sure if they apply to Solaris and RMAN.

Our current mount options for the dir in question are:

remote/read/write/setuid/bg/xattr/dev=4e00005

Anybody know what we're missing specifically? And why its an issue in 10gR2, but not in previous releases?

Thanks!
Tony

1. Re: 10gR2 "database backup" to nfs mounted dir results in ORA-27054 NFS error

451702 Sep 13, 2005 1:45 PM (in response to 451702)

Currently Being Moderated

In case anyone is interested,

we resolved the issue by switching to a non-nfs file system, but haven't pinned down the exact options required to use nfs with RMAN.

Tony
Report Abuse

Like (0)
2. Re: 10gR2 "database backup" to nfs mounted dir results in ORA-27054 NFS err

RonaldRood Sep 19, 2005 3:21 AM (in response to 451702)

Currently Being Moderated

Are the other databases backed up to the same nfs mount ? As far as I know oracle does support netapp, others I don't know about. The requirements for the backup pieces and the datafiles will be the same.

Ronald.
http://ronr.nl/unix-dba
Report Abuse

Like (0)
3. Re: 10gR2 "database backup" to nfs mounted dir results in ORA-27054 NFS error

451702 Sep 19, 2005 8:12 AM (in response to 451702)

Currently Being Moderated

Thanks for the post,

Yes all databases 10gR2 and various previous releases were backing up to the same nfs mount. Only the 10gR2 db's errored however.
Report Abuse

Like (0)
4. Re: 10gR2 "database backup" to nfs mounted dir results in ORA-27054 NFS error

195326 Sep 20, 2005 12:17 PM (in response to 451702)

Currently Being Moderated

We have same issue and wonder if you already have solution for this issue, if so please let us know.

Thanks,
Thanh Ngo
Report Abuse

Like (0)
5. Re: 10gR2 "database backup" to nfs mounted dir results in ORA-27054 NFS error

451702 Sep 20, 2005 12:52 PM (in response to 451702)

Currently Being Moderated

Our solution was to redirect RMAN to backup to a non-nfs mounted file system.

I mentioned a few article which detail recommended mount options for nfs file systems and Oracle. But they were for Linux systems, and not terribly specific.

Other than that we have not investigated the issue further, or seen any other informative explanations here, on metalink, or on OTN.

Tony
Report Abuse

Like (0)
6. Re: 10gR2 "database backup" to nfs mounted dir results in ORA-27054 NFS error

195326 Sep 21, 2005 7:18 AM (in response to 451702)

Currently Being Moderated

Thanks for your response. We need solution for this issue. Most of our backup filesystems are NFS mount.

Thanks,
Thanh Ngo
Report Abuse

Like (0)
7. Re: 10gR2 "database backup" to nfs mounted dir results in ORA-27054 NFS error

451702 Sep 21, 2005 8:51 AM (in response to 451702)

Currently Being Moderated

Sorry, I couldn't be of more help. When you resolve the issue, please post the solution here. I am very curious to know the specifics, but as of yet had not had the time to investigate further myself.

Tony
Report Abuse

Like (0)
8. Re: 10gR2 "database backup" to nfs mounted dir results in ORA-27054 NFS error

458029 Oct 3, 2005 2:34 PM (in response to 451702)

Currently Being Moderated

I am using the following options and it works.

mount -o hard,rw,noac,rsize=32768,wsize=32768,suid,proto=tcp,vers=3
Report Abuse

Like (0)
9. Re: 10gR2 "database backup" to nfs mounted dir results in ORA-27054 NFS error

458249 Oct 4, 2005 12:23 PM (in response to 458029)

Currently Being Moderated

With these settings was the backup speed per sec the same or longer.
mount -o hard,rw,noac,rsize=32768,wsize=32768,suid,proto=tcp,vers=3

When I changed the mount options to rsize=32768,wsize=32768, hard, noac,
my backup speed when from 9MB per second to 316KB per second.
Plus all of my Oracle 9i backup to the same NFS mounts were slower too.
Report Abuse

Like (0)
10. Re: 10gR2 "database backup" to nfs mounted dir results in ORA-27054 NFS error

RonaldRood Oct 4, 2005 12:34 PM (in response to 458249)

Currently Being Moderated

Try increasing the buffersizes (rsize/wsize). That should make a difference.

Ronald
http://homepage.mac.com/ik_zelf/oracle
Report Abuse

Like (0)
11. Re: 10gR2 "database backup" to nfs mounted dir results in ORA-27054 NFS error

458249 Oct 4, 2005 12:58 PM (in response to RonaldRood)

Currently Being Moderated

Are you saying rsize=65536,wsize=65536,hard,noac
or rsize=131072,wsize=131072,hard,noac
Report Abuse

Like (0)
12. Re: 10gR2 "database backup" to nfs mounted dir results in ORA-27054 NFS error

RonaldRood Oct 4, 2005 1:07 PM (in response to 458249)

Currently Being Moderated

Yes, try a few values and see how it influences the performance.
Report Abuse

Like (0)
13. Re: 10gR2 "database backup" to nfs mounted dir results in ORA-27054 NFS error

458249 Oct 6, 2005 1:22 PM (in response to RonaldRood)

Currently Being Moderated

The problem is the same issue. Performance was very poor. A database backup to local disks took 3 minutes. The same backup to NFS mounted disk with rsize and wsize set to 32768, 16384, or 1048576 was 1 hour and 9 minutes.

Do you know a way to turn this checking off?
Report Abuse

Like (0)
14. Re: 10gR2 "database backup" to nfs mounted dir results in ORA-27054 NFS error

458249 Oct 18, 2005 8:59 AM (in response to 458249)

Currently Being Moderated

After many days and many test runs, Oracle Tech Support and I finally found the solution that work for me. rw,bg,intr,hard,timeo=600,wsize=32768,rsize=32768,nfsver=3,tcp
Now my backups to local disks and to NFS mounted disk are the same.
For the backup that took 3 minutes to local disks and the same backup to NFS mounted disk took 1 hour and 9 minutes, both now take 3 minutes.
This solution works with no adverse affect on my Oracle9i RMAN backups to the same NFS mounted disks.
Report Abuse

Like (0)

1 2 3 Previous Next

Go to original post

Actions

Incoming Links

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