Re: Rman backup keep forever
- From: Romeo Ybanez <raybanez@xxxxxxxxx>
- To: jack@xxxxxxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 15 Apr 2009 01:39:47 -0700 (PDT)
Hi,
You may just configure RMAN with this command:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3560 DAYS;
This will maintain your backup for 10 years.
Romy
________________________________
From: Jack van Zanen <jack@xxxxxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, April 15, 2009 12:44:01 PM
Subject: Rman backup keep forever
Hi
we just had a little discussion here about the following situation
When you backup a database (hot) with RMAN and specify keep forever Rman will
never delete the archives anymore (there is metalink articles about this)
But if you are doing a hot backup you can not use the keep forever nologs
option as there won't be any logs to recover the database to a consistent state.
I would have though you should be able to tell RMAN to backup the database and
archivelogs and keep that set forever, thus allowing you to restore and recover
to a constistent state (for instance year end backups).
There does not appear to be such a feature/clause.
Am I just not reading the docs correctly or is this really the case?
--
Jack van Zanen
-------------------------
This e-mail and any attachments may contain confidential material for the sole
use of the intended recipient. If you are not the intended recipient, please be
aware that any disclosure, copying, distribution or use of this e-mail or any
attachment is prohibited. If you have received this e-mail in error, please
contact the sender and delete all copies.
Thank you for your cooperation
Other related posts: