Urgent Datafile error

[marist89]

http://metalink.oracle.com/metalink/...1&blackframe=0

[dba_akram]

Can anyone suggest how to identify the corrupted database blocks? what are the tables/views associated in writing the queries to disclude the corrupted database blocks?????

[marist89]

Originally posted by marist89
http://metalink.oracle.com/metalink/...1&blackframe=0

[dba_akram]

The same error has cropped up now again. Earleir it was in production and now it has even cascaded to development server. Marist, when I click your link it asks me for a username and password. I do not have a metalink support. Can any one of you help me with this. Any help is greatly appreciated. The following is the error now:
ORA-01115: IO error reading block from file 5 (block # 524297)
ORA-01110: data file 5: '/DISK02/oradata/cmt10/data/cmt_data01.dbf'
ORA-27072: skgfdisp: I/O error
SVR4 Error: 25: Inappropriate ioctl for device
Additional information: 524265
when I ran the query select count(*) from validated_mcn_detail;
The earlier error and this are the same except that their block ids are different. But the number of blocks which are affected look to be the same. Please suggest.

[dba_akram]

Moderators,
Can anyone of you throw some light on my issue. Any response is truly appreciated.

[marist89]

http://otn.oracle.com/docs/products/...repair.htm#208

[wmccormick]

Did you just upgrade to 8.1.7 or run any large procedures to populate data? Is the amount of blocks that are corrupt high? What did the dbv utility report on all of your datafiles?

[dba_akram]

The version of oracle is 8.0.5 I am really not sure if there is a bug with this version of oracle when the datafile size is over 2gb. It shows the message whatever I have posted earlier.

[dba_akram]

Hi All,
Thanks a lot to each one of you who responded and viewed this thread. The problem looks to be solved for now. I just ran the analyze statement and that fixed my corruption i guess. After this ran successfully, Iam able to query all my rows.
Thanks a bunch to all.