Re: Automatic Deletion of Archive Logs (Oracle 8)

On unix you can use cron daily to execute:

find $ARCHIVE_DIRECTORY -name "*.log" -mtime +5 -exec rm {} \;

This removes all "*.log" files that are over 5 days old.

By the way, if you are keeping backups for 30 days, you need to keep the archive logs also for 30 days. If you don't have that much disk, backup the archive logs to tape.

Byron.Landers_at_cox.com wrote:

> Does someone have a script that automatically monitors & cleans the archive
> log directory for Oracle 8.0.4? My DB is doing a lot of archiving and I am
> having to manually trim the directory down to keep the file system from
> filling up.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Aug 10 1998 - 23:17:13 CDT