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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Deleting old archive log files.

RE: Deleting old archive log files.

From: Sutton, Reed <rsutton_at_fcg.com>
Date: Thu, 04 Apr 2002 05:58:29 -0800
Message-ID: <F001.0043B124.20020404055829@fatcity.com>


Mark,

We use the forfiles.exe utility that comes with the NT Resource kit. I have attached it here and below I have pulled the code out of our hotbackup.cmd which runs our hotbackups. Its the last step in our hotbackup, to clean up old archived logs which have already been archived to tape. If you need any help with it just let me know. I've cc:ed you directly because I assume the listserv will strip the executable out of my email.

Reed

obviously, at the beginning of the script all the variables, like %bkupdir%, are defined

rem
rem Remove archived redo log files older than 3 days.

rem	forfiles is from the NT Resource Kit
rem		-p specifies search path
rem		-m specifies search mask
rem		-d specifies number of days (+/-) from today
rem		-c specifies the command to execute on each file
rem		   "cmd /c" executes command specified then terminates
the shell
rem
%bkupdir%\forfiles -p%archdir%\%ORACLE_SID% -m*.arc -d-3 -c"cmd /c del @FILE"
rem
rem Remove trace files older than 35 days. rem
%bkupdir%\forfiles -p%udumpdir% -m*.trc -d-35 -c"cmd /c del @FILE"

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

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: mark_at_cool-tools.co.uk
===================================================
           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).

Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.

This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.

------_=_NextPart_001_01C1DBE1.69C4DE5E--
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sutton, Reed
  INET: rsutton_at_fcg.com

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:29 CST

Original text of this message

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