Re: Why I don't like RMAN repositories

From: Paresh Yadav <yparesh_at_gmail.com>
Date: Sat, 7 Dec 2013 22:44:52 -0500
Message-ID: <CAPXEL0+H8_6CqELeKC+FYua9iK8m-ST4YOizHwc2HF_m7H2ZLw_at_mail.gmail.com>

_at_Dave,
I agree with part of what you have said. RMAN repository does add bit of additional maintenance work but benefits far outweigh cost.

If you use repository during backups (I believe) a copy of the rman history data is still kept in the control file upto the limit set for control file history retention limits. In case of a disaster you don't have to use repository to recover unless the rman history data you need for the recovery is is aged out of control file. And if you do find that the rman history data you need is NOT in the controlfile, won't you be glad that you have the repository (after you have recovered the repository)? With the repository you can have have your cake and eat it too!

Thanks
Paresh
416-688-1003

On Sat, Dec 7, 2013 at 10:03 PM, Dave Morgan <oracle_at_1001111.com> wrote:

> On Fri, Dec 6, 2013 at 1:55 PM, Jared Still<jkstill_at_gmail.com> wrote:
>
> Why don't you use a repository?
>> If it is in your power create on, there's not really a good reason to not
>> have one.
>>
>
> 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.
>
> Having said that, when there are a large number of production databases, a
> repository does make life simpler.
>
> YMMV
> Dave
>
> Dave Morgan
> Senior Consultant, 1001111 Alberta Limited
> dave.morgan_at_1001111.com
> 403 399 2442
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Sun Dec 08 2013 - 04:44:52 CET