Re: Why I don't like RMAN repositories
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: oracle@xxxxxxxxxxxxxxx
- Date: Tue, 10 Dec 2013 17:13:16 -0500
This is a good thread. What I don't like about catalogs is that your
production backups may rely on some other database to be up for the
duration of the backup.
However, there are some other nice benefits to them apart from
recoverability. To answer questions like, how long do my backups
take?How long did they take 6 months ago? Are we generating more redo
then before? When did the #$@!# backup schedule change? Stuff like
that which can be nice sometimes.
Andy
On Tue, Dec 10, 2013 at 4:42 PM, Norman Dunbar <oracle@xxxxxxxxxxxxxxx> wrote:
> Hey Rich,
>
> Just wondering. Given that you have "all" that work to do recatalogging when
> you have to do a restore and recovery, that's what you would be doing if
> your catalog was a SPOF and was lost, surely?
>
> I know you'd have some details in the control file, and could recatalog the
> remainder, but i would tend to disagree that the catalog is actually a SPOF.
>
> Your mileage, as they say, may vary.
>
> I hadn't used a catalog until recently, but I can see how useful one can be,
> in addition to whatever is stored away in the control files. But I obviously
> cannot speak for everyone.
>
> Cheers,
> Norm.
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
