Re: Why I don't like RMAN repositories
- From: Jay Hostetter <hostetter.jay@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, oracle@xxxxxxxxxxx
- Date: Mon, 9 Dec 2013 09:25:02 -0500
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@xxxxxxxxxx> wrote:
> 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:
