RE: Archived logs maintanance

When I say "good cold backup", I mean a "good" cold backup. Also "old archived logs" I mean archive logs that were generated BEFORE "good" cold backup. So unless someone wants to recover DB to a state that was before the "good cold backup" (which I agree that could happen) , the "old archived logs" are useless.

Guang

-----Original Message-----

From: Powell, Mark D [mailto:mark.powell_at_eds.com] Sent: Friday, November 19, 2004 3:50 PM
To: 'gmei_at_incyte.com'; oracle-l_at_freelists.org Subject: RE: Archived logs maintanance

Archived logs are not necessarily useless after a cold backup. When in archive log mode you can roll forward using a cold backup as the base. Archived logs made before the last cold backup could be necessary if the prior hot or cold backup had to be applied and rolled forward either due to some type of logical corruption or the loss of one or more of the most recent cold backup files occurred and a media recovery operation became necessary.

IMHO -- Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Guang Mei Sent: Friday, November 19, 2004 3:10 PM
To: stant_98_at_yahoo.com; oracle-l_at_freelists.org Subject: RE: Archived logs maintanance

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.

Guang

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Alex Sent: Friday, November 19, 2004 2:50 PM
To: oracle-l_at_freelists.org
Subject: Archived logs maintanance

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