Re: RMAN question about losing Catalog repository

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Wed, 27 Jan 2010 19:51:38 -0200
Message-ID: <172762181001271351o7d2082aao5b9014d939958251_at_mail.gmail.com>

For Disaster Recovery we USUALLY restore the RMAN catalog. It is not *required* but certainly makes the job a lot simpler. First of all, you don't actually need to know where the controlfile is backed up, which really helps if you don't have a controlfile autobackup or sensible logs...

However, if you manage to recover the controlfile (and I mean recover and not RECREATE from trace) then you have the information of at least the latest backup (how far back depends on the controfile record keep time parameter).

HTH
Alan.-

On Wed, Jan 27, 2010 at 7:15 PM, Satterthwaite, Sarah < Sarah.Satterthwaite_at_fiserv.com> wrote:

> My understanding is that you need to have an autobackup of the
> controlfile in order to restore the controlfile without a catalog. So make
> sure that you have autobackup turned on for that case where you loose your
> RMan catalog.
>
> Sarah
> _______________________________
> *
>
> Sarah Satterthwaite
> *Database Administrator
> Case-Shiller*
>
> Fiserv
> *
> Fax: 617-498-0959
> *www.fiserv.com* <http://www.fiserv.com/>
>
> 
> Please consider the environment before printing this e-mail
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 27 2010 - 15:51:38 CST