Oracle Licensing

Oracle Active Dataguard Licensing

How Does Oracle Active Data Guard Licensing Work?

  • Separate License: A separate license from the Oracle Database is required.
  • Cost: USD 11,500 per processor or named user plus.
  • Nodes: Must be licensed on both primary and standby nodes.
  • License Matching: The number of licenses must match Oracle Database Enterprise Edition.
  • Core Factor Table: Used to determine license requirements based on cores.
  • Inclusions: This can be included in an Oracle Unlimited License Agreement (ULA).

What is Oracle Active Data Guard?

What is Oracle Active Data Guard?

Oracle Active Data Guard is a feature of the Oracle Database Management System that allows the creation and maintenance of a primary database’s secondary copies (standby databases).

These standby databases are continuously updated with changes from the primary database and can be used for disaster recovery, high availability, and offloading read-only workloads.

Active Data Guard also enhances performance by enabling operations such as backup and recovery on standby databases without affecting the primary database.

Key Features of Active Data Guard:

  • Physical Standby with Real-time Query: Enables read-only queries on the standby database.
  • Fast Incremental Backup on Physical Standby: Improves backup efficiency.
  • Automatic Block Repair: Repairs corrupted blocks automatically.
  • Active Data Guard Far Sync: Extends protection to remote standby databases.
  • Global Data Services: Manages distributed databases.
  • Real-Time Cascade: Cascades redo data to multiple standby databases.
  • Application Continuity: Ensures transaction continuity during planned outages.
  • Rolling Upgrade using Active Data Guard: Supports database upgrades without downtime.
  • Active Data Guard DML Redirection: (This feature is unavailable for Oracle Database 19c and later in authorized cloud environments.) It allows DML operations on standby databases.

Differences between Data Guard and Active Data Guard

Differences between Data Guard and Active Data Guard
  • Data Guard: Provides data availability and protection. It is included with the Oracle Database and does not require a separate license.
  • Active Data Guard: Enhances Data Guard by allowing read-only access to the standby database and offloading other operations. Requires a separate license.

Oracle Active Data Guard Licensing

Oracle Active Data Guard requires a separate license, costing USD 11,500 per processor or named user. It must be licensed on primary and secondary nodes, matching the number and metric of Oracle Database Enterprise Edition licenses.

The Oracle core factor table determines the required licenses based on the system’s core count. Active Data Guard can also be included in an Oracle Unlimited License Agreement (ULA).

FAQs

What is Oracle Active Data Guard?

Oracle Active Data Guard is a feature that creates and maintains standby databases for disaster recovery, high availability, and read-only workloads, continuously updated from the primary database.

How is Active Data Guard different from Data Guard?

Data Guard provides data availability and protection, which the Oracle Database includes. Active Data Guard enhances this by enabling read-only access and additional features, requiring a separate license.

Do I need a separate license for Active Data Guard?

Oracle Active Data Guard requires a separate license for primary and standby nodes.

How much does an Oracle Active Data Guard license cost?

The license costs USD 11,500 per processor or named user plus.

How do I determine the number of licenses needed?

The number of licenses is based on the number and metric of Oracle Database Enterprise Edition licenses, using the Oracle core factor table.

Can Active Data Guard be included in an Oracle Unlimited License Agreement (ULA)?

Yes, Oracle Active Data Guard can be included in an Oracle ULA.

What features does Active Data Guard provide?

Active Data Guard includes real-time query on physical standby, fast incremental backup, automatic block repair, far sync, global data services, real-time cascade, application continuity, rolling upgrade, and DML redirection (excluding Oracle Database 19c and later in authorized cloud environments).

What is the core factor table used for?

The core factor table helps determine the number of processor licenses required based on the system’s core count.

Can I use Active Data Guard for read-only workloads?

Active Data Guard allows offloading read-only workloads to standby databases, improving primary database performance.

Is there a difference in licensing Active Data Guard on cloud environments?

Active Data Guard DML redirection is unavailable for Oracle Database 19c and later releases in authorized cloud environments.

What types of operations can be offloaded to the standby database?

Operations like read-only queries, backups, and recovery tasks can be offloaded to the standby database.

Do I need to license primary and standby databases for Active Data Guard?

Yes, the primary and standby databases must be licensed for Active Data Guard.

Can Active Data Guard be used for disaster recovery?

Yes, one of the primary uses of Active Data Guard is disaster recovery, ensuring the standby database is ready to take over if needed.

What is the impact of using Active Data Guard on primary database performance?

By offloading read-only workloads and backup operations to the standby database, Active Data Guard helps improve the performance of the primary database.

Author

  • Fredrik Filipsson

    Fredrik Filipsson brings two decades of Oracle license management experience, including a nine-year tenure at Oracle and 11 years in Oracle license consulting. His expertise extends across leading IT corporations like IBM, enriching his profile with a broad spectrum of software and cloud projects. Filipsson's proficiency encompasses IBM, SAP, Microsoft, and Salesforce platforms, alongside significant involvement in Microsoft Copilot and AI initiatives, enhancing organizational efficiency.

    View all posts