Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.htmlReceived on Mon Nov 17 2003 - 19:37:25 CST