Re: Why I don't like RMAN repositories
Date: Tue, 10 Dec 2013 17:13:16 -0500
Message-ID: <CADo_RaN5xkGWG+TCQmc81MpvOEPanwMjo-4Lhovwzcuk8EiynQ_at_mail.gmail.com>
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 #$_at_!# backup schedule change? Stuff like that which can be nice sometimes.
Andy
On Tue, Dec 10, 2013 at 4:42 PM, Norman Dunbar <oracle_at_dunbar-it.co.uk> 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.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 10 2013 - 23:13:16 CET