Re: long term archivelog retention
- From: Ingrid Voigt <GiantPanda@xxxxxxx>
- To: exriscer@xxxxxxxxx
- Date: Tue, 23 Apr 2013 01:11:37 +0200
Hi,
how do you store your archivelog and backup information?
Control_file_record_keep_time has a maximum of 365 days.
I don't know how long information about non-deleted archivelogs
will be stored in a recovery catalog. You might have to restore
old controlfile backups to get that far back in time.
(If you test this I'd be very interested in the results - got
similar requests from customers.)
Regards
Ingrid
On 23.04.2013 00:21, Ls Cheng 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
Other related posts:
