In Oracle 19c, enhancements in the Data Guard Broker enable DBAs to set, reset, and display database initialization parameters directly through the broker interface. These commands allow parameter changes to take effect immediately on the active database (or standby, or Far Sync) without first editing the broker configuration file. This article explains these new commands, […]
Replication lag is one of the most important metrics for Cloud Ops DBAs managing Oracle Data Guard or other replication mechanisms in Oracle Cloud Infrastructure (OCI). Lag occurs when redo logs are not shipped or applied to the standby database in time, leading to potential data loss during failover. Monitoring lag helps ensure your standby […]
Below is a copy-paste ready Bash automation script that runs the Daily Data Guard Monitoring Checklist (OCI CLI + SQL*Plus), aggregates the results, and emails them to a distribution list. The script is written to be robust, modular, and suitable for scheduling via cron. Explanations and deployment notes follow the script so you can paste […]
Oracle Data Guard ensures high availability and disaster recovery for critical databases running in Oracle Cloud Infrastructure (OCI). For a Cloud Ops DBA, monitoring Data Guard daily is essential to ensure the primary and standby databases remain healthy, synchronized, and ready for switchover or failover. This blog provides a step-by-step daily monitoring checklist with commands, […]