| DB Got Shutdown [message #271400] |
Mon, 01 October 2007 09:48  |
faiz_hyd
Messages: 294
Registered: February 2006
|
Senior Member |
|
|
Hi,
Our Dev Database went down and i have to restart, This is what i found in Log File,
Errors in file /u01/app/oracle/admin/neor1l1/bdump/neor1l1_dbw0_835.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 55 (block # 7538)
ORA-01110: data file 55: '/u01/app/oracle/oradata/neor1l1/misc_data_01.dbf'
ORA-27063: skgfospo: number of bytes read/written is incorrect
SVR4 Error: 5: I/O error
Additional information: -1
Additional information: 8192
DBW0: terminating instance due to error 1242
I have checked for the space on the box and as well as for this tablespace and status of Datafile all looks fine, This happened couple of times earlier and i have to restart the DB, what else do you people can cause this.
It's Oracle 9i Rel 2, 9.2.0.5.0 on Solrais 5.9
Thanks
|
|
|
|
|
|
| Re: DB Got Shutdown [message #271456 is a reply to message #271400] |
Mon, 01 October 2007 12:49  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
Also, it could just be a plain media failure, in which case you have a problem as I see you are not in archive log mode. You will have to restore your latest backup or rebuild your DEV environment.
You might want to look in /var/adm/messages to see if there are any hard drive errors at the same time as the Oracle log file reports your error.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
