How to housekeep archive log files?

From: PasirRis <jackling_at_singnet.com.sg>
Date: Wed, 21 Mar 2001 22:31:11 +0800
Message-ID: <99advh$mnp$1@violet.singnet.com.sg>

version: Oracle Std Ed 8.1.7 on Sun Solaris 8.

'archive log list' tells me some archive log seq nos. e.g. from 132 and current is 149.
I do a hot backup of datafiles
then, I issue the command 'alter system log switch'. (so, the current arch. log file will be 150 and files up to 149 is the targeted group for backup) I backup all the archive log files in the directory.

I suppose after the datafiles, archive log files are backup (say to tape), I don't need to keep them in the disk and can remove those 'old' archive log files already.

Question:

(Any sample?) How to write a script to remove those archive log files already backuped? In the sample above, I suppose I should keep archive files from 150 onwards on the disk but anything b4 it can be removed from disk SAFELY (?). Any good idea?

thanks,
jackling. Received on Wed Mar 21 2001 - 08:31:11 CST