Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN Retention policies
Hi Tony!
Yes exactly, but it is the OP's need I guess:
>- Keep daily full backups for 1 week
>- Keep full backups taken on Sunday for 1 month
>- Keep 1 backup from every month for 1 year
>- Keep all archive logs for 30 days
He does not want to be able to perform point-in-time recovery over the year, just to be able to restore and recover from those backups.
Jerome
On 10/28/05, NEW pop.tiscali.de <adolph.tony_at_tiscali.de> wrote:
> Hi Jerome,
>
> If you only keep the logs generated during the backups, then up until what
> time do you expect to recover to? There'll be a gap from Dec 04 til now?
> Or?
>
> Tony
> ----- Original Message -----
> From: "Vitalis Jerome" <vitalisman_at_gmail.com>
> To: <t_adolph_at_hotmail.com>
> Cc: <mschmitt_at_uchicago.edu>; <oracle-l_at_freelists.org>
> Sent: Friday, October 28, 2005 12:02 PM
> Subject: Re: RMAN Retention policies
>
>
> > > is the monthly backup cold / off line? I guess so, if not you must keep
> all
> > > archived redos for that time, i.e. a year
> >
> > That's not true. You must keep the logs generated during the backups,
> > not 1 year worth of logs.
> > As I said, it seems that RMAN 9i does not enforce this need
> > correctedly (by means of option KEEP LOGS). It keeps *all* subsequent
> > logs.
> >
> > Jerome
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 28 2005 - 07:09:54 CDT
![]() |
![]() |