| 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 Catalog or not to catalog, that is the question
Dennis,
It's been a while since I read the RMAN documentation. I appreciate the clarification. What Oracle refers to as on-line backup is a different story from hot backups. Thanks Tom for your comments as well. I hope this thread turns helpful to Fuad. Thanks for the suggestion to get Freeman's Oracle9i RMAN Backup & Recovery. I keep hearing good things about this book. Perhaps, it will be the next book on my bookshelf!
Julio
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DENNIS WILLIAMS
Sent: Wednesday, June 09, 2004 10:59 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: RMAN - To Catalog or not to catalog, that is the question
Julio
Thanks for the explanation. When I said "hot backups", I was referring to the older , non-RMAN method of backing up Oracle while the database was open. I tried that years ago. If this list was available then, I have no doubt that I could have received some excellent advice that would have helped me overcome my difficulties. But that is water under the bridge.
To avoid confusion, I think Oracle has tried to suggest the term
on-line backup for RMAN backups while the database is open. That is the
only type of RMAN backup I have performed because I figured that was the
only thing that made RMAN worthwhile. And I appreciate the help that
people on this list provided in helping me understand the sometimes
obscure RMAN documentation.
While I'm on topic of documentation, if you are going to tackle RMAN,
purchase Robert Freeman's great book Oracle9i RMAN Backup & Recovery.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of QuijadaReina, Julio C
Sent: Wednesday, June 09, 2004 9:51 AM
To: oracle-l_at_freelists.org
Subject: RE: RMAN - To Catalog or not to catalog, that is the question
Dennis,
Thanks. Sorry, I should have elaborated a little bit more...In your post
you said:
>I never got hot backup working, so I can't respond to that issue.
And so, I just wanted to point out that in the process I use my prod db is never shut down and that it is not too hard to get hot backups to work with RMAN on 9.2.0 if you ever would like to try it ;-)
Regards,
Julio
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DENNIS WILLIAMS
Sent: Wednesday, June 09, 2004 10:36 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: RMAN - To Catalog or not to catalog, that is the question
Julio
Congratulations. Is there a point here somewhere?
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of QuijadaReina, Julio C
Sent: Wednesday, June 09, 2004 9:34 AM
To: oracle-l_at_freelists.org
Subject: RE: RMAN - To Catalog or not to catalog, that is the question
Dennis,
I have three databases on 9.2.0 (prod, train, and recovery catalog) and use OS schedule jobs to run a couple of scripts, which do the following:
Once a week, I copy prod into train using the 'dup' command. And just for giggles...I connect to train Monday morning to check I got a fresh copy of prod and it has been faithful since.
At no point in this process a shut down my prod db.
Kind regards,
Julio
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DENNIS WILLIAMS
Sent: Wednesday, June 09, 2004 9:46 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: RMAN - To Catalog or not to catalog, that is the question
Ron
Joe and Fuad make some excellent points, so I won't repeat those. I never got hot backup working, so I can't respond to that issue. Perhaps someone else on the list can. My gut reaction is that if you have something that works, has been tested, and you trust, then stick with that.
As far as RMAN catalog or not, I would make the following points:
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Smith, Ron L.
Sent: Wednesday, June 09, 2004 8:29 AM
To: oracle-l_at_freelists.org
Subject: RMAN - To Catalog or not to catalog, that is the question
We are getting ready to start using RMAN on several new 9i Linux
databases.
I guess the first question would be is RMAN really that much better then
using home grown dynamic hot backup scripts? We have developed these
for our Oracle/NT environment and they seem to work fine.
The second question would be should we use a recovery catalog? The
catalog seems to add a lot of complexity to the setup and to a disaster
recovery plan.
Thanks!
Ron
Important Notice!
If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the message is prohibited.
Please let me know immediately by return e-mail if you have received
this message by mistake, then delete the e-mail message.
Thank you.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org put
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org put
 |
 |