Re: Oracle-RMAN-Backup on NFS-Linux-Server

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 12 Mar 2006 13:19:49 -0800
Message-ID: <1142198372.551217@yasure.drizzle.com>

Sybrand Bakker wrote:
> On Tue, 07 Mar 2006 12:04:37 -0800, DA Morgan <damorgan_at_psoug.org>
> wrote:
>

>> sybrandb_at_yahoo.com wrote:
>>> Oracle never fully supported NFS, not for datafiles and not for
>>> backups.
>>> Time to find your Visa or Mastercard and buy extra local storage or get
>>> a tape drive.
>> Oracle fully supports NFS 3 and above and uses it internally.

>
> I'm not too sure about that. I'm now in a situation where I have to
> duplicate a database to a NFS mounted fs using rman.
> The restore just hangs forever and the datafiles never come off in
> full.
> Metaclunk, as pretty much usual, is of no help in resolving this
> problem.
> So does Oracle support nfs? I don't think so.
>
> --
> Sybrand Bakker, Senior Oracle DBA

I use RMAN with NFS mounts all the time with no problems.

When I experience what you describe, and I have on a few occasions, it is always due to one of two things:

Temporary NFS mount ... not permanent
Incorrect mount string which Oracle sees and doesn't trust

For example:

# mount -t nfs 192.168.2.100:/vol/vol0 /mnt will give RMAN errors but
netapp1:/vol/vol0/alpha /u01 nfs
rw,bg,intr,hard,rsize=32768,wsize=32768,noac,nolock,tcp,vers=3 0 0 does not and works with RAC, RMAN, etc.

Please note the above strings are for a NetApp F810 and may not work with other hardware or with NetApp and other versions of their O/S.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Sun Mar 12 2006 - 15:19:49 CST