Re: long term archivelog retention

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Mon, 22 Apr 2013 20:28:34 -0300
Message-ID: <CAJ2dSGSSZNR-2j1+y7dggZFtyDT8AU+jhjz6swxF=qJGmpU0Sg_at_mail.gmail.com>

a 1 year backup retention is riddiculous. Alan.-

On Mon, Apr 22, 2013 at 7:21 PM, Ls Cheng <exriscer_at_gmail.com> wrote:

> Hi
> I have a database that has a requirement of retaining archivelogs for 1
> year. The database must be able to recover to ay point in time in 1 year
> period.
>
> So I have thought of using keep until time option for archivelogs (new in
> 11g). The strategy will be daily database backup with be retained 31 days
> using normal recovery windows retention policy, monthly 12 months and anual
> backups 5 years using keep until time. Archivelogs will also use keep until
> time sysdate + 365.
>
> Anyone have used keep until time for archivelogs and know any gotchas? So
> far the gotcha I have found is that we cannot use DELETE ARCHIVELOG ALL
> BACKED UP N TIMES TO DISK.
>
> Thanks
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 23 2013 - 01:28:34 CEST