| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN Configuration Question
I am fairly new to RMAN, but here is my $.02. Use a separate RMAN db for each version of db's to be backed up (e.g. rman817, rman901, ...). In each RMAN db, I would create a separate schema, same name as Oracle_SID for each db. This model makes scripting, maintenance, and upgrades simple. Now if I were running 10+ versions of Oracle, I might have 1 RMAN db of the latest version (rman901) with a sep. schema for each db.
*RMAN Newbie*
Gene
>>> phowe_at_Illuminet.com 03/05/02 12:53PM >>>
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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Howe INET: phowe_at_Illuminet.com 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: ListGuru_at_fatcity.com (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: Gene Sais INET: Gsais_at_co.palm-beach.fl.us 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: ListGuru_at_fatcity.com (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).Received on Tue Mar 05 2002 - 13:48:27 CST
 |
 |