RE: Archived logs maintanance

That depends on what your going to do. It is possible that you may want
to load a previous cold backup & do a point in time recovery that is
before the next cold backup. In which case those old archive logs are
no longer useless. Of course if you've got a DVD drive that can hold
the cold backup, why do them cold? Use Rman & backup the database hot.=20

After a good cold backup, your old archived logs are useless. It would
be
better to store the files from cold back up, rather than old archived
logs
on DVD. Becuase if the system dies, you still have a good cold back up,
rather than the useless old archived logs.

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?