Re: Archive logs in control file

From: G Dahler <yellow-shark_at_spamex.com>
Date: Wed, 26 May 2004 10:52:41 -0400
Message-ID: <1b2tc.29113$sr3.805608@news20.bellglobal.com>

"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 Received on Wed May 26 2004 - 09:52:41 CDT