Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN catalogs

RE: RMAN catalogs

From: Ken Naim <>
Date: Wed, 29 Nov 2006 11:45:42 -0500
Message-ID: <005001c713d5$d11a1de0$0300a8c0@KenHome>

I backup rman via a simple hot backup script and a full datapump export immediately after backing up all my primary databases, and since the catalog database is tiny both of them complete in a matter of seconds. Both are useful for different reasons, your hot backup file incase of a physical failure and the export incase someone messes up the catalog or as a poor mans source control, you can just drop the schema and import it and it works like a charm.  

I spoke with oracle support about this a while back, they recommend the export but I do both and have used both in the past.  

I never bring down the catalog unless I need to, for upgrades or server issues primarily. 10g can backup oracle version 8.1.7+ if I am not mistaken an the only restriction is that the catalog (schema) must be of the highest version you are backing up, in your case you must have a 10gR2 catalog but the catalog database can be any version you want. You always backup with the client of the same version that the database is running.  


From: [] On Behalf Of Kline.Michael
Sent: Wednesday, November 29, 2006 11:32 AM To:
Subject: RMAN catalogs  

We're doing some planning for getting RMAN catalogs into a RMAN database, small, fast, and compact so it can be exported frequently.  

What "real world" solutions work well for backing that catalog up should the catalog server go down or what ever?  

Also, we have a lot of 10.2 and 9.2. Can 10G be used to back EVERYTHING up, and if there are "restrictions" what might they be?  

Just looking for a direction. I've ordered Robert's new book, but it will probably be a while.  


Michael Kline
Database Administration
SunTrust Banks, Inc.
Mail Code TOC-7505
1030 Wilmer Avenue
Richmond, Va. 23227
Tel: 804.261.9446 Net: 643.9446
Cell: 804.744.1545

Seeing beyond Money(sm)         

The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.  

SunTrust and Seeing beyond money are federally registered service marks of SunTrust Banks, Inc.

Received on Wed Nov 29 2006 - 10:45:42 CST

Original text of this message