Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to purge archive log records from the controlfile?
"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.
That's just the way it works. If you don't want to buy that, address your concerns by submitting an iTar, and please stop complaining here.
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail addressReceived on Sat Apr 26 2003 - 08:37:40 CDT