Oracle Database Discussions

Hi,

we are facing some weird problem with one of our Oracle database where oracle instance is getting terminated very frequently. below are the alert logs. Kindly suggest what could be the issue & how to resolve it.

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

This is an IBM X series server & we have get hardware checked from vednor who have not found anything wrong with hardware (HDD).

Sat Aug 25 08:00:34 2012
KCF: read, write or open error, block=0xfba4 online=1
file=2 'J:\ORACLE\DB1\DB1\SYSAUX01.DBF'
error=27070 txt: 'OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.'
Errors in file J:\ORACLE\DB1\diag\rdbms\DB1\DB1\trace\DB1_dbw0_7012.trc:
ORA-63999: data file suffered media failure
ORA-01114: IO error writing block to file 2 (block # 64420)
ORA-01110: data file 2: 'J:\ORACLE\DB1\DB1\SYSAUX01.DBF'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 1117) The request could not be performed because of an I/O device error.
Sat Aug 25 08:00:35 2012
Errors in file J:\ORACLE\DB1\diag\rdbms\DB1\DB1\trace\DB1_m000_5168.trc:
ORA-00322: log 3 of thread 1 is not current copy
ORA-00312: online log 3 thread 1: 'H:\ORACLE\DB1\ORIGLOG3\LOG_G3_M1.DBF'
Sat Aug 25 08:00:35 2012
System state dump requested by (instance=1, osid=7012 (DBW0)), summary=[abnormal instance termination].
System State dumped to trace file J:\ORACLE\DB1\diag\rdbms\DB1\DB1\trace\DB1_diag_6996.trc
DBW0 (ospid: 7012): terminating the instance due to error 63999
Dumping diagnostic data in directory=[cdmp_20120825080035], requested by (instance=1, osid=7012 (DBW0)), summary=[abnormal instance termination].
Sat Aug 25 08:00:49 2012
Exception [type: IN_PAGE_ERROR, ] [] [PC:0x76E59C12, 0000000076E59C12]
ERROR: Unable to normalize symbol name for the following short stack (at offset 213):
dbgexProcessError()+200<-dbgeExecuteForError()+65<-dbgDB1stErrorKGE()+2235<-dbkDB1stKGE_kgsf()+77<-kgeade()+563<-kgerelv()+151<-kgerev()+45<-kgerec5()+60<-sss_xcpt_EvalFilterEx()+1869<-sss_xcpt_EvalFilter()+174<-.1.4_5+59<-0000000076E485A8<-0000000076E59D0D<-0000000076E491AF<-0000000076E81278<-0000000076E59C12<-0000000076E48F14<-0000000076E81278<-0000000076E59C12<-0000000076E48F14<-0000000076E81278<-0000000076E59C12<-0000000076E48F14<-0000000076E81278<-0000000076E59C12<-0000000076E48F14<-0000000076E81278<-0000000076E59C12<-0000000076E48F14<-0000000076E81278<-0000000076E59C12<-0000000076E48F14<-0000000076E81278<-0000000076E59C12<-0000000076E48F14<-0000000076E81278<-0000000076E59C12<-0000000076E48F14<-0000000076E81278<-0000000076E59C12<-0000000076E48F14<-0000000076E81278<-0000000076E59C12<-0000000076E48F14<-0000000076E81278<-0000000076E59C12<-0000000076E48F14<-0000000076E81278<-0000000076E59C12<-0000000076E48F14
Errors in file J:\ORACLE\DB1\diag\rdbms\DB1\DB1\trace\DB1_d000_7044.trc (incident=153752):
ORA-07445: exception encountered: core dump [PC:0x76E59C12] [IN_PAGE_ERROR] [] [PC:0x76E59C12] [] []
Incident details in: J:\ORACLE\DB1\diag\rdbms\DB1\DB1\incident\incdir_153752\DB1_d000_7044_i153752.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sat Aug 25 08:00:52 2012
Instance terminated by DBW0, pid = 7012


Dhiraj

Edited by: 876613 on Aug 25, 2012 1:15 AM