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

From: Vishnu <vishnukumarmp_at_gmail.com>
Date: Fri, 15 Jun 2018 17:24:38 -0400
Message-ID: <CABkZzkeYTnw+JqH4rwqfdbnfRoZbXriMgLKdKHTLkRV4=Zu-Lw_at_mail.gmail.com>



Hi Rich,

Can you do a restore preview and see whether the older archive logs (which you think that are not needed) are shown in the output as needed ? You can also do a crosscheck on archive log and see whether that fixes your problem during your next backup run.

Thanks,
Vishnu

On Fri, Jun 15, 2018 at 5:08 PM Rich J <rjoralist3_at_society.servebeer.com> 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.
>
> 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:24:38 CEST

Original text of this message