Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database not getting up

hariharan.thyagarajanDec 27 2008 — edited Dec 27 2008

when i tried to start the database it's not getting up throws the error given below:

ERROR at line 1:
ORA-01115: IO error reading block from file 2 (block # 57)
ORA-01110: data file 2: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF'
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 23) Data error (cyclic redundancy check).

I checked the file using dbverify
but resulted in some errors i am checkin on this
pls find the results of dbverify below:

DBV-00102: File I/O error on FILE (D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS
01.DBF) during verification read operation (-2)

Have u cam e acroos this situation

i am sure this is block corruption and the database get's mounted not able to open...

Pls help me

Thanks in anticipation

Hariharan.T

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 24 2009

Added on Dec 27 2008

#general-database-discussions

3 comments

546 views