What is Active Data Guard?
In the standard Oracle Data Guard setup, your standby database is like a spare tire in a trunk—valuable in an emergency, but otherwise just taking up space. Active Data Guard (ADG) changes that by taking the standby out of the trunk and putting it to work while the car is still driving.
It is an evolution of Data Guard that allows you to open your standby database for read-only access while it is simultaneously receiving and applying changes from the primary.
Without ADG, a physical standby must be in a "Recovery" state (closed) to apply redo data. If you want to run a report, you have to stop the recovery and open the database. While the report runs, the standby falls behind the primary.
With Active Data Guard:
The standby is open in READ ONLY mode.
The Redo Apply process runs in the background.
Users can run reports, and those reports see data that is current to the second.
Heavy reporting queries and "End of Month" batches can kill the performance of your production server. With ADG, you point your BI tools (Tableau, PowerBI, etc.) to the standby. Your primary database stays fast for transactions, and your reporting doesn't slow down the business.
Running an RMAN backup is CPU and I/O intensive. You can run your full database backups against the Active Standby. Since the standby is bit-for-bit identical to the primary, the backup is just as valid, but the "performance hit" happens on the standby server instead of production.
In Oracle 19c and later, ADG got even smarter. If a user accidentally tries to run an INSERT or UPDATE on the read-only standby, ADG doesn't just throw an error. It can redirect that write operation back to the primary, execute it there, and then wait for the change to be applied to the standby.
| Feature | What it does |
| Far Sync | Allows zero-data-loss protection over long distances by using a tiny "buffer" instance in between. |
| Block Media Recovery | If the primary finds a corrupt block on disk, it can automatically "reach out" to the standby and pull a healthy copy of that block to fix itself mid-stream. |
| Global Temporary Tables | Users on the standby can create and use temporary tables for reporting, even though the database is "read-only." |
It is important to note that while "Data Guard" is included with Oracle Enterprise Edition, Active Data Guard is a separate licensed option. You pay extra for the ability to open the standby while it's applying redo.
Peer Tip: If you are on a budget and don't need "real-time" data for reports, you can technically use standard Data Guard to open the standby for a few hours, run your reports, and then put it back into recovery mode to catch up. It’s manual and the data isn't live, but it doesn't require the ADG license.
| Feature | Standard Data Guard | Active Data Guard |
| Disaster Recovery | Yes | Yes |
| Standby State | Mounted (Closed) | Open (Read-Only) |
| Reporting | No (Unless recovery stops) | Yes (Real-time) |
| Automatic Block Repair | No | Yes |
| Backup Offloading | Yes (but limited) | Yes (Optimized) |
Active Data Guard turns a "cost center" (a server that just sits there) into a "business asset" (a server that handles half your workload). It is the preferred architecture for any company that needs 24/7 uptime and high-performance reporting.