To answer an old question you asked a couple of months ago: Switching to online backup (RMAN, or scripted hot backup) causes no downtime. That might impress your boss! Best regards, Carel-Jan Engel === If you think education is expensive, try ignorance. (Derek Bok) === On Fri, 2004-11-19 at 20:49, Alex wrote: > Hi All, > > Previous DBA did not set up any archived logs maintanance here si I am in the > process of developing a process that will store old archived logs on DVD. > We're on 9.2.0.5 on Win2K. Here is what I am thinking: after each cold > backup, do alter system archive log current to archive the latest redo, zip > all old logs and copy them to DVD, then delete them from disk. Can someone > share a script or info on this? > > Thanks -- //www.freelists.org/webpage/oracle-l