Received: (qmail 31291 invoked from network); 7 Jul 2011 12:29:25 -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:29:11 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3FF6CE32DAC; Thu, 7 Jul 2011 13:29:05 -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 lrS7hXt0y8DR; Thu, 7 Jul 2011 13:29:04 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 11B9CE3298B; Thu, 7 Jul 2011 13:28:21 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 07 Jul 2011 13:27:39 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F0EB2E32C42 for ; Thu, 7 Jul 2011 13:27:38 -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 ZQQjWjKqeLD6 for ; Thu, 7 Jul 2011 13:27:38 -0400 (EDT) Received: from mail-yw0-f51.google.com (mail-yw0-f51.google.com [209.85.213.51]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6E859E32D39 for ; Thu, 7 Jul 2011 13:27:35 -0400 (EDT) Received: by ywa8 with SMTP id 8so494790ywa.10 for ; Thu, 07 Jul 2011 10:27:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:cc:content-type; bh=/hhOTcxmG+0NabwJgrGfdu1XSx9RAoJC8cfrCAi90xU=; b=aDviUzx8+BzMdD9Emh5DnkeTpJl/HWdvIpxbACpVEbl/vwEnI+kfWbDS15CyVCJiZp 4wXq3V9zvdPD3euogIA2i14CtVfUBAwYEMiVwwmzUnflMJpSu10XAGeRWmdaUvxA8/uD TxTFxK7tM4FkyCvKZD8qk0LoAqKin/rWWNnI4= MIME-Version: 1.0 Received: by 10.236.184.165 with SMTP id s25mr1369404yhm.227.1310059653126; Thu, 07 Jul 2011 10:27:33 -0700 (PDT) Received: by 10.236.145.202 with HTTP; Thu, 7 Jul 2011 10:27:33 -0700 (PDT) In-Reply-To: References: <8AE45871F749FC4CBBE053CF2F8A493C0A6F8C8F@XMBVAG74.northgrum.com> <0EC85B1F3B2DF8409BF66DC182F495D9859206@DEEDS.pti-nps.com> Date: Thu, 7 Jul 2011 14:27:33 -0300 X-Google-Sender-Auth: BTJ7LANKmrvBcWcO659O223xiCs Message-ID: Subject: Re: rman - backup plus archivelog From: Guillermo Alan Bort To: Jed_Walker@cable.comcast.com Cc: "tkiernan@pti-nps.com" , "peter.schauss@ngc.com" , "oracle-l@freelists.org" Content-Type: multipart/alternative; boundary=20cf303f6bc64258a604a77e0842 X-archive-position: 37291 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: cicciuxdba@gmail.com Precedence: normal Reply-To: cicciuxdba@gmail.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 --20cf303f6bc64258a604a77e0842 Content-Type: text/plain; charset=ISO-8859-1 Did you ever run an archivelog backup? other than runniong backup database plus archivelog delete input; you can also run backup archivelog all delete input; which would essentially move the archivelogs into a backupset and thus make them available for a duplicate command. cheers Alan.- On Thu, Jul 7, 2011 at 2:01 PM, Walker, Jed S wrote: > Or simply > > 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. > > -----Original Message----- > From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] > On Behalf Of TJ Kiernan > Sent: Thursday, July 07, 2011 9:14 AM > To: peter.schauss@ngc.com; oracle-l@freelists.org > Cc: TJ Kiernan > Subject: RE: rman - backup plus archivelog > > 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 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 > > > -- > http://www.freelists.org/webpage/oracle-l > > > --20cf303f6bc64258a604a77e0842 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Did you ever run an archivelog backup?

other than runniong backup d= atabase plus archivelog delete input; you can also run backup archivelog al= l delete input; which would essentially move the archivelogs into a backups= et and thus make them available for a duplicate command.

cheers
Alan.-


On Thu, Jul 7, 2011 at 2:01 PM, Walker, = Jed S <Jed_Walker@cable.comcast.com> wrote:
Or simply

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.

-----Original Message-----
From: oracle-l-bounce@free= lists.org [mailto:orac= le-l-bounce@freelists.org] On Behalf Of TJ Kiernan
Sent: Thursday, July 07, 2011 9:14 AM
To: peter.schauss@ngc.com; oracle-l@freelists.org
Cc: TJ Kiernan
Subject: RE: rman - backup plus archivelog

RMAN will back up any archivelogs it expects to see. =A0If you want to dele= te 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.
=A0


-----Original Message-----
From: oracle-l-bounce@free= lists.org [mailto:orac= le-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 me= ssage that the backup contained no archivelogs. =A0The information on Metal= ink suggested using the command BACKUP DATABASE PLUS ARCHIVELOG. =A0When I = ran that rman asked for all of the archivelogs created since the database w= as created (luckily only a week and a half ago). =A0This despite the fact t= hat 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 c= reated during and after the backup.

Thanks,
Peter Schauss
--
htt= p://www.freelists.org/webpage/oracle-l


--
htt= p://www.freelists.org/webpage/oracle-l


--
htt= p://www.freelists.org/webpage/oracle-l



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