RE: backup failure
Date: Mon, 9 Jan 2012 10:26:12 -0800
Message-ID: <34DB87F47199374280ADFD2968CDBCFA8D8516B8BD_at_MAIL01KT.seattlepacificindustries.com>
Ok, now after some more conversations about it, network admins saying that OS backup (commwalt) runs against that server, so it could be it? From: Jeffrey Beckstrom [mailto:JBECKSTROM_at_gcrta.org] Sent: Monday, January 09, 2012 9:59 AM
To: oracle-l_at_freelists.org; Eugene Pipko Subject: Re: backup failure
Do you have something performing a file system backup of the files?
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
Information Systems
1240 W. 6th Street
Cleveland, Ohio 44113
>>> Eugene Pipko <eugene.pipko_at_unionbay.com> 1/9/12 12:48 PM >>>
Hi all,
I am having spermatic (Oracle 9.2 on Win2K3) during cold backup.
I can see in the rman log file that database goes down completely, but when it comes back up it reports the error:
Errors in file d:\ora2003\app\oracle\admin\repd\bdump\repd_lgwr_3528.trc:
ORA-01110: data file 44: 'D:\ORACLE_SAN\INDEX\SALES_INDX\REPD_SALES_INDX_01.ORA' ORA-01114: IO error writing block to file 44 (block # 1) 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.
I can see that our BI application had a job scheduled at the same time against this d/b, but not sure if it can hold one of the files locked because d/base went down completely (according to the rman log file). Where else can I look?
[cid:image001.png_at_01CCCEB2.AB3DDB00]
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 09 2012 - 12:26:12 CST