long term archivelog retention
From: Ls Cheng <exriscer_at_gmail.com>
Date: Tue, 23 Apr 2013 00:21:51 +0200
Message-ID: <CAJ2-Qb-50C29OUriVzdM5Jzv8bqF0r=GfNEtb7pH7UA8wDxWpQ_at_mail.gmail.com>
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.
Date: Tue, 23 Apr 2013 00:21:51 +0200
Message-ID: <CAJ2-Qb-50C29OUriVzdM5Jzv8bqF0r=GfNEtb7pH7UA8wDxWpQ_at_mail.gmail.com>
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-lReceived on Tue Apr 23 2013 - 00:21:51 CEST