Re: RMAN archivelogs are flagged as not obsolete after level 1 incrementals

On 2018/06/15 16:07, Rich J wrote:

> Hey all,
>
> In 11.2, I have an incremental RMAN backup strategy with a level 0 done on Sunday and level 1 done every other day of the week, with archive logs running every 15 minutes. Retention is set to a "RECOVERY WINDOW OF 1 DAYS".
>
> Why are the archive logs older than 1 day not considered obsolete? My understanding is that a complete (or recent PIT) recovery would be:
>
> - Restore level 0
> - Recover all level 1 backups
> - Recover archive logs since last level 1
>
> So, why are the older archive logs not obsolete? I see keeping at most 2 days, but there are currently 5+ days in the FRA.

A deeper MOS search found 1922901.1, which states that block media recovery can't use level 1 backups, so archive logs are kept from the last level 0.

Which is a bit disappointing, to say the least.

Looks like I get to manually maintain my FRA for a few weeks while our archiving runs. Fun!

Rich

--
http://www.freelists.org/webpage/oracle-l