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: Alex <stant_98_at_yahoo.com>
Date: Fri, 19 Nov 2004 12:59:39 -0800 (PST)
Message-ID: <20041119205939.84039.qmail@web51801.mail.yahoo.com>


Are you suggesting to store both cold backup (weekly) and the archived log (for that prior 7 days)files on DVD? "Goulet, Dick" <DGoulet_at_vicr.com> wrote: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

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----

From: Guang Mei [mailto:gmei_at_incyte.com]=20 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



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
--

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



Do you Yahoo!?
 Meet the all-new My Yahoo! Try it today!

--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 19 2004 - 15:11:49 CST

Original text of this message

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