Linux patching (OS security updates, kernel upgrades, etc.) is a routine activity for system administrators. For Oracle RAC environments, DBAs must ensure pre-patching checks, safe shutdowns, and post-patch relinks are properly executed to avoid service disruption. 1. Why Pre-Patching Checks Are Critical Before handing over the server to the Linux team, DBAs must: These pre-checks […]
When working with ROLLUP or CUBE, you’ll notice NULL values appear in subtotals and grand totals.But how do you tell the difference between a real NULL value in the data and a NULL that just means “subtotal here”? That’s where GROUPING_ID comes in. It returns a numeric code indicating which columns are aggregated (rolled up). […]
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 […]