Re: Why I don't like RMAN repositories
Date: Tue, 10 Dec 2013 09:09:24 -0600
Message-ID: <CAP79kiRyMA=jPQkpPHQx+NYLKgmHGOVEzTLCo8En5i4TFuqAcQ_at_mail.gmail.com>
Out of curiosity, with nightly FULL rman backups of a production database, why would you recommend a value greater than 7 for keep time?
I had a hard time imagining a scenario where you'd have to go back 21 days for a production recovery - I'm wondering if I'm missing some technical aspect here...
Thanks,
Chris
On Tue, Dec 10, 2013 at 9:03 AM, Tim Gorman <tim_at_evdbt.com> wrote:
> Coming late to the discussion, not sure if anyone else has made this
> point...
>
> Having an RMAN repository (a.k.a. recovery catalog, etc) is belt and
> suspenders (or belt and braces for many). There is always a "recovery
> catalog" in the target database's control files, so you've always got a
> belt to prevent your trousers from falling. If you don't set
> CONTROL_FILE_RECORD_KEEP_TIME to at least 21, then it's more cheap string
> than a belt, but it's a belt.
>
> A recovery catalog is a replicated copy of the recovery catalog with more
> history, thus suspenders/braces in addition to the belt.
>
> It is not technical merit, but rather personal/corporate choice, that
> determines whether one wears one or both.
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 10 2013 - 16:09:24 CET