1 Attachment(s)
An headache Question: ORA-01114 at DB startup
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 ?)
Re: An headache Question: ORA-01114 at DB startup
Quote:
Originally posted by ligang
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 ?)
It is tru that the log_buffer > 1 MB will not be of any use but this doesn't apply to redo log file size. Your redo log file can be of any size depending on the transactions. If I am not wrong Orcle recommends a log switch every 20-30 minutes.
What is of 10MB size? log_buffer or your redo log files? BTW Log_buffer size doesn't impact log switch frequency.
HTH
Sanjay
Re: Re: An headache Question: ORA-01114 at DB startup
Quote:
Originally posted by SANJAY_G
If I am not wrong Orcle recommends a log switch every 20-30 minutes.
What is of 10MB size?
There are different opinions on this: if i have 3 redo log groups which is on different HD, one of them is on shared directory, what for I have to care about log switch interval (20-30 min) ?
I have redo log size 25Mb and it switches several times a day, interval depends on Server load.