Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> RMAN BACKUP TO REMOTE MACHINE, RMAN BACKUP TO REMOTE MACHINE
aleck
post Nov 2 2011, 10:32 AM
Post #1


Member
**

Group: Members
Posts: 16
Joined: 5-March 10
Member No.: 42,732



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!
Go to the top of the page
 
+Quote Post
burleson
post Nov 2 2011, 05:56 PM
Post #2


Advanced Member
***

Group: Members
Posts: 11,634
Joined: 26-January 04
Member No.: 13



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

QUOTE
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:

QUOTE
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
##################


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
aleck
post Nov 3 2011, 01:02 AM
Post #3


Member
**

Group: Members
Posts: 16
Joined: 5-March 10
Member No.: 42,732



QUOTE (burleson @ Nov 2 2011, 05:56 PM) *
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
Go to the top of the page
 
+Quote Post
BrianTran
post Mar 27 2012, 02:15 PM
Post #4


Newbie
*

Group: Members
Posts: 2
Joined: 27-March 12
Member No.: 46,984



QUOTE (aleck @ Nov 3 2011, 01:02 AM) *
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.
Go to the top of the page
 
+Quote Post
burleson
post Mar 27 2012, 02:47 PM
Post #5


Advanced Member
***

Group: Members
Posts: 11,634
Joined: 26-January 04
Member No.: 13



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



QUOTE
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






--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
BrianTran
post Mar 29 2012, 11:24 AM
Post #6


Newbie
*

Group: Members
Posts: 2
Joined: 27-March 12
Member No.: 46,984



QUOTE (burleson @ Mar 27 2012, 02:47 PM) *
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




Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 31st October 2014 - 07:01 AM