Oracle-L: RE: RMAN:To use or not to use a recovery catalog

From: laura pena <lizzpenaorclgrp_at_yahoo.com>
Date: Wed, 30 Apr 2003 18:41:37 -0800
Message-ID: <F001.0058D25C.20030430184137@fatcity.com>

Thanks for the input.. I am currently attending IOUG and they had quite a few seminars on RMAN. All speakers Ispoke with say use the recovery catalog if you have many databases to support. One person in fact said you'd be an idiot not to use it. With that said, I have been given the following as reasons why recovery catalog is good to use:- Scripts can be stored in the recovery catalog- Control file will get backedup (you can do this without recovery catalog)- Good for more than one database with different versions.-Control file will hold all backup records .. will eventually get really large ( but you can purge this via an init.ora file)-More reporting features- Possibility of loosing both control files- Richer command set But if I have one production database to backup (100g) and am worried about paying extra for having a recovery catalog on another system, I am begining to belive storing backup information in the control file is just as safe. With this said, I have no! t !
had to restore from my RMAN backup yet. -Lizz

DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:Laura When RMAN stabilized in Oracle8i, Oracle bragged so much about the catalog capability that most of us, me included, got the impression that only an idiot wouldn't use a catalog. Now in Oracle9i, Oracle has added many features to the control file option (non-catalog). Now I'm wondering if you only have one or two databases, why use a catalog? That is what I'm considering for my future databases.

Dennis Williams
DBA, 60%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, April 29, 2003 6:52 PM
To: Multiple recipients of list ORACLE-L

All,
I need some to use or not to use a recovery catalog via RMAN.

Currently our system does not use a recovery catalog and backs up via veritas netbackup using a script ( I supplied it ).

I have little RMAN experience and want to know if people are creating recovery catalog on the same system as they are backing up.

Any advised would be most welcomed.

Thanks in advanced.

Lizz

Do you Yahoo!?
The New
Yahoo! Search - Faster. Easier. Bingo.

--

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!?
The New Yahoo! Search - Faster. Easier. Bingo.
--

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

Author: laura pena
INET: lizzpenaorclgrp_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------