In the journey toward resilient, high-availability database systems, Oracle continually evolves. With Oracle 19c, Data Guard gains a set of refined features that strengthen standby operations, simplify recovery, and improve manageability. In this post, we’ll explore the key new Data Guard features introduced in Oracle 19c and their operational impact. 1. Automatic Flashback of Standby […]
In the high-stakes world of database reliability, disaster recovery must be validated before it’s ever needed. With Oracle 19c’s Fast-Start Failover (FSFO) feature, you gain powerful automation for failover scenarios under Data Guard. But how do you test failover logic without impacting your production setup? The answer lies in Observe-Only Mode, and that is the […]
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, […]
Ranking functions are part of SQL analytic functions and are widely used in reporting, analytics, and business intelligence. The most common ones are RANK, DENSE_RANK, and ROW_NUMBER. While they seem similar, their behavior differs when handling duplicate values. Let’s explore them through practical examples. Example 1: Ranking Employees by Salary within Each Department Here we […]