RE: dbms package? - analyze table validate structure

  • From: "Crisler, Jon" <Jon.Crisler@xxxxxxx>
  • To: "Jared Still" <jkstill@xxxxxxxxx>
  • Date: Wed, 31 Dec 2008 13:10:48 -0500

We think it was because somebody was trying to resize disk volumes and
accidentally restarted the database before the resize was completed.
Frankly, I am surprised the damage was not more catastrophic, but the db
passes a RMAN file validation and RMAN block corruption check.  We
restored the RMAN backup to another system and it was fine, but as the
problem with indexes was not detected until the user had already been in
the system for 12+ hours.  Since the damage was confined to a few
corrupted indexes, I elected just to rebuild the indexes rather than
restore the db, but we do have a fall-back position if required.


The problem is that this system is, and we are not sure if the
corrupted indexes are a result of the botched SAN work, or perhaps were
an existing condition and unrelated, so I was trying to be proactive and
run a routine "validate structure" at night for the next few weeks.    I
have a SQL script that can easily do this, but I wanted to run it
unattended outside of a Windows session on the server (Oracle on Windows
Server 2003).



From: Jared Still [mailto:jkstill@xxxxxxxxx] 
Sent: Wednesday, December 31, 2008 1:02 PM
To: Crisler, Jon
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: dbms package? - analyze table validate structure


On Wed, Dec 31, 2008 at 8:37 AM, Crisler, Jon <Jon.Crisler@xxxxxxx>

        Does anybody know if there is an equivalent Oracle provided
package like
        DBMS_STATS that does the same thing as "analyze table (name)
        structure" ?  I have a system that seems to encounter corrupted
        now and then, am I want to implement a preventative process via
        to check all the tables and indexes in a particular schema.

Hi Jon,

Have you investigated why indexes are being corrupted?

I would think that to be a rather unusual circumstance.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist


Other related posts: