RE: Why I don't like RMAN repositories

From: Dustin Hayden <DHayden_at_sprich.com>
Date: Mon, 9 Dec 2013 12:53:12 +0000
Message-ID: <ED8913458C966249856499C923CE5C8BE83FFA43_at_prd-dag-01.ad.sprich.com>

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

Received on Mon Dec 09 2013 - 13:53:12 CET