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: