Re: Oracle 18c changed the checkpointing in a physical standby database (with the side effect of a bug).
From: Martin Klier - Performing Databases GmbH <martin.klier_at_performing-db.com>
Date: Fri, 27 Sep 2019 11:55:37 +0200 (CEST)
Message-ID: <417839394.1366.1569578137363.JavaMail.zimbra_at_performing-db.com>
Date: Fri, 27 Sep 2019 11:55:37 +0200 (CEST)
Message-ID: <417839394.1366.1569578137363.JavaMail.zimbra_at_performing-db.com>
Hi Rich,
for documentation, I did not find anything beyond this SR and the bug mentioned.
Maybe a PM can bring in more light, or we'd have to set up some tracing in the Frits Hoogland or Stefan Köhler style. :)
Stay safe
Martin
-- Martin Klier // Performing Databases GmbH Managing Partner // Senior DB Consultant Oracle ACE Director martin.klier_at_performing-db.com // https://www.performing-databases.comReceived on Fri Sep 27 2019 - 11:55:37 CEST
> Von: "Rich J" <rjoralist3_at_society.servebeer.com>
> An: "Oracle-L Freelists" <oracle-l_at_freelists.org>
> Gesendet: Mittwoch, 14. August 2019 15:14:40
> Betreff: Re: Oracle 18c changed the checkpointing in a physical standby database
> (with the side effect of a bug).
> On 2019/08/13 08:25, Martin Klier - Performing Databases GmbH wrote:
>> => They changed the way how checkpoints work for MRP (now different to primary) >> [ >> https://www.usn-it.de/2019/08/13/oracle-database-18c-changed-mrp-checkpointing-from-log-boundary-to-time-based/ >> | >> https://www.usn-it.de/2019/08/13/oracle-database-18c-changed-mrp-checkpointing-from-log-boundary-to-time-based/ >> ]
> Is that change in behavior documented? There's no mention of it in the "changes"
> section of [
> https://docs.oracle.com/en/database/oracle/oracle-database/18/sbydb/ |
> https://docs.oracle.com/en/database/oracle/oracle-database/18/sbydb/ ] But I
> did notice the few mentions of MRP now reference "Managed Redo Process" instead
> of "Media Recovery Process".
> But the reality is that this seems more than just a minor shift in how MRP
> works. The lack of documentation for such a fundamental change is disappointing
> at best. Thankfully, I'm working on replacing ADG soon...
> Thanks, Martin!
> Rich
-- http://www.freelists.org/webpage/oracle-l