Re: Purging Managed Standby Database Archive Logs

Keep it simple. If you are on unix put this in your crontab.

30 * * * * find /archive/oradata/YOURSID -type f -name "1_*.arc" -mtime +0 -exec rm -f {} \;

This will run every hour on the half hour and purge everything over 24 hours old.

Modify as you like. (-mtime +1 gives you 48 hours) Yes, I know this could delete files that haven't been applied but I figure if your standby is 24 hours behind, it will need to be re-established anyway.

HTH,
John

>>> sorr_at_rightnow.com 12/12/02 08:04AM >>>
Any one have a ready-made routine to purge the unneeded archives which have
been automagically applied to a managed standby database?

I figure it needs to:

1. Query v$archived_log and v$log_history to get a list of the archive logs (v$archived_log.name) where sequence# > [the max number you purged the last time];
2. Cycle through the above list and remove the files;
3. Record the max(sequence#) from v$log_history for the next purge.

Any other ideas/suggestions?

AtDhVaAnNkCsE!!!
Steve Orr
Standing by in Bozeman, Montana

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Carlson
  INET: jcarlson_at_CJ.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).