Re: consistency check

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 14 Feb 2002 20:38:42 -0000
Message-ID: <3c6d677d_3@mk-nntp-1.news.uk.worldonline.com>

Howard,

Any recommendation on dbv?

TIA.
Paul

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:1013714253.358780_at_bugstomper.ihug.com.au...
> Use RMAN to do your backups. It checks for inconsistency as it does the
> backups. If your backup succeeds, you don't have any corruption.
>
> You can always consider things like DB_BLOCK_CHECKING, too (throws errors
> into the alert log if it encounters corruption). I'd stay away from
> DB_BLOCK_CHECKSUM like the plague, if I were you: it imposes a very
> significant performance overhead. The CHECKING version is not entirely a
> freebie, either, but it's much, much less of a killer than the older
> CHECKSUM.
>
> Personally, if I was using RMAN, I wouldn't be using anything else.
>
> Regards
> HJR
> --
> ----------------------------------------------
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "Bud Socks" <bud_socks_at_gmx.net> wrote in message
> news:a4gonq$g9p$00$1_at_news.t-online.com...
> > Hi there,
> >
> > we have a 7x24h productive db environment. what would be the most
> > recommended
> > method to check block corruption ?
> >
> > Thanks
> >
> > Bud
> >
> >
> >
> >
>
>
Received on Thu Feb 14 2002 - 14:38:42 CST