RE: Backing up RMAN catalog database

  • From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 8 Feb 2007 10:27:28 -0500

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.

-- Mark D Powell --
Phone (313) 592-5148

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Fred Smith
Sent: Thursday, February 08, 2007 9:28 AM
To: Brandon.Allen@xxxxxxxxxxx; Thomas.Mercadante@xxxxxxxxxxxxxxxxx;
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" <Brandon.Allen@xxxxxxxxxxx>
>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-----
>From: oracle-l-bounce@xxxxxxxxxxxxx
>[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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



Other related posts: