Oracle-L: RE: RMAN Configuration Question

From: April Wells <awells_at_csedge.com>
Date: Tue, 05 Mar 2002 11:48:29 -0800
Message-ID: <F001.0041FEC7.20020305114829@fatcity.com>

I have two repositories in test and will have 2 in production. One to backup the databases (an instance unto itself) and one to backup the RMAN instance (schema within one of the lesser instances). In a perfect world where you have acres of dasd and unlimited everything, I guess it might be cleaner. But reality sets in.

April Wells
Corporate Systems
Amarillo Texas

-----Original Message-----
Sent: Tuesday, March 05, 2002 12:43 PM
To: Multiple recipients of list ORACLE-L

Pat,

This makes no sense to me. I have one Rman catalog for all our databases that are at the same release level.

I can see separate Rman catalogs for different release levels, but even this is not necessary. Lower levels of Rman work with higher levels of the Rman repository.

Hope this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Tuesday, March 05, 2002 12:53 PM
To: Multiple recipients of list ORACLE-L

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

--

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: Mercadante, Thomas F
INET: Thomas.Mercadante_at_Labor.State.Ny.Us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

begin 666 InterScan_Disclaimer.txt

M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I<R!S
M=')I8W1L>2!C;VYF:61E;G1I86P_at_86YD(&9O<B!T:&4@:6YT96YD960@=7-E
M(&]F('1H92!A9&1R97-S964@;VYL>3L@:70@;6%Y(&%L<V\@8F4@;&5G86QL

M>2!P<FEV:6QE9V5D(&%N9"]O<B!P<FEC92!S96YS:71I=F4N("!.;W1I8V4@

M:7,@:&5R96)Y(&=I=F5N('1H870_at_86YY(&1I<V-L;W-U<F4L('5S92!O<B!C
M;W!Y:6YG(&]F('1H92!I;F9O<FUA=&EO;B!B>2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@<F5C:7!I96YT(&ES('!R;VAI8FET960_at_86YD(&UA

M>2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@<F5C96EV960@=&AI<R!M97-S M86=E(&EN(&5R<F]R+"!P;&5A<V4@;F]T:69Y('1H92!S96YD97(@:6UM961I M871E;'D_at_8GD@<F5T=7)N(&4M;6%I;"X*"D-O<G!O<F%T92!3>7-T96US+"!) M;F,N(&AA<R!T86ME;B!E=F5R>2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@

M96YS=7)E('1H870_at_86YY(&%T=&%C:&UE;G0@=&\@=&AI<R!E+6UA:6P@:&%S
M(&)E96X@<W=E<'0_at_9F]R('9I<G5S97,N("!792!A8V-E<'0@;F\@;&EA8FEL
M:71Y(&9O<B!A;GD_at_9&%M86=E('-U<W1A:6YE9"!A<R!A(')E<W5L="!O9B!S

M;V9T=V%R92!V:7)U<V5S(&%N9"!A9'9I<V4@>6]U(&-A<G)Y(&]U="!Y;W5R M(&]W;B!V:7)U<R!C:&5C:W,@8F5F;W)E(&]P96YI;F<@86YY(&%T=&%C:&UE %;G0N#0H
end

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: April Wells
INET: awells_at_csedge.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------