RMAN backup fails - unable to open file
- From: Joel Slowik <jslowik@xxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Jun 2012 20:16:26 +0000
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
