Re: [10g] cleaning up disks

From: Helmut Schneider <jumper99_at_gmx.de>
Date: Mon, 29 Jan 2007 14:59:18 +0100
Message-ID: <526ctnF1monk9U1@mid.individual.net>

DA Morgan <damorgan_at_psoug.org> wrote:

> Helmut Schneider wrote:

>> Hi,
>> Silently my disks fill up with archive logs, flash back pieces, backup
>> increments and so on.
>> Could someone please point me to a good FAQ (tahiti.oracle.com isn't) how
>> to cope with that files, which one can be deleted after what time? Can I
>> create a cleanup job within oracle (e.g. with OEM)?
>> Thanks, Helmut

> CROSSCHECK ARCHIVELOG ALL;
> DELETE OBSOLETE;
> DELETE EXPIRED ARCHIVELOG ALL;
> Though from your first post it seems possible nothing may be expired.

In deed. My knowledge about oracle isn't very well by now and almost completely restricted to OEM so it seems that obviously I should deal with RMAN more often.

Thanks (also for all other replies), Helmut Received on Mon Jan 29 2007 - 07:59:18 CST