Oracle Database Discussions

Hi all..

I have a strange incident where the db instance always crash because of the I/O Error. Am not sure how this I/O Error occurred in the first place. How can I tell whether it is a hardware device error or is it oracle log access error. I am using SAN disk storage (RAID5) and Oracle 11.2.0.4 for reporting purposes using BO tools.

I understand that Oracle 11.2.0.2 have the hidden parameter that set the default value=TRUE anytime instance having a write error.

Can I simply change back the parameter to FALSE. Is there any big impact.

Below is the error file:

• KCF: read, write or open error, block=0x238 online=1

          file=3 'E:\ORADATA\DATAFILE\BOREPO\UNDOTBS01.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.'

  Encountered write error

  DDE rules only execution for: ORA 1110

  ----- START Event Driven Actions Dump ----

  ---- END Event Driven Actions Dump ----

  ----- START DDE Actions Dump -----

  Executing SYNC actions

  ----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----

  Successfully dispatched

  ----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----

  Executing ASYNC actions

  ----- END DDE Actions Dump (total 0 csec) -----

  error 63999 detected in background process

  ORA-63999: data file suffered media failure

  ORA-01114: IO error writing block to file 3 (block # 568)

  ORA-01110: data file 3: 'E:\ORADATA\DATAFILE\BOREPO\UNDOTBS01.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.

  kjzduptcctx: Notifying DIAG for crash event