Re: RMAN Retention policies
- From: Vitalis Jerome <vitalisman@xxxxxxxxx>
- To: "NEW pop.tiscali.de" <adolph.tony@xxxxxxxxxx>
- Date: Fri, 28 Oct 2005 14:07:10 +0200
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@xxxxxxxxxx> 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@xxxxxxxxx>
> To: <t_adolph@xxxxxxxxxxx>
> Cc: <mschmitt@xxxxxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx>
> 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
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
