Re: ORACLE data block corrupted

"Neil Cudd" <neil_at_cudd.demon.co.uk> wrote in message news:986210397.1754.0.nnrp-07.c2de6f3d_at_news.demon.co.uk...
>
> "Howard J. Rogers" <howardjr_at_www.com> wrote in message
> news:3ac841d8_at_news.iprimus.com.au...
> >
> > "Dino Hsu" <dino1_at_ms1.hinet.net> wrote in message
> > news:74ofctkitftdbhnqhpfonk17eikradlm1i_at_4ax.com...
> > > On Sat, 31 Mar 2001 14:42:39 +0200, "Sybrand Bakker"
> > > <postbus_at_sybrandb.demon.nl> wrote:
> > >
> > > >

 [Snip]
> > I never think of export really as backing up the database -you certainly
> > can't recover all your data using it. It's a relatively cheap and good
 way
> > of recovering from the dropping of objects without the hassle of an
> > incomplete recovery, but it shouldn't be your primary backup technique
 if
> > recovering all data is a requirement.
> >
> > As for 'backup with verify', there are a couple of approaches. If you
 use
> > Recovery Manager (which also allows control over what datafiles get
 backed
> > up, and can do backups whilst the database is up and running), then the
> > verification is implicit -if rman encounters block corruption, you'll
 know
> > all about it pretty quickly!
> >
> > If you are doing old-fashion backups using operating system commands,
 then
> > there is a utility, dbverify, which can be run against all the backup
 copies
> > of the datafiles, and that will show up any corruption very quickly too.
> > The unix command to run the utility is 'dbv'. I imagine in NT version
 8,
 it
> > was probably 'dbv80'. (It can also be used on datafiles which are in
 use).
> >
> > Haven't a clue about ArcServe, I'm afraid. Never used it.
> >
> > Regards
> > HJR
>
> I believe the database must be closed when running verifies on an NT
> database. dbv works on open files on Unix.
>
> Regards,
>
> Neil.
>

That's highly likely, actually -and hence the "it can also be used..." would be wrong on NT (though I've actually never tested that. but will this afternoon). What's more useful on either platform is to run it against the 'dead' backups of the data files -that way, even on NT, the database doesn't need to be closed at all.

Thanks for the correction, Neil.

Regards
HJR
>
>
Received on Mon Apr 02 2001 - 15:49:10 CDT