How to find Block Corruption

[omegamark]

1.Will export will be able to detect block corruption ???

or

2.Analyze table validate structure will detect block corruption

If second option is the best For Very big tables (One of my table is 9GB )How to do a Ananlyze table ..for finding block corruption

3.Will RMAN backups will detect block corruption ???

Or any easy and simple method to detect block corruption

[Halo]

1. if block corruption is detected, the export will fail, dunno about 2 or 3.
2. second option, run dbv on all dbf

[tamilselvan]

RMAN updates V$BACKUP_CORRUPTION table.
You can query from this table/view for corrupted file and block.

[omegamark]

Thanks Halo and Tamil ..

This is what I read from Metalink ...


Export will read all the data and report errors at the block level and data level without obtaining any locks. However, it will not perform index/block cross checking. Only analyze table validate structure with the cascade option will do that. The best combination to detect problems would be to (analyze with validate structure cascade) and then use export.


Once In a month I just want to cross check my DB for Block corruption .

1.The physical backups is done by RMAN ...
So will v$backup_corruption will be just enough

or if need to cross check with export what is the best method ..