a 1 year backup retention is riddiculous. Alan.- On Mon, Apr 22, 2013 at 7:21 PM, Ls Cheng <exriscer@xxxxxxxxx> 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 > > > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l