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: Powell, Mark D <>
Date: Thu, 8 Feb 2007 10:27:28 -0500
Message-ID: <>


I think it is telling you to use rman without a recovery catalog database to backup the recovery catalog database. The control file for the recovery catalog database will contain the recovery information. Just make sure you backup the control file as part of the backup process (,which is something you should be doing anyway).

Unless you are making use of the recovery catalog database to store scripts then in my opinion there is very little reason to use a recovery catalog with rman. Rman is capable of recovering the database using just the control file and if you lose the control file rman is capable or recovering it first and then recovering the database using a backup control file.

-----Original Message-----
[] On Behalf Of Fred Smith Sent: Thursday, February 08, 2007 9:28 AM To:;;
Subject: RE: Backing up RMAN catalog database

Thank you for the link. In it is says "When backing up the recovery catalog database, you can use RMAN to make the backups", does that mean to use the rman executable on the catalog database server and write to a tape on the master mml server? (I guess preferrably to a separate tape pool than the other backups).

>From: "Allen, Brandon" <>
>Subject: RE: Backing up RMAN catalog database
>Date: Wed, 7 Feb 2007 10:24:56 -0700
>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.":
>-----Original Message-----
>[] On Behalf Of Mercadante, Thomas
>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

>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.

Invite your Hotmail contacts to join your friends list with Windows Live Spaces / t=en-us

Received on Thu Feb 08 2007 - 09:27:28 CST

Original text of this message