Re: 11g RMAN backup archive logs, delete options

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 19 May 2011 07:43:25 -0700
Message-ID: <BANLkTim7LHzE1V4-z2E6nTjepK=W4b4LEQ_at_mail.gmail.com>

On Wed, May 18, 2011 at 12:12 PM, CRISLER, JON A (ATTCORP) <JC1706_at_att.com>wrote:

> I want to combine the functions of deleting archive logs based on date
> AND that they have been backed up already. Is this possible ?
>
>
>
> For instance this will delete all the archive logs backed up (regulated by
> rman archive log deletion policy)
>
>
>
> Run {
>
> backup as compressed backupset
>
> archivelog all
>
> delete all input;
>
> }
>
> ...
>

Jon,

If you don't already know it, RMAN has a very useful feature for checking syntax
when playing with stuff like this

  $ORACLE_HOME/bin/rman checksyntax

Now run scripts and type commands - they just get parsed, not executed.

RMAN will tell you the syntax is OK, or raise an error.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

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

Received on Thu May 19 2011 - 09:43:25 CDT