Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN v Control Files

Re: RMAN v Control Files

From: Gary Mandaracas <garym_at_singnet.com.sg>
Date: Tue, 18 Feb 2003 23:03:49 +0800
Message-ID: <b2tha3$o6$1@reader01.singnet.com.sg>


Thanks for the information,

It seems that, for 8i at least, a recovery catalogue is favoured over a control file where multiple databases are to be backed up.

Cheers

Gary

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:pan.2003.02.17.18.51.28.483456_at_yahoo.com.au...
> On Mon, 17 Feb 2003 14:51:20 +0000, Bill & Mary Border wrote:
>
> > These newsgroups are a know-it-all's heaven. I was simply
> > using the acronym RCVCAT for "recover catalog" duhhhhh....
> > And I was just trying to be helpful. It must be a terrible burden
> > to know everything Howard...
>
> I'm not sure why you feel the need to get unpleasant about it. You used an
> acronym that had a specific meaning in 8.0.
>
> >
> > If you do use a recovery catalog (happy now?)
>
> Happier if you'd drop the attitude, actually. Words have meanings. It
> helps to use the right words to convey accurate meaning.
>
> > you can issue
> > the RESET DATABASE TO INCARNATION N; command which for
> > us has been a BIG DEAL.
>
> Great. So you qualify as a 'complicated backup strategy' site, and a
> catalog is just what you need. I didn't say otherwise.
>
> >If you have to do multiple restores to
> > a point-in-time (without having to manually find the correct copy
> > of the controlfile) that is further back than the previous restore
> > you need this.
>
> And how widespread do you think this practice is?
>
> >As I said, we found this out the hard way before
> > switching to using all controlfiles. We do use 8i on about 600
> > databases.
> >
>
> And 600 databases alone would probably qualify as a 'complicated' enough
> to warrant a catalog. And 8i alone likewise.
>
>
Received on Tue Feb 18 2003 - 09:03:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US