RE: 11g RMAN backup archive logs, delete options

From: CRISLER, JON A (ATTCORP) <"CRISLER,>
Date: Wed, 18 May 2011 19:41:55 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD305B6AE_at_MISOUT7MSGUSR9D.ITServices.sbc.com>

I figured out a different method using a combination of CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DEVICE TYPE DISK APPLIED ON ALL STANDBY; delete archivelog all completed before 'sysdate -2';

But your method combines both into one statement which is nice.

From: LS Cheng [mailto:exriscer_at_gmail.com] Sent: Wednesday, May 18, 2011 3:22 PM
To: CRISLER, JON A (ATTCORP)
Cc: oracle-l_at_freelists.org
Subject: Re: 11g RMAN backup archive logs, delete options

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<mailto: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:41:55 CDT