Re: Archive logs in control file

On Wed, 26 May 2004 10:52:41 -0400, "G Dahler" <yellow-shark_at_spamex.com> wrote:

>
>"Chloe Crowder" <chloe.crowder_at_bl.uk> a écrit dans le message de
>news:f27559a3.0405260610.2700066_at_posting.google.com...
>> Hi
>>
>> in Oracle 817 is there a mechanism for clearing the list of archive
>> log files held in the control file. We interrupted the log archive
>> mechanism on a production server and restarted later, but this means
>> there are several thousand useless log files listed. Also in a test
>> server where were trying out backup/recovery scenarios we've got
>> duplicate files listed - presumably from where we've reset logs after
>> partial recovery.
>>
>
>IIRC, the liste or archived log files is not in the controlfile and
>automatically "purges" itself after 30 days or so...
>
>But I may be wrong
>

This list of archived log files definitely IS in the control file, and it is kept controlfilerecord_keeptime days (which might be 30, though the default is 7)

--
Sybrand Bakker, Senior Oracle DBA