Paul et al.,
I agree with Paul's setup of a dedicated RMAN catalog
server. It is not a bad idea to have the datafiles for
this database on mirrored volumes. I also think a good
practice related to "saving the catalog" against tape
media errors is to do a full export on the RMAN
Catalog DB and stash the export dumpfile away on a
mirrored volume away from the datafiles.
If this DB has nothing but the RMAN catalog, it should
not be very large (let me know if this is otherwise)
and thus the full export will be a good method to have
a "logical backup". One more thing to save the skin on
your back, at a time of need. When Murphy is around I
think the word "mercy" vanishes from the English
dictionary.
Cheers,
Gaja
- Paula_Stankus_at_doh.state.fl.us wrote:
> I have setup a server for just rman catalog backed
> up to tape with clones
> offsite for DR. It makes it easier as scripts are
> parameterized to keep
> aware of backup statuses = etc. Having this on a
> centralized management
> server and can't believe this isn't just common
> practice. Just make sure no
> single point of failure.
>
> Oracle OCP DBA
>
>
> -----Original Message-----
> Sent: Friday, April 04, 2003 3:39 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Deepak
> You may also wish to consider not using
> catalog(s) -- control file
> backups. This might make it easier to add and remove
> databases in your
> environment. I'm presuming most databases are on
> their own server.
> If you want to be able to run a single query that
> will report any backup
> problems across all your databases, you will use a
> single catalog.
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Friday, April 04, 2003 2:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> We are in the process of moving from traditional hot
> backups to one using RMAN. Total databases are
> around
> 200+. Should we be using 1 or few RMAN catalogs, or
> 1
> catalog per database?
>
> Thanks,
> Deepak
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - File online, calculators, forms,
> and more
> http://tax.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Deepak Sharma
> INET: sharmakdeep_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> 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.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> 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).
>
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gaja Krishna Vaidyanatha
INET: oraperfman_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Fri Apr 04 2003 - 18:04:00 CST