RE: 11g RMAN backup archive logs, delete options

  • From: "CRISLER, JON A (ATTCORP)" <JC1706@xxxxxxx>
  • To: LS Cheng <exriscer@xxxxxxxxx>
  • Date: Wed, 18 May 2011 19:41:55 +0000

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@xxxxxxxxx]
Sent: Wednesday, May 18, 2011 3:22 PM
To: CRISLER, JON A (ATTCORP)
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxx<mailto: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