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: [EMAIL PROTECTED] =================================================== http://www.cool-tools.co.uk Maximising throughput & performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
<<attachment: forfiles.exe>>