Removing Archived logs

[KenEwald]

You might want to consider compressing older archived logs. We do that via a nightly cron job:

00 22,8 * * * /usr/contrib/bin/gzip /u623/oradata/arch/DBNAME/*.arc > /dev/null

We delete the old archived logs after our weekly hot backup is completed.

The cleanup script looks like this. (you pass in the instance name)

>more cleanup_archive.sh
#! /bin/sh

INSTANCE=/u623/oradata/arch/$1

cd $INSTANCE

/bin/find "$INSTANCE" -type f -name "arch_$1_[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9].arc*" -mtime +7 -print -exec rm -f {
} \;

exit 0

This deletes archive logs older than 7 days.