Re: rman - backup plus archivelog

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 <Jed_Walker_at_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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of TJ Kiernan
> Sent: Thursday, July 07, 2011 9:14 AM
> To: peter.schauss_at_ngc.com; oracle-l_at_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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Schauss, Peter (ESS)
> Sent: Thursday, July 07, 2011 10:04 AM
> To: oracle-l_at_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
>
>
>

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