Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN:To use or not to use a recovery catalog

RE: RMAN:To use or not to use a recovery catalog

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 01 May 2003 07:26:50 -0800
Message-ID: <F001.0058D6F0.20030501072650@fatcity.com>


Amen, amen!  

Our test recovery revealed several gaps. No backup can be trusted until you've tested it. Robert Freeman's book Oracle9i RMAN Backup & Recovery has several examples to help you test recovery. I didn't have his book, but I found Oracle Backup & Recovery 101 by Smith & Haisley to be a good starter. They have step-by-step tutorials where you set up a test database, back it up, and recover it. I like exact instructions ;-)

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

-----Original Message-----

Sent: Thursday, May 01, 2003 8:23 AM
To: Multiple recipients of list ORACLE-L

Lizz,  

you said :  

"With this said, I have not had to restore from my RMAN backup yet."  

I hope this does *not* mean that you have not tested a full Rman recovery. My experience has been that backing up the database with Rman is a snap. When you try to restore is where the money is! :)

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

Sent: Wednesday, April 30, 2003 10:42 PM To: Multiple recipients of list ORACLE-L

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

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 not 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 w! ant 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 <http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com> 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). Received on Thu May 01 2003 - 10:26:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US