Hi there,
I run an Oracle 8.1.7.4 database in archive log mode on a windows 2000 server. I backup the oracle database (cold) on tape every night using arcserve 2000.
Now for some reason about once a week. A oracle datafile locks and gets corrupted. This can happen at any time of day and is usually the system.dbf.
I have configured arcserve never to lock a file. So I do not think that it is arcserve.
I have configurted the antivirus to not scan the folders where the datafiles are kept.
*** 2004-02-08 03:30:03.652
*** SESSION ID2.1) 2004-02-08 03:30:03.558
KCF: write/open error block=0x123 online=1
file=1 D:\ORACLE\ORADATA\****\SYSTEM01.DBF
error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.'
error 1242 detected in background process
ORA-01242: data file suffered media failure: database in ARCHIVELOG mode
ORA-01114: IO error writing block to file 1 (block # 291)
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\****\SYSTEM01.DBF'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.
Can anyone tell me why it is doing this?
The error message tends to imply that something was scanning the dbf when it was written to.
This problem has been going on for about 4 weeks now and I would really appreaciate any help on it.
many thanks
Eddy
I run an Oracle 8.1.7.4 database in archive log mode on a windows 2000 server. I backup the oracle database (cold) on tape every night using arcserve 2000.
Now for some reason about once a week. A oracle datafile locks and gets corrupted. This can happen at any time of day and is usually the system.dbf.
I have configured arcserve never to lock a file. So I do not think that it is arcserve.
I have configurted the antivirus to not scan the folders where the datafiles are kept.
*** 2004-02-08 03:30:03.652
*** SESSION ID2.1) 2004-02-08 03:30:03.558
KCF: write/open error block=0x123 online=1
file=1 D:\ORACLE\ORADATA\****\SYSTEM01.DBF
error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.'
error 1242 detected in background process
ORA-01242: data file suffered media failure: database in ARCHIVELOG mode
ORA-01114: IO error writing block to file 1 (block # 291)
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\****\SYSTEM01.DBF'
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.
Can anyone tell me why it is doing this?
The error message tends to imply that something was scanning the dbf when it was written to.
This problem has been going on for about 4 weeks now and I would really appreaciate any help on it.
many thanks
Eddy