RE: RMAN delete obsolete

From: Taylor, Chris David <>
Date: Mon, 14 Dec 2009 12:12:38 -0600
Message-ID: <>

I thought you had to specify "DELETE ALL INPUT" to delete ArchiveLogs. (or DELETE ALL INPUT

I didn't' think the "DELETE OBSOLETE" did anything with archivelogs? (I'm assuming here he's talking about ARCHIVELOGS in the LOG_ARCHIVE_DEST_ destination, NOT backed up ArchiveLogs in the RMAN destination)

For example (a portion of our script):

run {
backup as COMPRESSED BACKUPSET tag '%TAG' database; backup as COMPRESSED BACKUPSET tag '%TAG' archivelog all not backed up 2 times; delete noprompt archivelog until time 'sysdate -1'; <<-- This deletes from disk the archivelogs right? release channel oem_backup_disk1;
release channel oem_backup_disk2;
allocate channel for maintenance type disk; delete noprompt obsolete device type disk;

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium. From: [] On Behalf Of David Barbour Sent: Monday, December 14, 2009 11:42 AM To:
Subject: Re: RMAN delete obsolete

Delete obsolete depends on your retention policy parameters, so you can't specify what precisely you want to delete in terms of archivelogs/backupsets.

You could get the relevant information (maybe, depends on what you're trying to accomplish) by spooling a 'report obsolete' then editing the list and using it as the input for a a subsequent delete command. On Mon, Dec 14, 2009 at 12:18 PM, Roger Xu <<>> wrote:

Does anybody know how to make RMAN (delete obsolete) only deletes backupsets only (not archived log files)? Thank, Roger

Received on Mon Dec 14 2009 - 12:12:38 CST

Original text of this message