Re: RMAN Configuration Question

Pat

There are several reasons to have multiple catalog, but the most importen one is that gives the possibility to upgrade the catalog without interfering
with other database backup's. There is as well the benefit if you at some time is going to query the catalog using Sql you will not have to join all the time with the db key

Pat Howe wrote:

>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 : phowe_at_illuminet.com
>
>

-- 

/regards

Peter Gram

Phone : +45 2527 7107
Fax   : +45 4466 8856

Miracle A/S
Kratvej 2
2760 Målev
http://miracleas.dk




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Gram
  INET: peter.gram_at_miracleas.dk

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