Re: automatic arch log delete

From: Joel Garry <joel-garry_at_home.com>
Date: 11 Jul 2005 16:20:36 -0700
Message-ID: <1121124036.129484.232520@g44g2000cwa.googlegroups.com>

If you are decoupling the removal of archive logs from the backups (which is a good idea), you probably want to use operating system commands to do it anyways.

I run a cron something like 49 03 * * * find .../arch -type f -mtime +2
-exec ll {} \; >> /home2/oracle/archfilerm ; find .../arch -type f
-mtime +2 -exec rm {} \;

where ... is the explict path to where the arcs are. Having several days of arcs previous to any given backup has definitely helped when recovering. And the record of deletion is nice. There's probably better ways to code it, but the above is easy. There's probably was to write it with agents, but since you haven't given any platform or version, difficult to advise.

jg
--

@home.com is bogus.
http://www.grovel.org.uk/news/images/inthes01.jpg Received on Mon Jul 11 2005 - 18:20:36 CDT