From oracle-l-bounce@freelists.org Fri Nov 19 14:49:36 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iAJKnaJ05818 for ; Fri, 19 Nov 2004 14:49:36 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iAJKnZi05813 for ; Fri, 19 Nov 2004 14:49:35 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F246972D87E; Fri, 19 Nov 2004 15:55:53 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10997-40; Fri, 19 Nov 2004 15:55:53 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6A86772E086; Fri, 19 Nov 2004 15:48:26 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: RE: Archived logs maintanance Date: Fri, 19 Nov 2004 15:38:22 -0500 Message-ID: <4001DEAF7DF9BD498B58B45051FBEA6501DFA09F@25exch1.vicorpower.vicr.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Archived logs maintanance Thread-Index: AcTOdiPG8J/DX2pDSf2IUCX5z39JcAAAQXFg From: "Goulet, Dick" To: X-OriginalArrivalTime: 19 Nov 2004 20:38:22.0764 (UTC) FILETIME=[B64546C0:01C4CE77] X-archive-position: 12477 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DGoulet@vicr.com Precedence: normal Reply-To: DGoulet@vicr.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@incyte.com]=20 Sent: Friday, November 19, 2004 3:10 PM To: stant_98@yahoo.com; oracle-l@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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Alex Sent: Friday, November 19, 2004 2:50 PM To: oracle-l@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