ADG

Oracle Active Data Guard Option

This is a cost option for Oracle Enterprise Edition

Features

Data Guard

  • Snapshot Standby
  • Fast-start failover
  • Automatic Block Repair
  • Far Sync
  • Disaster recovert to multiple stabdbys
  • Physical or Logical standby
  • Broker

Active Data Guard

  • Real-time Query (Enables a physical standby to be open read-only while Redo Apply is active)
  • RMAN block change tracking on a physical standby database

Advanced Compression

  • Data Guard Redo Transport compression

Logical Standby

  • read/write access to a synchronized standby database (but do not modify primary data)
  • add local tables top the standby database
  • create additional indexes to optimize read performance
  • Transient Logical Stabdby for upgrades

Check Feature Usage

SET LINESIZE 200

SELECT u1.name, u1.detected_usages

FROM dba_feature_usage_statistics u1

WHERE u1.version = (SELECT MAX(u2.version)

FROM dba_feature_usage_statistics u2

WHERE u2.name = u1.name

AND u1.name LIKE 'Active Data%')

ORDER BY u1.name;

If the detected usages for "Active Data Guard - Real-Time Query on Physical Standby" is non-zero, then you need a Active Data Guard option license.