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@xxxxxxxxxxxxxxxxx>
  • To: rjoralist3@xxxxxxxxxxxxxxxxxxxxx
  • Date: Fri, 27 Sep 2019 11:55:37 +0200 (CEST)

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@xxxxxxxxxxxxxxxxx // https://www.performing-databases.com ;

Von: "Rich J" <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
An: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
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

Other related posts: