| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN:To use or not to use a recovery catalog
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
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 servicesto: 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
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |