RE: Why I don't like RMAN repositories
- From: Dustin Hayden <DHayden@xxxxxxxxxx>
- To: "oracle@xxxxxxxxxxxxxxx" <oracle@xxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 9 Dec 2013 12:53:12 +0000
So what it if ages out you can always just re-catalog it and then restore.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Norman Dunbar
Sent: Sunday, December 08, 2013 11:31 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
