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

From: Holger Marzen <holger_at_marzen.de>
Date: 24 Apr 2003 18:05:41 GMT
Message-ID: <b8991l$6t3$1@bluebell.marzen.de>

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

> On 24 Apr 2003 16:15:56 GMT, Holger Marzen <holger_at_marzen.de> wrote:
>

>>Oracle 8.1.7 on Solaris 7
>>
>>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.
>>
>>Any ideas?

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

But it is ignored if the files can grow. On Unix, files are usually allowed to 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.

The disk space doesn't matter, because it's only a few MB. But rman's list and report functions become painfully slow.

Are the "marked as deleted" records re-used at least? Then the control files wouldn't grow endlessly. Received on Thu Apr 24 2003 - 13:05:41 CDT