RMAN backup unable to write to share

441858

Oracle 11gR2 OEL5 64bit

I am unable to execute my backups because the files cannot be written to the NFS share. The share has been mounted with 'oracle:oinstall' and '777' for permissions. However, I still get the following error:

ORA-19504: failed to create file "/rman/backup/prod/ctrl_file.bckp"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 22: Invalid argument

I have researched different mount option on ML and I have tried them also, but I still get the same issue. It's weird because the last time I did this it worked and it was also able read and recover the files from the share.

Is there a mount option out there that works so that RMAN can write to an NFS share?

I used the following opton:

mount -t cifs -o username=winorcl,rw,dir_mode=0777,file_mode=0777,uid=1003,gid=1003 //myshare/oracletmp /rman/backup/prod/

Just some more info. The 'winorcl' user has full RWX privs on the share. The uid and gid are for 'oracle' and 'oinstall' which in this case are the same.

Thank you.

mseberg

Hello;

Its worth checking the parameter "filesystemio_options"

http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams083.htm

If its currently set to 'setall' try setting it to 'asynch'.

Then retry.

Best Regards

mseberg

861120

Please check the note:

Mount Options for Oracle files when used with NFS on NAS devices [ID 359515.1]


Is need mount the NFS using the correct options.

For example, using non-RAC and Linux x64 for Oracle Datafile (and RMAN) is need mount using the following options:

rw,bg,hard,rsize=32768,wsize=32768,vers=3,nointr,timeo=600,tcp

441858

Thank you. I am aware of that note and I already tried those mount options. RMAN still cannot write to the share.

441858

I will try this. Since it is a static parameter I will have to find a time when I can bounce the database.

Thanks

Victor Armbrust

Hello Experts

Excellent quote by Flavio Soares. That MOS Note clarify that question.

I had this problem a lot and I always use the MOS note [ID 359515.1]

I suggest you to change the event for the instance you want to backup to:

try:
event="10298 trace name context forever, level 32"


Victor

861120

Ok ... put here your experiences. We are waiting for the results.

861120

Thanks Vitor from Brazil : )

Victor Armbrust

hehehehhee.. Ok Golden Gate Expert.. ACS boy lol...

Levi Pereira

Hi,

ORA-19504: failed to create file "/rman/backup/prod/ctrl_file.bckp"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 22: Invalid argument

mount -t cifs -o  .... 

Is use of CIFS Protocol for RMAN backups supported? [ID 444809.1]
CIFS is fine for RMAN files: backup pieces, datafile copies, archived logs but it is NOT certified by Oracle.
Oracle Support: If there are any problems involved in using RMAN and CIFS, then we cannot get the RDBMS development involved.

Write To CIFS Filesystem on Linux Fails ( ORA-01119, ORA-27040 ) [ID 1417168.1]

Regards,
Levi Pereira

user476243

a