Received: (qmail 17541 invoked from network); 7 Jul 2011 10:16:02 -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:15:59 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8B3A0E32C1F;
 Thu,  7 Jul 2011 11:15:57 -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 QqGFBLiXI3t9; Thu,  7 Jul 2011 11:15:57 -0400 (EDT)
Received: from turing.freelists.org (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EA565E32B9D;
 Thu,  7 Jul 2011 11:15:14 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 07 Jul 2011 11:14:32 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])	by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 58762E301DD	for <oracle-l@freelists.org>; Thu,  7 Jul 2011 11:14:32 -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 PcONS6458gow for <oracle-l@freelists.org>;	Thu,  7 Jul 2011 11:14:32 -0400 (EDT)
Received: from mail.pti-nps.com (mail.pti-nps.com [12.43.85.103])	by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B2C6EE32480	for <oracle-l@freelists.org>; Thu,  7 Jul 2011 11:14:30 -0400 (EDT)
Received: from DEEDS.pti-nps.com ([172.16.235.25]) by mail.pti-nps.com with Microsoft SMTPSVC(6.0.3790.4675);	 Thu, 7 Jul 2011 10:14:29 -0500
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
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
Subject: RE: rman - backup plus archivelog
Date: Thu, 7 Jul 2011 10:14:28 -0500
Message-ID: <0EC85B1F3B2DF8409BF66DC182F495D9859206@DEEDS.pti-nps.com>
In-Reply-To: <8AE45871F749FC4CBBE053CF2F8A493C0A6F8C8F@XMBVAG74.northgrum.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: rman - backup plus archivelog
References: <8AE45871F749FC4CBBE053CF2F8A493C0A6F8C8F@XMBVAG74.northgrum.com>
From: "TJ Kiernan" <tkiernan@pti-nps.com>
To: <peter.schauss@ngc.com>,
 <oracle-l@freelists.org>
Cc: "TJ Kiernan" <tkiernan@pti-nps.com>
X-OriginalArrivalTime: 07 Jul 2011 15:14:29.0121 (UTC) FILETIME=[90FF6F10:01CC3CB8]
X-archive-position: 37283
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: tkiernan@pti-nps.com
Precedence: normal
Reply-To: tkiernan@pti-nps.com
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:steve.adams@ixora.com.au>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l

RMAN will back up any archivelogs it expects to see.  If you want to delete archivelogs after you've backed them up, do it with RMAN.
Add something like this to your backup script:

delete noprompt archivelog all backed up <N> times;

Thanks,
T. J.
 


-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Schauss, Peter (ESS)
Sent: Thursday, July 07, 2011 10:04 AM
To: oracle-l@freelists.org
Subject: rman - backup plus archivelog

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


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