We had the same problem with BackupExec. The problem is that your SA needs
to EXCLUDE ALL ACTIVE ORACLE DB FILES from backup! The philosophy of
filesystems on Winders is far from multi-user. All the backup programs I've
seen in Winders (granted, that's not many) put LOCKS on files when backing
them up! Oracle doesn't like this much, especially during a checkpoint.
Anyway, the backup software doesn't need to touch the live DB files anyway,
as it does not guarantee that they will be restorable. Choose hot backups,
cold backups, export, etc. instead.
HTH! Good luck! :)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-----Original Message-----
Sent: Monday, February 25, 2002 12:41 PM
To: Multiple recipients of list ORACLE-L
I used to have similar problems with Arcserve.
Best,
Sergey
-----Original Message-----
Sent: Monday, February 25, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
I'll bet you a case of Virtual Beer that it's your backup software.
Most likely you are using Arcserve, correct?
It's misconfigured and/or broken, and definately not the best
backup solution around.
Jared
"Shibu" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/22/02 10:18 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: ORA-27072
Hi all..........
My database is going down frequently showing this error in alertfile .
This is happening to different datafiles and controlfiles.
What are the possibilities that cause this error ? How can i avoid this
error ?
oracle 8.1.7 in win2k
Errors in file C:\oracle\admin\acusis\bdump\acusisCKPT.TRC:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'D:\ORADATA\CONTROL01.CTL'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another
process has locked a portion of the file.
regards,
shibu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
