Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Archived logs maintanance

RE: Archived logs maintanance

From: Guang Mei <gmei_at_incyte.com>
Date: Fri, 19 Nov 2004 15:09:42 -0500
Message-ID: <NJEDKDKJDGAKAEKKNEEJCEBBDNAA.gmei@incyte.com>


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



Do you Yahoo!?
 Discover all that’s new in My Yahoo!

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 19 2004 - 14:20:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US