Re: 11g RMAN backup archive logs, delete options

From: LS Cheng <exriscer_at_gmail.com>
Date: Wed, 18 May 2011 21:22:02 +0200
Message-ID: <BANLkTing37eCuunVa74F2BbtL2TfAQ+k8g_at_mail.gmail.com>

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_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;
>
> }
>
>
>
> 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.
>

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

Received on Wed May 18 2011 - 14:22:02 CDT