From: "Walker, Jed S" <Jed_Walker@cable.comcast.com>
To: "tkiernan@pti-nps.com" <tkiernan@pti-nps.com>, "peter.schauss@ngc.com"	<peter.schauss@ngc.com>, "oracle-l@freelists.org" <oracle-l@freelists.org>
Subject: RE: rman - backup plus archivelog
Thread-Topic: rman - backup plus archivelog
Date: Thu, 7 Jul 2011 17:01:43 +0000
Message-ID: <BAA6E28B6241F046AED1E62D8697516C3B82B51A@COPDCEXMB08.cable.comcast.com>
References: <8AE45871F749FC4CBBE053CF2F8A493C0A6F8C8F@XMBVAG74.northgrum.com> <0EC85B1F3B2DF8409BF66DC182F495D9859206@DEEDS.pti-nps.com>
In-Reply-To: <0EC85B1F3B2DF8409BF66DC182F495D9859206@DEEDS.pti-nps.com>
Accept-Language: en-US
Content-Language: en-US
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: Jed_Walker@cable.comcast.com

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 <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


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