Re: Why I don't like RMAN repositories

From: Jay Hostetter <hostetter.jay_at_gmail.com>
Date: Mon, 9 Dec 2013 09:25:02 -0500
Message-ID: <CAD7fdYu=Q+Ld0FxDT-aJRtinEaea5WLQi_WKLnotXPbVebW+nw_at_mail.gmail.com>

There are some TSPITR limitations if you are NOT using a recovery catalog. See the Backup and Recovery Users's Guide. A catalog is also required in a Dataguard environment (see note 1362501.1).

Having said that, I don't use the recovery catalog for my test/dev databases. I adjust the control_file_record_keep_time to 30 days.

Jay

On Mon, Dec 9, 2013 at 7:53 AM, Dustin Hayden <DHayden_at_sprich.com> wrote:

> So what it if ages out you can always just re-catalog it and then restore.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Norman Dunbar
> Sent: Sunday, December 08, 2013 11:31 AM
> To: oracle-l_at_freelists.org
> Subject: Re: Why I don't like RMAN repositories
>
> Hi Dave,
>
> > A repository adds complexity and an unnecessary dependence. In a
> disaster
> > I now have to recover 2 databases which requires more resources and
> > effort than recovering a single db.
> What does it add complexity? Or an unnecessary dependence? I assume you
> speak of an RMAN catalog by the way? If not, please ignore me.
>
> Given a database with a controlfile_record_keep_time of 7 days, a catalog
> will help you keep details of backups much older than the last 7 days. Your
> annual "keep this" backup, for example, will age out of the controlfile
> after a week.
>
> Yes, I know 7 days isn't a very good setting, but it could happen that
> some "junior DBA" ;-) has finger trouble and sets it this way.
>
>
> > Having said that, when there are a large number of production databases,
> a
> > repository does make life simpler.
> It can make life simpler for a single database to backup too, but it
> does depend on your needs, admittedly.
>
> I'm intrigued though, as to why you are not keen?
>
>
> Cheers,
> Norm.
>
> --
> Norman Dunbar
> Dunbar IT Consultants Ltd
>
> Registered address:
> 27a Lidget Hill
> Pudsey
> West Yorkshire
> United Kingdom
> LS28 7LG
>
> Company Number: 05132767
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Mon Dec 09 2013 - 15:25:02 CET