Received: (qmail 16940 invoked from network); 7 Jul 2011 10:05:24 -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 10:05:22 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 43CB3E32D7F; Thu, 7 Jul 2011 11:05:09 -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 GobcTRlq5WlQ; Thu, 7 Jul 2011 11:05:09 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D4A3BE32D3D; Thu, 7 Jul 2011 11:04:25 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 07 Jul 2011 11:03:44 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7B496E32CD3 for ; Thu, 7 Jul 2011 11:03: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 vwXJe5oL-H2u for ; Thu, 7 Jul 2011 11:03:43 -0400 (EDT) Received: from northgrum.com (xspv0103.northgrum.com [134.223.120.78]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1F24CE32D12 for ; Thu, 7 Jul 2011 11:03:42 -0400 (EDT) Received: from ([134.223.80.11]) by xspv0103.northgrum.com with ESMTP with TLS id J8QJQN1.4044400; Thu, 07 Jul 2011 10:03:40 -0500 Received: from XHTVAG03.northgrum.com (134.223.82.53) by XHTV0002.northgrum.com (134.223.80.11) with Microsoft SMTP Server (TLS) id 14.1.289.1; Thu, 7 Jul 2011 10:03:39 -0500 Received: from XMBVAG74.northgrum.com ([169.254.2.246]) by XHTVAG03.northgrum.com ([134.223.82.53]) with mapi id 14.01.0289.001; Thu, 7 Jul 2011 10:03:39 -0500 From: "Schauss, Peter (ESS)" To: "oracle-l@freelists.org" Subject: rman - backup plus archivelog Thread-Topic: rman - backup plus archivelog Date: Thu, 7 Jul 2011 15:03:40 +0000 Message-ID: <8AE45871F749FC4CBBE053CF2F8A493C0A6F8C8F@XMBVAG74.northgrum.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [134.223.82.124] 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: 37282 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: peter.schauss@ngc.com Precedence: normal Reply-To: peter.schauss@ngc.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 Oracle 11.2.0.1.0 on AIX 5.3 I am backing up a database with rman in nocatalog mode. When I tried to test my backups using the rman DUPLICATE command I got a message that the backup contained no archivelogs. The information on Metalink suggested using the command BACKUP DATABASE PLUS ARCHIVELOG. When I ran that rman asked for all of the archivelogs created since the database was created (luckily only a week and a half ago). This despite the fact that that I had been backing it up daily without the PLUS ARCHIVELOG option. Now that rman has backed up the archivelogs, what will determine which ones it asks for the next time I run it? Ideally all that I need to restore a backup is the archivelogs which were created during and after the backup. Thanks, Peter Schauss -- http://www.freelists.org/webpage/oracle-l