Re: deleting archive logs after successful backup with backup exec oracle agent

You should keep an online copy of the archive log files created since your last database backup. This will speed up recovery. Older archive log files that have been copied to offline storage may be deleted with a script. I use the following JScript to delete archive log files older than thirty days. The archive log directory is passed as a parameter.

void function purge(path)
{

   var fso;
   var fileList;
   var file;
   var thirtyDays = 60 * 60 * 24 * 30 * 1000;    var thirtyDaysAgo;

   thirtyDaysAgo = new Date() - thirtyDays;

   fso = new ActiveXObject("Scripting.FileSystemObject");

   fileList = new Enumerator(fso.GetFolder(path).files);

   for (; !fileList.atEnd(); fileList.moveNext())    {

      file = fileList.item();

      if (file.DateLastModified > thirtyDaysAgo) continue;
      if (fso.GetExtensionName(file).toLowerCase() != "arc") continue;

      WScript.Echo("Purging file " + file.name);

      file.Delete();

purge(WScript.Arguments(0)); Received on Tue Jan 14 2003 - 15:09:39 CET