topic Re: Block corrupted in Operating System - HP-UX

Block corrupted

fabiosax — Fri, 18 Aug 2006 01:25:40 GMT

Hello there,
I got the following error message:
ORA-01578: ORACLE data block corrupted (file # 42, block # 16373) ORA-01110: data file 42: '/Oracle9i/OraHome/oradata_nas/ERIDBCQ/CQ_LTBDB2.ora'

Could you please someone help me to how to fix these corrupted block?
I tried to run the rman utility without success {blockrecover datafile 42 block 16373;} and now i'm going to user the DBMS_REPAIR..

I have Oralce9i on Solaris 9.
Thanks in advance
Fabio

Re: Block corrupted

Peter Godron — Fri, 18 Aug 2006 01:53:27 GMT

Fabio,
I am sure you have used a web search to get some information, but just in case:
http://www.quest-pipelines.com/newsletter-v4/0103_C.htm
http://www.fortunecity.com/skyscraper/oracle/699/orahtml/oramag/16tech.html
http://www.fors.com/orasupp/rdbms/dba/28814_1.HTM

Also lots of metalink entries.

Re: Block corrupted

Steven E. Protter — Fri, 18 Aug 2006 02:19:56 GMT

Shalom Fabio,

You don't really fix a corrupted block. The database tries to move/reconstruct the data elsewhere. If that fails you either have to restore the missing data or perhaps the entire database.

We've seen it happen and figured out what records were corrupt and wrote a sqlplus script to put them back from a backup.

SEP

Re: Block corrupted

fabiosax — Fri, 18 Aug 2006 04:17:49 GMT

Thanks so much for your info... really appreciated..
So i followed the instruction you sent and after i run the DBMS_REPAIR.CHECK_OBJECT and verified the corrupted block I run the FIX_CORRUPT_BLOCKS. Then I run the finding the orphan index and the result was 28.
After having found the index name trying to rebuild it i got the following error:
"ALTER INDEX SYS_IL0000036518C00039$$ REBUILD online;
ALTER INDEX SYS_IL0000036518C00039$$ REBUILD online
*
ERROR at line 1:
ORA-01418: specified index does not exist"

But it exists!!!
Any idea..? thanks so much..
The main problem is that i don't have any backup of the damage datafile, but just an early one because we had a blackout and no chance to made it.
Thanks!!!!
Fabio

Re: Block corrupted

Peter Godron — Fri, 18 Aug 2006 04:21:34 GMT

Fabio,
if it is the index that is faulty, can't you just recreate the index with drop/create?

This would not be possible with table data fault, unless you have a backup.

Re: Block corrupted

Yogeeraj_1 — Fri, 18 Aug 2006 05:53:37 GMT

hi fabio,

Based on the assumption that you identified the "faulty" object to be an idex, i would recommend the following:

1. alter index rebuild pctfree tablespace

2. Stop using the tablespace for any new objects

3. create another tablespace and move all the objects from the old tablespace to the new.

Then, try to see if there are any error messages relating to I/O or disk at the OS level.

hope this helps!

kind regards
yogeeraj

Re: Block corrupted

fabiosax — Fri, 18 Aug 2006 06:12:32 GMT

Sorry if i still bother you but just to clarify to me...
So after i marked the corrupted block as true with DBMS.REPAIR I used the DBMS_REPAIR.DUMPORPHAN_KEYS and the result is:
orphan key count: 28.
So now i wonder if exists something to mark and fix these orphan key.
Thanks in advance.
Regards,
Fabio

Re: Block corrupted

Bill Hassell — Fri, 18 Aug 2006 09:21:46 GMT

Just to be sure that the disk is OK, check /var/adm/syslog/syslog.log for disk errors. If there are erros, no amount of 'repairing' will fix the problem -- the disk is damaged and must be replaced. Use dd to check the entire disk surface as in:

dd if=/dev/rdsk/EachDISK of=/dev/null bs=256k

(replace EachDISK with the c0t0d0 name of your disks.

Re: Block corrupted

fabiosax — Thu, 24 Aug 2006 08:38:42 GMT

Hello there, just to let you know that i managed to fix the problem creating a new table asn selecting from the corrupted one using the rowid.

Thanks to everyone for your support and help.
Regards,
Fabio