RE: Archived logs maintanance

  • From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 19 Nov 2004 14:31:35 -0600

Unless three months later auditors want to see data that was deleted prior to 
the cold backup.  Not that *I've* ever run across that situation...
Also, why would you run regular cold backups if you're in archive log mode?

Rich

-----Original Message-----
Sent: Friday, November 19, 2004 2:10 PM
To: stant_98@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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-----
Sent: Friday, November 19, 2004 2:50 PM
To: oracle-l@xxxxxxxxxxxxx
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



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

Other related posts: