RE: Delete archived redo logs

Hi Helmut,

The following applies to NT4 - there may be other ways to achieve this under Windows 2000.
It is also possible to do it with a totally batch file based solution but the batch file becomes Very long and complicated.

The forfiles.exe program that comes with the NT Resource kit will allow you to do this, and can be made more user friendly by writing a "wrapper" bat file that just accepts (say) filespec and number of days. This is what I use.

The forfiles bat file can be obtained from http://www.ipass.net/~davesisk/oont_download.htm

There are also shareware / freeware programs that do delete on a time basis - eg delold from http://www.savilltech.com/delold/

Other users have previously suggested a cascading dir tree eg each day move files in dir day1 to day2, day2 to day3, .... and finally delete the files from the bottom most directory.

Or you can use a 3d-party shell, such as "Take Command/32"
(http://www.jpsoft.com/) which WILL accept commands doing what you want
(i.e. del c:\archivedest\*.* [d09-15-98, +3] which would delete all files
from Sept15-Sept18). This has been reported by Oracle on Metalink to work well with the NT scheduler but I haven't used it. It is stated to coexist with the native CMD.EXE shell.

You can also use SQL Plus to spool out the required commands by querying the appropriate data dictionary tables.

Regards,
Bruce Reardon
mailto:bruce.reardon_at_comalco.riotinto.com.au

-----Original Message-----
From: Helmut Daiminger [mailto:hdaiminger_at_vivonet.com] Sent: Tuesday, 17 October 2000 10:26
To: Multiple recipients of list ORACLE-L Subject: Delete archived redo logs

Hi!

Is there a possibility in NT/2000 to delete all archived redo logs that are older than 4 days. Does the DOS del command provide an option for that? Something like

del \...\*.arc days=4

This is 8.1.6 on Win2k.

Thanks,
Helmut

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Helmut Daiminger
  INET: hdaiminger_at_vivonet.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).