RE: RMAN Catalog: 1 vs. many - Opinions

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Fri, 04 Apr 2003 13:28:55 -0800
Message-ID: <F001.0057ADCC.20030404132855@fatcity.com>

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

--

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

Author:
  INET: Paula_Stankus_at_doh.state.fl.us

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 - 15:28:55 CST