Re: RMAN question about losing Catalog repository

  • From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
  • To: Sarah.Satterthwaite@xxxxxxxxxx
  • Date: Wed, 27 Jan 2010 19:51:38 -0200

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@xxxxxxxxxx> 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
>
>
>

Other related posts: