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

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

>Oracle 8.1.7 on Solaris 7
>
>Because the operation system can expand the controlfiles, they grow and
>grow and have old records with archive log backups and database backups.
>I tried to do some maintenance with
>
> rman nocatalog <<EOF
> connect target
> allocate channel for delete type disk;
> crosscheck backup of controlfile completed before 'SYSDATE-60';
> delete expired backup of controlfile completed before 'SYSDATE-60';
> crosscheck backup of database completed before 'SYSDATE-60';
> delete expired backup of database completed before 'SYSDATE-60';
> crosscheck backup of archivelog until time 'SYSDATE-60';
> delete expired backup of archivelog until time 'SYSDATE-60';
> release channel;
>
>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.
>
>Any ideas?

Not an issue. There is a parameter which states how long these records will be kept, the default is 7 days.
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.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Apr 24 2003 - 12:03:14 CDT