Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

RMAN backup unable to write to share

441858Dec 7 2012 — edited Dec 11 2012
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.

Comments

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
1 person found this helpful
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
1 person found this helpful
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
1 person found this helpful
user476243
a
441858
Hi mseberg,

I changed the parameter to 'asynch' and it worked.

I can now write backup files to the share. However, will this also take care of reading from the share i.e. restoring a backup?

Thanks for your help.
441858
Before I go with it, I would like to make sure that I can restore from it too.
1 - 12
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 8 2013
Added on Dec 7 2012
#performance-availability, #recovery-manager-rman
12 comments
12,040 views