RE: Deleting old archive log files.

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Thu, 04 Apr 2002 05:58:25 -0800
Message-ID: <F001.0043B0DC.20020404055825@fatcity.com>

Tom,

This is perfect! Thanks!

Best wishes

Mark

-----Original Message-----
Thomas F
Sent: 04 April 2002 14:04
To: Multiple recipients of list ORACLE-L

Mark,

I have a simple Perl script that can do the job for you. I've not found a way to do this using NT scripting.

Attached is the script. Hope this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Thursday, April 04, 2002 6:43 AM
To: Multiple recipients of list ORACLE-L

I don't - but maybe take a look at the rman package (dbms_rman.delete_file or something like that) which allows you to delete files from the operating system.

You could then use PL/SQl and the various v$ views to determine which archives you want to toast.

hth
connor

• Mark Leith <mark_at_cool-tools.co.uk> wrote: > Hi All,
  >
  > To save me re-inventing the wheel:
  >
  > Does anybody have a batch script (that runs on NT)
  > that deletes archive log
  > files that are older than X days old? I've looked at
  > the DEL command, but
  > this doesn't have a date/time based attribute
  > parameter..
  >
  > Has anybody been through this already?
  >
  > All help appreciated!
  >
  > Mark
  >
  > ===================================================
  > Mark Leith | T: +44 (0)1905 330 281
  > Sales & Marketing | F: +44 (0)870 127 5283
  > Cool Tools UK Ltd | E: >
  

  ---

  
  > http://www.cool-tools.co.uk
  > Maximising throughput & performance
  >
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Mark Leith
  > INET: mark_at_cool-tools.co.uk
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

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

  ---

Connor McDonald
http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

---

Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Apr 04 2002 - 07:58:25 CST