Re: Archived logs maintanance

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

--
http://www.freelists.org/webpage/oracle-l