RE: backup failure

  • From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, "Eugene Pipko" <eugene.pipko@xxxxxxxxxxxx>
  • Date: Mon, 09 Jan 2012 13:31:44 -0500

If the OS backup is trying to do Oracle files while Oracle is up UNLESS 
Commwalt is opening the file shared.
>>> Eugene Pipko <eugene.pipko@xxxxxxxxxxxx> 1/9/12 1:26 PM >>>

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@xxxxxxxxx] 
Sent: Monday, January 09, 2012 9:59 AM
To: oracle-l@xxxxxxxxxxxxx; 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@xxxxxxxxxxxx> 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@01CCCEB2.AB3DDB00]



--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


Other related posts: