RMAN BACKUP TO REMOTE MACHINE, RMAN BACKUP TO REMOTE MACHINE Options

[aleck]

Hi all,

am trying to backup my oracle database using RMAN to a remote machine. both systems are using redhat linux.
i have successfully configured NFS on my remote machine and mounted it from my oracle database machine.

i then configure rman channel to disk on mounted linux directory

when i take full backup of database i receive this error

ORA-19504: failed to create file "/mnt/ora_df766174940_s104_s1"
ORA-27054: NFS file system where the file is created or resides is not mounted w
ith correct options
Additional information: 3

How do i mount this with correct options the error msg says OR what do i do to backup to the said directory?

Any one help please!

[burleson]

Hi Aleck,

This was a known bug! See MOSC

MOSC Note 359515.1: Mount Options for Oracle files when used with NAS devices
MOSC Note 387700.1: ORA-27054 ERRORS WHEN RUNNING RMAN WITH NFS
MOSC Note 338086.1

http://support.oracle.com


**************************************
>> RMAN write via NFS filesystem

Try these option:

CODE

mount nfs rw,bg,hard,intr,rsize=32768,wsize=32768,vers=3,timeo=600,tcp

or

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

or

mount rw,bg,intr,hard,timeo=600,wsize=32768,rsize=32768,nfsver=3,tcp

or

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

The "hard" and "noac" will greatly improve RMAN write speed across NFS!

Beware, you may need to use a non-NFS filesystem!

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

Oracle cannot write to the file via the NFS mount!

See here:

http://www.dba-oracle.com/t_ora_27054.htm

Make sure mount tab file has read access for Oracle user and the NFS partition where the file resides is mounted correctly. For the list of mount options to use refer to your platform specific documentation.

Paulo Portugal noted this for using RMAN via NFS:

I resolve my problem using the following on my /etc/fstab file:
##################
192.168.15.126:/media/backup /media/backup nfs hard,rw,noac,rsize=32768,wsize=32768,suid,proto=tcp,vers=3
##################

[aleck]

Hi Aleck,

This was a known bug! See MOSC

MOSC Note 359515.1: Mount Options for Oracle files when used with NAS devices
MOSC Note 387700.1: ORA-27054 ERRORS WHEN RUNNING RMAN WITH NFS
MOSC Note 338086.1

http://support.oracle.com


**************************************
>> RMAN write via NFS filesystem

Try these option:

CODE

mount nfs rw,bg,hard,intr,rsize=32768,wsize=32768,vers=3,timeo=600,tcp

or

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

or

mount rw,bg,intr,hard,timeo=600,wsize=32768,rsize=32768,nfsver=3,tcp

or

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

The "hard" and "noac" will greatly improve RMAN write speed across NFS!

Beware, you may need to use a non-NFS filesystem!

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

Oracle cannot write to the file via the NFS mount!

See here:

http://www.dba-oracle.com/t_ora_27054.htm



Paulo Portugal noted this for using RMAN via NFS:

Thanks Paulo
this option has just worked for me
##################
192.168.15.126:/media/backup /media/backup nfs hard,rw,noac,rsize=32768,wsize=32768,suid,proto=tcp,vers=3
##################
Many thanks

[BrianTran]

Thanks Paulo
this option has just worked for me
##################
192.168.15.126:/media/backup /media/backup nfs hard,rw,noac,rsize=32768,wsize=32768,suid,proto=tcp,vers=3
##################
Many thanks

I'm having this issue too ... with RMAN and datapump. When advise to my sys admin to make the change in the NFS mount, he inform me that this is the old way and only works with MANUAL mounts. Not automount. Is there a way I can check? I'm not a sys admin and not familiar with the NFS mount.

[burleson]

Hi Brian,

>> I'm having this issue too ...

I would reference MOSC Note 359515.1: Mount Options for Oracle files when used with NAS devices


See here:

http://docs.oracle.com/cd/B28359_01/instal...263/storage.htm

Checking NFS Mount and Buffer Size Parameters for ClusterwareIf you are using NFS, then you must set the values for the NFS buffer size parameters rsize and wsize to 32768.

The NFS mount options are:

rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,noacUpdate the /etc/fstab file on each node with an entry containing the NFS mount options for your platform. For example, if your platform is x86-64, then update the /etc/fstab files with an entry similar to the following:

nfs_server:/vol/CWfiles /u01/oracle/cwfiles nfs \rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,noacNote that mount point options are different for Oracle software binaries, Oracle Clusterware files (OCR and voting disks), and data files.

If you want to create a mount point for binaries only, then provide an entry similar to the following for a binaries mount point:

nfs_server:/vol/crshome /u01/oracle/crs nfs -yesrw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actime=0

**********************************
>> Is there a way I can check?

I would reference the documentation from MOSC:

http://support/oracle.com

[BrianTran]

Hi Brian,

>> I'm having this issue too ...

I would reference MOSC Note 359515.1: Mount Options for Oracle files when used with NAS devices


See here:

http://docs.oracle.com/cd/B28359_01/instal...263/storage.htm





**********************************
>> Is there a way I can check?

I would reference the documentation from MOSC:

http://support/oracle.com

Thanks for the response. Does this apply if we are not using clusterware? I look for documentation from oracle and only found it for clusterwares. I'm on Solaris.

http://docs.oracle.com/cd/B28359_01/instal...ge.htm#CWSOL243