Ah ha! Thank you. I didn't think it could be right, since it didn't
delete the backupset it had just created.
PB
- Freeman Robert - IL <FREEMANR_at_tusc.com> wrote:
> 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).
>
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).
Received on Tue May 06 2003 - 18:26:50 CDT
