Re: Why I don't like RMAN repositories

  • From: Paresh Yadav <yparesh@xxxxxxxxx>
  • To: oracle@xxxxxxxxxxx
  • Date: Sat, 7 Dec 2013 22:44:52 -0500

@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@xxxxxxxxxxx> wrote:

> On Fri, Dec 6, 2013 at 1:55 PM, Jared Still<jkstill@xxxxxxxxx>  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@xxxxxxxxxxx
> 403 399 2442
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: