Find corrupted objects in Oracle using sql query :

When you find block corruption in your database use validate database or validate check logical database command of RMAN, it will populate v$database_block_corruption view with corrupted blocks.

Then you can check corrupted segments , its partition name and more details using following script.

 

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.