RMAN-03009 and ORA-27052 Due to Opportunistic Locking
12/31/2012 12:20:00 PM
Gönderen Mete Karar
While backing up backup sets to a secondary location which was a Windows share, RMAN job failed with the following error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at sometime
ORA-27052: unable to flush file data
Linux-x86_64 Error: 5: Input/output error
When I digged up a little bit, I found the following lines in server's system log:
<host> kernel: CIFS VFS: No response to cmd 47 mid 2921
<host> kernel: CIFS VFS: Write2 ret -11, wrote 0
<host> kernel: CIFS VFS: Write2 ret -112, wrote 0
<host> kernel: CIFS VFS: Write2 ret -11, wrote 0
<host> kernel: CIFS VFS: Write2 ret -11, wrote 0
The problem was caused by optimistic locking property of CIFS module. If the file you are copying is large enough (in my case it was about 80 GB) through a CIFS channel, you may hit this problem. By default optimistic locking is set to 1 when the module is loaded. Disabling optimistic locking solves the problem with no performance drawback, at least I haven't observed.
To disable optimistic locking:
$ echo 0 > /proc/fs/cifs/OplockEnabled
10/11/17 20:10
Wow ! I have the same situation. I have applied your fix. Hope it helps.
Thanks,
10/11/17 21:33
RMAN-03009: failure of backup command on ch03 channel at 11/10/2017 13:00:48
ORA-27052: unable to flush file data
Linux-x86_64 Error: 11: Resource temporarily unavailable Additional information: 1
The solution didn't help. Anymore suggestions ? I am using CIFS.