RE: Backing up the recovery catalog

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Thu, 19 Oct 2006 16:11:32 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C45059E21D7@NT15.oneneck.corp>

I'm rehashing this old topic again since I got too busy to respond back when I originally posted my question.

I'm curious if anyone can come up with a scenario where the lack of a recovery catalog would prevent successful database recovery? Assuming that you have controlfile backups, I can't think of such a case. I'm leaning towards following the same path as Jared and phasing out the recovery catalog since it just seems like an unnecessary level of redundancy to me - especially with the added ease of controlfile autobackups in 9i+.

It seems to me that the only benefits of the recovery catalog are that it can hold more historical data (control file is limited to 365 days and 20,000 blocks), and it can hold rman scripts. So, if either of those two things are important to you, then it might make sense to have a recovery catalog but other than that it just seems more and more like a waste of resources to me.

Am I missing something?

Thanks,
Brandon

	From: Jared Still [mailto:jkstill_at_gmail.com] 
	Sent: Monday, June 26, 2006 3:40 PM
	To: Allen, Brandon
	Cc: oracle-l_at_freelists.org
	Subject: Re: Backing up the recovery catalog
	
	
	I shutdown the recovery catalog database and backup it up cold.
	
	Backing it up after every database backup seems like overkill to
me, as
	any of the databases can be recovered using the controlfile.
	
	As databases get moved and new ones added, I am not even using 
	the recovery catalog.
	
	Though I have argued for its use in the past, I haven't actually
realized
	much benefit from using it, and am phasing it out here.
	
	Jared
	
	
	
	On 6/26/06, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote: 

		Hello everyone,
		 
		I'm curious how you all are going about backing up your

recovery catalogs. Do you do it through rman backups, or logical exports, or both? I've always done it through logical exports (exp), then compressed and backed up to tape through Netbackup with bpbackup - all scripted to run very smoothly and automatically after each database backup and archive log backup. This has served me well in the past, but now I'm setting up a new server and was just reviewing this configuration and the documentation that recommends backing up the recovery catalog via rman instead, so I'm considering changing my ways but not sure if that's a good idea. Just curious what others are doing and if you have any compelling reasons for doing it one way or the other.

		Thanks,
		Brandon

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

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

Received on Thu Oct 19 2006 - 18:11:32 CDT