Re: how to purge archive log records from the controlfile?

From: Holger Marzen <holger_at_marzen.de>
Date: 25 Apr 2003 14:12:20 GMT
Message-ID: <b8bfo4$4d4$1@bluebell.marzen.de>

On Thu, 24 Apr 2003 19:03:14 +0200, Sybrand Bakker wrote:

>>but as far as I understand the records are only marked as deleted. The
>>controlfiles have still the same number of records, as Oracletool shows
>>(e.g. 6MB for "Archived log").
>>
>>How can I shrink the files and purge the records? Rman's doc mentions
>>prgrmanc.sql, but this is described to work with a recovery catalog.
>>

>
> Not an issue. There is a parameter which states how long these records
> will be kept, the default is 7 days.

It's set to 60 days - and the limit is ignored. Probably because the file can grow.

> If you can't afford expanding controlfiles you should seriously
> consider whether your configuration is sufficient. Disk is cheap.
> And NO: you can't 'purge' the controlfile without risking to screw it
> up.

Disk space is not the problem, but the

list backup of database archivelog all

now runs for over an hour without being finished. I'll definitely run into problems during the dext months or years. Is there a way to purge the old records by recreating the controlfile in an automated way? Received on Fri Apr 25 2003 - 09:12:20 CDT