Searching for block corruptions

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Thu, 23 Sep 1999 16:25:32 +0100
Message-ID: <938100059.7017.0.nnrp-14.c2de6f3d@news.demon.co.uk>

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) ?

any help appreciated.

Regards,

neil. Received on Thu Sep 23 1999 - 10:25:32 CDT