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

Hi,

I'm not sur that the commands you use are the correct ones.

You can delete the obsolete backups (9i syntaxe) :

report obsolete;
delete obsolete;

The crosscheck command tells you if a backup still exists on the media. If the backup was deleted (by os command), the backup is flaged as expired, then you can delete it (9i syntaxe):

crosscheck backup of archivelog until time 'SYSDATE-60'; delete expired archivelog ...;

Regards

Dias

Holger Marzen <holger_at_marzen.de> wrote in message news:<b8bfo4$4d4$1_at_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 Sat Apr 26 2003 - 03:44:20 CDT