Re: standby deletion of archive logs

r_p_renu_at_yahoo.com (rpr) wrote in message news:<4db90929.0311170842.3d2968c4_at_posting.google.com>...
> Hi,
> On the standby database is there a way to have oracle delete the
> archive logs automatically after applying the logs. We can put a cron
> but that would delete it no matter what. Thank You

grep the alert log for Media Recovery Log,

CURRENT_FILE=`grep "Media Recovery Log"
$ORACLE_HOME/admin/$ORACLE_SID/bdump/aler*${ORACLE_SID}.log |tail -1|awk '{print $4}'`

You'll probably want to do something like touch a file to the date of that file
and then find, list and remove the archive logs older than that.

I just do a cron with a longer keep time than the intervals between when someone checks the db.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/news/uniontrib/wed/currents/news_1c12bower.html