Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Backing up RMAN catalog database

RE: Backing up RMAN catalog database

From: <>
Date: Wed, 7 Feb 2007 12:59:47 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08B00@EXCNYSM0A1AJ.nysemail.nyenet>


I'm remembering old documentation. I'm sure now that with 10g where they are suggesting that an Rman catalog is no longer needed that there are better ways to do this.

The second Rman catalog can use the 1st Rman catalog for it's backup purposes.

All I said was that the 2nd Rman catalog is used only for the Rman database.

There are a lot of ways to skin an Oracle cat around here. Pick your preferred method.


This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

-----Original Message-----

From: Allen, Brandon [] Sent: Wednesday, February 07, 2007 12:25 PM To: Mercadante, Thomas F (LABOR);;
Subject: RE: Backing up RMAN catalog database

Tom, where have you seen a 2nd rman catalog suggested by Oracle? That seems like overkill to me, plus then what would you do to backup your 2nd rman catalog - use a 3rd catalog, and then a 4th for that one and so on?

The documentation I've seen suggests to use the recovery catalog database's control file as the rman repository instead. The below link even says specfically "Do not use another recovery catalog as the repository for the backups.": atdb006.htm


-----Original Message-----

[] On Behalf Of Mercadante, Thomas F (LABOR) The traditional (Oracle suggested) way is to have a second Rman catalog on a different database server. This catalog is used by the first Rman database.

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.
-- Received on Wed Feb 07 2007 - 11:59:47 CST

Original text of this message