From: Aaron <asentell@my-deja.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Check for database corruption?
Date: Tue, 12 Dec 2000 18:31:25 GMT
Organization: Deja.com
Lines: 50
Message-ID: <915qtt$qo1$1@nnrp1.deja.com>
References: <90rjtm$6pc$1@nnrp1.deja.com> <90rpui$bnk$1@nnrp1.deja.com>
NNTP-Posting-Host: 164.50.248.200
X-Article-Creation-Date: Tue Dec 12 18:31:25 2000 GMT
X-Http-User-Agent: Mozilla/4.75 [en] (WinNT; U)
X-Http-Proxy: 1.0 proxy.tempe.gov:8080 (Squid/2.2.STABLE5), 1.0 x56.deja.com:80 (Squid/1.1.22) for client unknown, 164.50.248.200
X-MyDeja-Info: XMYDJUIDasentell


Yes, export does check for data block corruption in the tables.  The
indexes, however, are not included in this check.  Since we
already check the tables on a regular basis via the full exports,
perhaps we will look into implementing a routine to check the indexes on
a regular basis, using "analyze index...validate structure" so that all
our bases are covered.  Or perhaps we'll determine it's overkill.

In article <90rpui$bnk$1@nnrp1.deja.com>,
  jdarrah_co@my-deja.com wrote:
> If you preform a full export every night and you don't use the
 direct=y
> option, you are already doing your consistancy check.  Also, if using
> RMAN, you can use the check logical clause.  I like to lean on the
 side
> of paranioa when it comes to corruption.
>
> In article <90rjtm$6pc$1@nnrp1.deja.com>,
>   Aaron <asentell@my-deja.com> wrote:
> > I'm fairly new to Oracle but not to database administration.  As a
> > Sybase DBA, I made sure that I ran a database consistency check on
 all
> > my production databases at least once a week.  From what I've read
 and
> > seen thus far, however, this same level of precaution is not
 necessarily
> > required for Oracle, although I'm quite sure this is not Oracle's
> > official position.
> >
> > I want to get some input from DBAs who are out there in the trenches
 and
> > have experience with this.  Is it worth the time to run "analyze
> > table...verify structure cascade" on a regular basis in production
> > databases?  Note that we perform a full export every night in
 addition
> > to database backups.
> >
> > Thank you,
> > Aaron
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>


Sent via Deja.com
http://www.deja.com/