Re: Why I don't like RMAN repositories

 > 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