The OP doesn't have a catalog instance.
He wants to 'purge'/delete records from the *live* controlfile, as that
seems to annoy him. I have never seen that this is an issue.
The O/P should be advised to direct his complaints to Oracle and for the
rest be ignored.
--
Sybrand Bakker
Senior Oracle DBA
to reply remove '-verwijderdit' from my e-mail address
"dias" <ydias_at_hotmail.com> wrote in message
news:55a68b47.0304270207.4456251e_at_posting.google.com...
> 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 - 15:31:06 CDT
