RE: RMAN delete obsolete

Oooops...Left off part of the message:

I thought you had to specify "DELETE ALL INPUT" to delete ArchiveLogs. (or 
DELETE ARCHIVELOG UNTIL TIME... or some other combination)

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;

If he's talking about archivelog backups then I retract the above statements.



Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx>

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: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Taylor, Chris David
Sent: Monday, December 14, 2009 12:13 PM
To: 'david.barbour1@xxxxxxxxx'; 'wellmetus@xxxxxxxxx'
Cc: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: RMAN delete obsolete

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
Email: chris.taylor@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx>

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: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of David Barbour
Sent: Monday, December 14, 2009 11:42 AM
To: wellmetus@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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 
<wellmetus@xxxxxxxxx<mailto:wellmetus@xxxxxxxxx>> wrote:

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

Other related posts: