Re: Is my database OK?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 25 Jun 2005 01:00:37 +0200
Message-ID: <014pb11eo4us57h5l3fmu204j7e850rr05@4ax.com>

On Fri, 24 Jun 2005 14:48:20 -0700, "Andreas Sheriff" <spamcontrol_at_iion.com> wrote:

>
>Use:
>ANALYZE (TABLE | INDEX | CLUSTER) table_name VALIDATE STRUCTURE; /* Etc...
>*/
>
>Oracle won't tell you there's block corruption till you try to read from
>that block.
>Do this when database activity is at a minimum because this procedure can be
>very time consuming.

The OP would obviously better use the dbverify utility instead of this cumbersome method. But I guess dbverify is not included in the OCP. Also, I never ever experienced block corruption, and I have survived quite a few crashes.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Jun 24 2005 - 18:00:37 CDT