Message-ID: <F001.00518BE0.20021212091859@fatcity.com>
Date: Thu, 12 Dec 2002 09:18:59 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "John Carlson" <jcarlson@CJ.COM>
Subject: Re: Purging Managed Standby Database Archive Logs
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

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@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@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@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).