Re: RMAN: restoring autobackup spfile and controlfile

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: jkstill@xxxxxxxxx
  • Date: Thu, 2 Aug 2007 16:20:01 +0100

On 8/1/07, Jared Still <jkstill@xxxxxxxxx> wrote:
> On 8/1/07, Alex Gorbachev <ag@xxxxxxxxxxxx> wrote:
> > Good hint. Thanks Brandon.
> >
> > What's my concern is that without using RMAN catalog, it would be able
> > to scan available pieces from Netbackup (or whatever is the storage
> > manager) and find the required piece.
> >
> >
>
> There are many reasons to use a recovery catalog.

The only - but rather good in principle - reason that I can see is to
make reporting easier and consistent.

> All of our databases are being backed using a recovery catalog.
>
> bplist can be used to find the autobackup files from NetBackup, with
> the added bonus of getting the DBID for the database.
>
> Using a recovery catalog makes most RMAN tasks simpler.

I don't really see how? Most RMAN tasks have exactly the same syntax
whether  connected to a catalog or not.

> Oracle docs claim that everything possible with a recovery catalog is
> also possible using only the controlfile.  There is a long list of caveats
> to go with that statement.

For example? Most tasks (with the exception of things like recovery
through resetlogs which really ought to be pretty rare) are just as
possible without a catalog.


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
//www.freelists.org/webpage/oracle-l


Other related posts: