Re: Rman backup keep forever
- From: Jack van Zanen <jack@xxxxxxxxxxxx>
- To: Romeo Ybanez <raybanez@xxxxxxxxx>
- Date: Wed, 15 Apr 2009 21:00:54 +1000
Hi
This is the workaround we came up with. I would have thought Rman would have
been smarter..
Anybody got another solution?
But as Stefan pointed out in 11G it is added as a feature. I guess I need to
read some more on the 11G features
Thanks
2009/4/15 Romeo Ybanez <raybanez@xxxxxxxxx>
> 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
>
>
--
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:
