RE: Backing up the recovery catalog

Both, export and RMAN backup. We do not use a recovery catalog for the catalog backup though, just the controlfile method.  

Just talking about it with someone else though and I think we might move to setting up another catalog and using that for the 3 RMAN repositories we have (dev, prod and 10G).  

We also have multiple schemas in each catalog and just create a new schema rather than housekeeping old entries off. We find that much more efficient than trying to purge old entries when the catalogs are very busy most of the time.  

John    

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Allen, Brandon Sent: 26 June 2006 18:02
To: oracle-l_at_freelists.org
Subject: Backing up the recovery catalog  

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