Re: Why I don't like RMAN repositories
From: Justin Mungal <justin_at_n0de.ws>
Date: Sun, 8 Dec 2013 13:12:22 -0600
Message-ID: <CAO9=aUwpu8p-Omd_drqESeOhgotwSrw5xt8jXCw+h1e85Cc85A_at_mail.gmail.com>
> A repository adds complexity and an unnecessary dependence. In a disaster
Date: Sun, 8 Dec 2013 13:12:22 -0600
Message-ID: <CAO9=aUwpu8p-Omd_drqESeOhgotwSrw5xt8jXCw+h1e85Cc85A_at_mail.gmail.com>
> 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.
Well, it is another database to manage. I don't see how it adds an unnecessary dependence though.
Overall, recovery catalogs are worth the extra effort and can be life savers. It's not likely that you'd lose all of your control files, but if you ever do, it's good to have another place where your recovery information resides. The history limits of a control file are also a significant weakness of not using a recovery catalog.
-Justin
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Dec 08 2013 - 20:12:22 CET