Re: 11g RMAN backup archive logs, delete options

  • From: LS Cheng <exriscer@xxxxxxxxx>
  • To: JC1706@xxxxxxx
  • Date: Wed, 18 May 2011 21:22:02 +0200

DELETE NOPROMPT ARCHIVELOG ALL BACKED UP 1 TIMES TO DISK COMPLETED BEFORE
'SYSDATE - ${RETENTION_ARCH}';

On Wed, May 18, 2011 at 9: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;
>
> }
>
>
>
> This would delete archive logs-
>
>
>
> delete archivelog all completed before 'sysdate -7';
>
>
>
> What I am looking for is deleting them based on date, and that they have
> been backed up.
>

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2011