The Nonarchived Oracle8.0.5 database on NT is not startup automatically in the morning , in the alert log :
............
alter database "prod" open
Picked broadcast on commit scheme to generate SCNs
Fri Nov 15 08:31:55 2002
Errors in file c:\orant\rdbms80\trace\prodLGWR.TRC:
ORA-01110: data file 9: 'D:\PRODDB\GLOVIA\PROD2A.DBF'
ORA-01114: IO error writing block to file 9 (block # 1)
ORA-27072: skgfdisp: I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 5) Access is denied.
............
Then I startup mount db and issue recover database command, it is Ok and the database can be opened .
This is the second time I face this kind of error . I am thinking there must be some specific reason related with this error .
Gurus : Could you please help to visualize the possbilities to trigger this error . I attach the recent records in alert log . There are some oracle error number and I can see the log switch is quite often .
BTW , I always have question on the log_buffer and redo_log setting .
Based on the official docu. these 2 values should not be set to bigger > 1M , But actually the values in my db is more than 10MB , (But I still see a lot of log switch ?)
Reply With Quote