Oracle database licensing

Oracle Active Data Guard Licensing

Oracle Active Data Guard is licensed as follows:

  • License Metric and Quantities: It must match the license metric and quantities of the Oracle Database Enterprise Edition license.
  • License on Both Environments: Oracle Active Data Guard should be licensed in primary and standby environments.
  • Cost: The license cost for Oracle Active Data Guard is $11,500 per processor

Oracle Active Data Guard Licensing

oracle active dataguard licensing
  • Oracle Active Data Guard is an add-on feature to the Oracle Database Enterprise Edition.
  • The usage of certain features included in Active Data Guard requires an additional license in addition to the Enterprise Edition license.
  • Active Data Guard is available in two licensing metrics: Named User Plus and Processor.
  • The quantity and licensing metric selected for Active Data Guard must match the database license upon which it will run.

What is Oracle Active Dataguard?

what is oracle active data guard

Oracle Active Data Guard (ADG) is a feature set that enhances your Oracle Database. Here’s a simple breakdown of what each feature does:

  1. Physical Standby with Real-time Query: This feature allows you to run queries on your standby database in real-time, enhancing data availability.
  2. Fast Incremental Backup on Physical Standby: This feature speeds up the backup process by only backing up changes made since the last backup.
  3. Automatic Block Repair: This feature automatically repairs corrupt data blocks in real-time, improving data reliability.
  4. Active Data Guard Far Sync: This feature provides a remote replication target for your primary database, ensuring data safety.
  5. Global Data Services: This feature manages global databases and workload balancing, improving performance and availability.
  6. Real-Time Cascade: This feature allows standby databases to receive redo data from the primary database or another standby database in real time, enhancing data protection.
  7. Application Continuity: This feature ensures that your applications continue to run even during database outages, enhancing application availability.
  8. Rolling Upgrade using Active Data Guard: This feature allows you to perform database upgrades with minimal downtime.
  9. Active Data Guard DML Redirection: This feature (unavailable in Authorized Cloud Environments) redirects DML operations to the primary database, ensuring data consistency.

Remember, in an Oracle Data Guard configuration, the primary database and any standby databases using any of these features must be licensed with Oracle Active Data Guard.

Standby databases that do not use any Oracle Active Data Guard features do not require an Oracle Active Data Guard license.

An Oracle Active Data Guard license is not required for customers who back up standby databases to Zero Data Loss Recovery Appliance (ZDLRA) and wish to use the Fast Incremental Backup on Physical Standby or Real-Time Cascade feature.

But, if any of the above features are in use, Oracle Active Data Guard must still be licensed on standby databases.

The standby database’s container root (CDB$Root) may be opened read-only without requiring an Oracle Active Data Guard license. However, an Oracle Active Data Guard license is required if any pluggable databases on standby are opened for reading.

By understanding these features and licensing requirements, you can effectively use Oracle Active Data Guard and ensure compliance with Oracle licensing.

What is the cost of Oracle Data Guard?

oracle active data guard license cost

Oracle Data Guard is a feature of Oracle Database that enhances data availability and protection. While the traditional Data Guard is free, the Active Data Guard option offers additional capabilities.

What benefits do Active Data Guard provide?

Active Data Guard allows you to run reports and other reporting activities on the standby database. This can be a great solution if you need near-real-time reporting and have separate physical servers.

What is the catch?

The downside is that Active Data Guard requires a separate license and comes with a license list price of USD 11,500.

How is Active Data Guard licensed?

Active Data Guard needs to be licensed on both the primary and the secondary nodes. You apply the Oracle core factor table, multiplying the number of cores with the core factor.

Let’s look at a licensing example:

Suppose you have a primary node with 4 Database Enterprise Edition processor licenses that cost $47,500 per processor. Then, you have a standby node with two Database Enterprise Edition processor licenses.

  1. The cost for the primary node would be 4 (processor licenses) * $47,500 = $190,000.
  2. The cost for the standby node would be 2 (processor licenses) * $47,500 = $95,000.
  3. The total Database Enterprise Edition licenses cost $190,000 (primary node) + $95,000 (standby node) = $285,000.

Now, let’s calculate the cost of an Active Data Guard. Remember, Active Data Guard needs to be licensed on both nodes:

  1. Active Data Guard on the primary node would cost 4 (processor licenses) * $11,500 = $46,000.
  2. Active Data Guard on the standby node would cost 2 (processor licenses) * $11,500 = $23,000.
  3. The total cost of Active Data Guard licenses would be $46,000 (primary node) + $23,000 (standby node) = $69,000.

So, the total cost for the Database Enterprise Edition and Active Data Guard licenses would be $285,000 + $69,000 = $354,000.

Read more about our Oracle License Management Services.

Do you want to know more about our Oracle License Management Services?

Please enable JavaScript in your browser to complete this form.
Author
  • 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, improving organizational efficiency.

    View all posts