Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.6K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
RMAN backup unable to write to share

441858
Member Posts: 629
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:
Is there a mount option out there that works so that RMAN can write to an NFS share?
I used the following opton:
Thank you.
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 argumentI 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.
Answers
-
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 -
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 -
Thank you. I am aware of that note and I already tried those mount options. RMAN still cannot write to the share.
-
I will try this. Since it is a static parameter I will have to find a time when I can bounce the database.
Thanks -
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 -
Ok ... put here your experiences. We are waiting for the results.
-
Thanks Vitor from Brazil : )
-
hehehehhee.. Ok Golden Gate Expert.. ACS boy lol...
-
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 -
This discussion has been closed.