Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN "delete obsolete" behavior
More info on this. This is a BUG in 9.2.0.1.0 and fixed in 9.2.0.2.
Bug# is 2458246.
RF
-----Original Message-----
To: Multiple recipients of list ORACLE-L
Sent: 5/6/2003 4:51 PM
Paul - Which Oracle version? Makes a big difference on RMAN. Freeman's
book
says this command doesn't exist in 8i, so you must be on 9i.
According to the manual,
DELETE OBSOLETE - Deletes those files that are no longer needed for recovery.
Never used it myself. Just browsing Freeman again, have you configured a
retention policy?
Sorry I'm not being much help on this one. Maybe someone else will.
Dennis Williams
DBA, 60%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Tuesday, May 06, 2003 3:52 PM
To: Multiple recipients of list ORACLE-L
Given:
configure default device type to disk;
configure device type disk parallelism 1;
configure datafile backup copies for device type disk to 2;
configure archivelog backup copies for device type disk to 2;
configure channel 1 device type disk format
'f:\backup\t02a_%U','g:\backup\t02a_%U';
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to
'f:\backup\controlfile\%F';
configure retention policy to recovery window of 7 days;
And a script:
backup database ;
backup archivelog all delete all input;
delete obsolete;
The "delete obsolete" deletes the automatic controlfile/spfile backup that was just created, leaving me with none. Is this correct behavior? How can I prevent it?
TIA, Paul Baumgartel
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue May 06 2003 - 17:49:37 CDT