Demands of Automation You can easily create an Oracle Data Guard Standby Database with the Database Configuration Assistant DBCA. That’s especially interesting if you have automation at work, and are not keen on configuring stuff all over the place. This is available in version 19c upwards. DBCA uses RMAN DUPLICATE FOR STANDBY with an auxiliary […]
Category: Data Guard
Godspeed, Pieter van Puymbroeck
Last Sunday, I got a miserable call, one that everybody fears: On July, 16th 2021, the Oracle Community lost one of its loveliest members and a valued contributor. We all lost an amazing human being. I lost a dear and trusted friend: Pieter van Puymbroeck, you passed away in one of your favourite spots – […]
Oracle Database 18c changed MRP checkpointing from log boundary to time-based
The gap The story started with an always-unpleasant alert log message: The reason Looking into v$archived_log: The log sequences 2306-2405 ARE applied on standby. And thus deleted by policy from the Fast Recovery Area. Okay, this explains the effect, but not the root cause. So we had to open a SR with Oracle Support. The […]