Re: RMAN: restoring autobackup spfile and controlfile

On 8/1/07, Jared Still <jkstill_at_gmail.com> wrote:
> On 8/1/07, Alex Gorbachev <ag_at_oracloid.com> 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
--
http://www.freelists.org/webpage/oracle-l