Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN KEEP
Hi Dennis,
Thanks for the suggestion. Sounds like a plan! I'll give it a go - I had been hoping to keep everything within the same catalog and underlying configuration (regular daily backups and long-term "save point" backups) but seems this isn't going to happen. Your suggestion looks good though, as it doesn't add too much additional complexity.
Thanks again
- Charlotte
DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
Charlotte
As I understand your requirement, you want to take and RMAN backup and
then at some future time restore the database to the time you took the
backup?
I don't think the RMAN catalog was designed for this purpose.
Here is how I would approach it. Take the RMAN backup set, the archive
logs for the time of the backup and for a short period of time afterward,
and just in case, a backup controlfile. It doesn't matter if you take the
backup using the controlfile or the RMAN catalog.
Now, at any time in the future you can restore that backup on another
server, as long as have the same Oracle version. I just do controlfile
recoveries, but you could take an export of the RMAN catalog after the
backup completed and restore that as well. I just think the controlfile
recovery is simpler in this situation.
Dennis Williams
DBA
Lifetouch, Inc.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Charlotte Hammond
Sent: Wednesday, November 10, 2004 4:51 AM
To: ORACLE-L
Subject: RMAN KEEP
Hi List,
I'm looking for some clarrification on the following RMAN problem. I want to keep point-in-time backups of a database for a long(-ish) time.
If I do KEEP LOGS, then I end up keeping all the redo logs since the backup until the current time, which isn't what I want - I just want enough to recover to the end of the backup.
If I do KEEP NOLOGS then I have to do a cold backup, which I can't easily do.
Am I mis-understanding? Or is there another way to acheive what I want?
Thanks for any help,
- Charlotte
-- http://www.freelists.org/webpage/oracle-l --------------------------------- Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 11 2004 - 03:59:43 CST