From oracle-l-bounce@freelists.org Fri Oct 28 06:05:34 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9SB59h9013476 for ; Fri, 28 Oct 2005 06:05:19 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9SB4jvX013424 for ; Fri, 28 Oct 2005 06:04:55 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6243721155E; Fri, 28 Oct 2005 06:04:37 -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 08301-03; Fri, 28 Oct 2005 06:04:37 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D401B2113C1; Fri, 28 Oct 2005 06:04:36 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 28 Oct 2005 06:02:43 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0321C2116E6 for ; Fri, 28 Oct 2005 06:02:43 -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 08076-01 for ; Fri, 28 Oct 2005 06:02:42 -0500 (EST) Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.202]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8933821112F for ; Fri, 28 Oct 2005 06:02:40 -0500 (EST) Received: by nproxy.gmail.com with SMTP id a27so135746nfc for ; Fri, 28 Oct 2005 04:02:38 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=j89yyFLGmsr0ne7EqgjR6E2PMb6igYAFsIA/XAH/813GoXaGbJ8EfINPtjOQlnD20tt4+hxqSFdSQ2fjraiyg+W5DCQX0VE9JoK6Ogi+O8j8+6zaXWBmndHgmdHKvfzWtsGu89EUkn3fTgQpWy/gjMCoUK9WX1qgN8rnyo4YR7o= Received: by 10.48.143.8 with SMTP id q8mr53152nfd; Fri, 28 Oct 2005 04:02:38 -0700 (PDT) Received: by 10.48.234.10 with HTTP; Fri, 28 Oct 2005 04:02:38 -0700 (PDT) Message-ID: <68b128550510280402vc3ad8d4lac788d1a42d47166@mail.gmail.com> Date: Fri, 28 Oct 2005 13:02:38 +0200 From: Vitalis Jerome To: t_adolph@hotmail.com Subject: Re: RMAN Retention policies Cc: mschmitt@uchicago.edu, oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline References: X-archive-position: 27725 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: vitalisman@gmail.com Precedence: normal Reply-To: vitalisman@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.9 required=5.0 tests=BAYES_00 autolearn=ham version=2.63 > is the monthly backup cold / off line? I guess so, if not you must keep all > archived redos for that time, i.e. a year That's not true. You must keep the logs generated during the backups, not 1 year worth of logs. As I said, it seems that RMAN 9i does not enforce this need correctedly (by means of option KEEP LOGS). It keeps *all* subsequent logs. Jerome -- http://www.freelists.org/webpage/oracle-l