Re: 11g RMAN backup archive logs, delete options

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: JC1706@xxxxxxx
  • Date: Thu, 19 May 2011 07:43:25 -0700

On Wed, May 18, 2011 at 12:12 PM, CRISLER, JON A (ATTCORP)
<JC1706@xxxxxxx>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

Other related posts: