- Category: Database Guides & Tutorials
- Published on Monday, 04 April 2011 17:34
- Written by Rajabaskar Thangaraj
In this article we will learn how to find block corruption object name and owner.
To find the block corruption object name & owner
To find the block corruption in database.
SQL> select count(*) from v$database_block_corruption;
Return more than 0 rows go to steps 2.
Below Query is used to generate the dynamic sql statements.
set pages 200
set lines 200
set heading off
FROM dba_extents e
file_id='|| file#||' and '|| block#||' BETWEEN block_id AND block_id + blocks - 1; '
from v$database_block_corruption order by file#;
We run above "Block_corruption_list.log" files.
SQL> Spool Block_corruption_objectname.log
I Hope this article helped to you. Suggestions are welcome.
blog comments powered by Disqus