RE: RMAN "delete obsolete" behavior

From: Freeman Robert - IL <FREEMANR_at_tusc.com>
Date: Tue, 06 May 2003 14:49:37 -0800
Message-ID: <F001.00591CD1.20030506144937@fatcity.com>

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

---

Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Paul Baumgartel
  INET: treegarden_at_yahoo.com

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Freeman Robert - IL
  INET: FREEMANR_at_tusc.com

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