Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Purging Managed Standby Database Archive Logs

Purging Managed Standby Database Archive Logs

From: Orr, Steve <sorr_at_rightnow.com>
Date: Thu, 12 Dec 2002 08:04:08 -0800
Message-ID: <F001.00518B01.20021212080408@fatcity.com>


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: Orr, Steve
  INET: sorr_at_rightnow.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).
Received on Thu Dec 12 2002 - 10:04:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US