RE: RMAN delete obsolete
Date: Mon, 14 Dec 2009 12:15:47 -0600
Message-ID: <C5533BD628A9524496D63801704AE56D379CDB4992_at_SPOBMEXC14.adprod.directory>
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_at_ingrambarge.com<mailto:chris.taylor_at_ingrambarge.com>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David
Sent: Monday, December 14, 2009 12:13 PM
To: 'david.barbour1_at_gmail.com'; 'wellmetus_at_gmail.com'
Cc: 'oracle-l_at_freelists.org'
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_at_ingrambarge.com<mailto:chris.taylor_at_ingrambarge.com>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Barbour
Sent: Monday, December 14, 2009 11:42 AM
To: wellmetus_at_gmail.com
Cc: oracle-l_at_freelists.org
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_at_gmail.com<mailto:wellmetus_at_gmail.com>> wrote:
Does anybody know how to make RMAN (delete obsolete) only deletes backupsets only (not archived log files)? Thank, Roger
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 14 2009 - 12:15:47 CST