RE: RMAN delete obsolete
- From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- To: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>, "'david.barbour1@xxxxxxxxx'" <david.barbour1@xxxxxxxxx>, "'wellmetus@xxxxxxxxx'" <wellmetus@xxxxxxxxx>
- Date: Mon, 14 Dec 2009 12:15:47 -0600
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:
