Re: Searching for block corruptions

A copy of this was sent to "Neil Cudd" <neil_at_cudd.demon.co.uk> (if that email address didn't require changing) On Thu, 23 Sep 1999 16:25:32 +0100, you wrote:

>My customer's getting a little nervous about data block corruptions since we
>were advised that there is a potential problem with our os level/Oracle
>level combination (IBM AIX 4.3.1 - Oracle 8.0.5.1.0).
>
>My question is : What is the best way to search for block level corruption ?
>
>I'm currently doing a full export (just dumping the output to /dev/null).
>The export completes without warnings. Does this mean Oracle has read and
>verified every block (at least the used ones) ?
>

its pretty good since it finds logical (data dictionary) as well as physical (block related) errors. I like to use it as part of the validation process (except I keep my exports around for that occasional "woops -- dropped the wrong table")

dbv -- is another tool. best used against OFFLINE datafiles. export won't check indexes -- it only reads the index def out of the DD, it full scans the tables. dbv will get all blocks.

analyze table|index validate ... is another way (but limits access to the object)

>any help appreciated.
>
>Regards,
>
>neil.
>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Sep 23 1999 - 16:45:46 CDT