Received: (qmail 31246 invoked from network); 7 Jul 2011 12:28:14 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 7 Jul 2011 12:28:11 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 830E1E32D0A; Thu, 7 Jul 2011 13:28:10 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 8Iwgk++7ha5p; Thu, 7 Jul 2011 13:28:10 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EA3A5E32C37; Thu, 7 Jul 2011 13:27:25 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 07 Jul 2011 13:26:43 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 88E81E32921 for ; Thu, 7 Jul 2011 13:26:43 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ZGqmkdsdn19W for ; Thu, 7 Jul 2011 13:26:43 -0400 (EDT) Received: from smtp.oneneck.com (dot089host.oneneck.net [63.226.42.89]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3D7DFE30328 for ; Thu, 7 Jul 2011 13:26:42 -0400 (EDT) Received: from ONEWS06.oneneck.corp ([172.20.4.14]) by ONEWS05.oneneck.corp ([::1]) with mapi; Thu, 7 Jul 2011 10:26:40 -0700 From: "Allen, Brandon" To: "Jed_Walker@cable.comcast.com" , "peter.schauss@ngc.com" , "oracle-l@freelists.org" Date: Thu, 7 Jul 2011 10:26:38 -0700 Subject: RE: rman - backup plus archivelog Thread-Topic: rman - backup plus archivelog Message-ID: <64BAF54438380142A0BF94A23224A31E125E016A62@ONEWS06.oneneck.corp> References: <8AE45871F749FC4CBBE053CF2F8A493C0A6F8C8F@XMBVAG74.northgrum.com> <0EC85B1F3B2DF8409BF66DC182F495D9859206@DEEDS.pti-nps.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis MIME-Version: 1.0 X-archive-position: 37290 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Brandon.Allen@OneNeck.com Precedence: normal Reply-To: Brandon.Allen@OneNeck.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l I'm using the DELETE ALL INPUT option for my backups with Data Guard and it works fine, but I'm running on 10.2.0.4. I think there were some problems in earlier versions where it could cause logs to be deleted before they had been shipped to the standby - not sure exactly what version that was fixed. On my database, if RMAN detects a log is still needed on the standby when the delete command runs, I get this message in the RMAN log: RMAN-08137: WARNING: archive log not deleted as it is still needed Regards, Brandon -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Walker, Jed S backup database plus archivelog delete input; This will delete the archivelogs that were backed up. If you're running DataGuard then this, in my experience, won't work and you have to use commands like T.J. provided. Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. -- http://www.freelists.org/webpage/oracle-l