I use one catalog for all my databases. You have to have a catalog in a separate database if you are going to backup the catalog database using rman but that is the only time I have ever heard of using more than one catalog. I must say, most of the Oracle support analysts, at least, don't understand rman.
Regards, Ruth ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 05, 2002 12:53 PM > I have just completed Oracle Education's "Enterprise DBA Part 1B: Backup and > Recover" course. > Page 11-5 states : It is recommended that you have a separate catalog for > each database. > > My question is : > Why? Does this help you cleanup the RMAN catalog if you ever drop a > database (you can drop the schema owner)? > Is this how others have configured their RMAN database ? > > Thus I am seeing 2 Configuration Models ; > Have one schema owner per database that you are backing up. > If you had two databases "PROD and DEV" then setup a RMAN-PROD and an > RMAN-DEV schema owner (different RMAN Catalogs) in the same RMAN tablespace > to manage each database's recovery info. > VERSES > Have one schema owner (catalog) for all the databases that you are backing > up. > If you had two databases "PROD and DEV" then setup one schema owner RMAN > (one RMAN Catalog) in the RMAN tablespace to manage all database recovery > info. > > What are the pro's and con's? > > Thanks in Advance > _________________________ > Patrick J. Howe > Oracle DBA > Illuminet Inc. (Carrier Division of Verisign) > 4501 Intelco Loop SE > Email : [EMAIL PROTECTED] > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Pat Howe > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).