corrupted data block recovery

[ramimech]

hi,

I am Junior member. I have got problem of data block corruption error in one large table.

can anyone guide me that how to do the recovery?

Thanks in advance

Junior member

[buffalodba]

First off,a couple ?s...are you in archive mode? what BU method are you using, e.g. RMAN, cold, hot?

[tamilselvan]

Extracting good rows from the table is a huge process.
You must know various methods, like using ROWID (min / max) , PK etc.

The simple solution is:
Create a temp table by using CREATE TABLE aaa SELECT * from corrupted table order by PK DESC.
Then Use INSERT INTO aaa SELECT * from corrupted table order by PK ASC.

[sonofsita]

you may be helped by this:

run dbverify to fix that corruption..if it is at Oracle level that will take care of it.
after that:
create temp_x as select * from x
extract the index definitions on x or note on ehich columns you have indexes and what type. also constraints.
drop table x
rename temp_x as x and recreate the indexes.
enable constraints.