RMAN archivelogs are flagged as not obsolete after level 1 incrementals

From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Fri, 15 Jun 2018 16:07:23 -0500
Message-ID: <4c33dd37ab48f0668b28da359d54161d_at_society.servebeer.com>



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.

I'm not using a catalog if that matters (and the controlfile autobackup is on).

Thoughts? With an archive running, I realize that my FRA freespace is way lower than I'd like...

Thanks!
Rich

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 15 2018 - 23:07:23 CEST

Original text of this message