Re: RMAN Catalog Implicit Resync
Date: Thu, 6 Aug 2020 11:10:23 +0100
Message-ID: <CAA0QMt=cWZCD=zdT2KMdBf5EKQ=ZhVRRD05xTYFOQgVJ9+pZcQ_at_mail.gmail.com>
Hello,
can you equate anything like archivelog backup or your browsing sessions to
the timestamps for
"periodically updated over the course of the day"
I'd also try running SQL*PLUS queries on the catalog rather than RMAN list
commands,
that'd cut out one source of implicit resync.
Regards,
Frank
On Mon, Aug 3, 2020 at 8:22 PM Charlotte Hammond < dmarc-noreply_at_freelists.org> wrote:
> Hello!
>
> What causes an implicit resync of the RMAN catalog? I had thought it was
> significant events like running backups or deleting backup pieces. However
> I've been using RMAN today, connected to the catalog, just browsing but I
> can see that the catalog has periodically updated over the course of the
> day.
>
> This shouldn't be a problem of course, but we have a legacy utility that
> runs a duplicate from backups without specifying the SCN. In this case the
> SCN seems to be plucked from the highest SCN in the AL table. This is
> fine if the AL table isn't updated outside of backups but otherwise it ends
> up with SCNs from more recent archive logs which aren't in the backup and
> so the duplicate fails.
> Any workarounds without hacking at the fragile old duplicate utility to
> force it to use a specific SCN or time?
>
> Thank you in advance for any advice! (Oracle 11.2)
>
> Charlotte
>
>
>
>
-- +353-86-0695383 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 06 2020 - 12:10:23 CEST