RMAN backup fails - unable to open file
From: Joel Slowik <jslowik_at_cps92.com>
Date: Tue, 26 Jun 2012 20:16:26 +0000
Message-ID: <753776E59599B1448E304186FCDD68990DCC0C5C_at_BY2PRD0710MB354.namprd07.prod.outlook.com>
Server: Windows 2000 service pack 4
Oracle database version: 10.2.0.3.0 Enterprise Edition RMAN version: 10.2.0.3.0
Database type: development
When I bounce the database this issue is resolved. But this issue continues to come back up after a day or two.
Confidentiality Note: This electronic message transmission is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you have received this transmission, but are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this information is strictly prohibited. If you have received this e-mail in error, please contact Continuum Performance Systems at {203.245.5000} and delete and destroy the original message and all copies.
Date: Tue, 26 Jun 2012 20:16:26 +0000
Message-ID: <753776E59599B1448E304186FCDD68990DCC0C5C_at_BY2PRD0710MB354.namprd07.prod.outlook.com>
Server: Windows 2000 service pack 4
Oracle database version: 10.2.0.3.0 Enterprise Edition RMAN version: 10.2.0.3.0
Database type: development
When I bounce the database this issue is resolved. But this issue continues to come back up after a day or two.
I would initially think this is due to a virus scanner or some other software like that running at the same scheduled time but the issue occurs when I run the backup manually as well.
A Process Explorer search (during and after an attempted backup or backup verify) for the data file shows 14 handles on the file, all the same oracle.exe PID. Interestingly there is no actual data from any particular schema in that data file.
I'm not seeing any other errors anywhere else that I can think of.
"
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ===========================================================RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/26/2012 15:48:04
ORA-01114: IO error writing block to file 4 (block # 1) ORA-01110: data file 4: 'D:\ORACLE\ORADATA\MPDEV1\USERS01.DBF' ORA-27091: unable to queue I/O ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.
Recovery Manager complete.
"
Any ideas?
Confidentiality Note: This electronic message transmission is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you have received this transmission, but are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this information is strictly prohibited. If you have received this e-mail in error, please contact Continuum Performance Systems at {203.245.5000} and delete and destroy the original message and all copies.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 26 2012 - 15:16:26 CDT