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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN: restoring autobackup spfile and controlfile

Re: RMAN: restoring autobackup spfile and controlfile

From: Alex Gorbachev <ag_at_oracloid.com>
Date: Thu, 2 Aug 2007 09:48:42 -0400
Message-ID: <c2213f680708020648j170ed646g5a7eec6ff7182c4f@mail.gmail.com>


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-l
Received on Thu Aug 02 2007 - 08:48:42 CDT

Original text of this message

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