long term archivelog retention

  • From: Ls Cheng <exriscer@xxxxxxxxx>
  • To: Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 23 Apr 2013 00:21:51 +0200

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


Other related posts: