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

Hi Holger,

Could you give a small test case for your problem. I cant reproduce what you say. The cmmand "list backup of database archivelog all" doesn't report the deleted backups.

Dias

Holger Marzen <holger_at_marzen.de> wrote in message news:<b8doe8$38o$1_at_bluebell.marzen.de>...
> * On 26 Apr 2003 01:44:20 -0700, dias wrote:
>
> > 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 ...;
>
> These commands work in v8, too. But they mark the records in the control
> files as deleted, they don't remove them.
Received on Sun Apr 27 2003 - 05:07:57 CDT