Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN: restoring autobackup spfile and controlfile
What if catalog becomes unavailable for whatever reason? All backups
starting to fail or you fallback to no catalog and later, when it
becomes available, resync it with controlfiles?
What about restore when catalog is unavailable? Do you back it up as export with every backup?
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.
>
> 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.
>
> 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.
>
>
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
-- Alex Gorbachev, Oracle DBA Brewer, The Pythian Group http://www.pythian.com/blogs/author/alex http://www.oracloid.com BAAG party - www.BattleAgainstAnyGuess.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 02 2007 - 08:48:42 CDT
![]() |
![]() |