corrupted data block recovery

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

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

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.

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.