Re: Archive logs in control file

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Thu, 27 May 2004 00:17:38 +0200
Message-ID: <co5ab092d3ob1fociurk9o1iimehrcavd8@4ax.com>

On 26 May 2004 07:10:39 -0700, chloe.crowder_at_bl.uk (Chloe Crowder) wrote:

>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.
>
>Thanks
>Chloe Crowder
>The British Library

Don't bother. They will disappear in a few days time. And as you can query v$archived_log it shouldn't be a concern. The other question is just too vague to answer, the suggestion you provide however is definitely rubbish.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed May 26 2004 - 17:17:38 CDT