Re: rman expired vs obsolete

Hi!

Expired backups are unusable since they were not found accessible during last crosscheck or were set to expired state manually. This means that these backups can't and won't be used for restore operation.

Obsolete backups can be deleted since there are enough redundant backups according to current backup retention policy. If an obsolete backup is not manually deleted yet, it can be used for restore, unlike expired backups. Backup retention policy can be changed using rman's "configure" command.

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, January 23, 2004 9:59 PM

> Hi,
>
> I'm getting a little confused between expired backups and obsolete
backups.
> As I understand it, expired means the backups are no longer on disk.
> Obsolete means the backup is too old(?).
>
> Since I have a data ware house, I only have room on disk for 1 backup.
> Prior to running my weekly backup, do I issue a Delete Expired or Delete
> Obsolete, to remove last weeks backup that is currently on disk.
>
> Thanks
> Randy
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Steiner, Randy
> INET: RASTEIN_at_NYCT.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: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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