What is Active Data Guard in Oracle 11g?

Oracle Active Data Guard, an option of Oracle Database 11g Enterprise Edition is a simple, high performance solution that protects your Oracle Database against planned and unplanned downtimes, by allowing you to offload resource workloads from your production database to one or more synchronized standby databases.

What are new features in 11g Data Guard?

In 11gR2, two additional features were added as part of Active Data Guard – doing incremental backups on the physical standby with block change tracking enabled and automatic corrupt block detection and recovery.

How enable Active Data Guard in Oracle?

Steps to Enable Active Data Guard Option

Cancel The Redo Apply Process. SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Shutdown and start the database in Mount Mode.
Open the database in Read-Only Mode.
Start the Redo Apply. (
Now that the standby is in real-time query mode (the standby is open in read-only.

How do I know if my primary database has standby?

You can use the DGMGRL show configuration and show database database_name commands to confirm the Data Guard Standby database configuration before enabling a standby database. Here is how you enable your primary and standby databases using the DGMGRL command: DGMGRL> enable configuration; Enabled.

What is difference between Data Guard and Active Data Guard?

The main difference between Oracle Data Guard and Active Data Guard is that Oracle Data Guard is an extension to the Oracle RDBMS that provides data availability and protection while Active Data Guard is an extension of Oracle Data Guard that improves the production database performance for critical transactions.

Do we need license for Oracle Data Guard?

Data Guard is a feature of the Oracle Database Enterprise Edition itself and does not require separate licensing.

What is the difference between Active Data Guard and Data Guard?

What is active data guard in Oracle 11g?

Active Data Guard Licensing by Jeff Stonacek, Principal Architect In Oracle Database version 11g, a new feature called Active Data Guard (ADG) was introduced. This feature extends traditional Data Guard by allowing the standby database to continue to apply redo while remaining open for queries.

Are there any writes to the standby database in Active Data Guard?

Active Data Guard does not support any writes to the physical standby database. That said, it is possible that limited writes needed by the reporting application can be directed back to the primary database or to a local database that is on the same server as the standby database, using Oracle database links.

Is it free to use Active Data Guard?

Active Data Guard is not free, however. Active Data Guard carries a list price of $11,500 USD, and both the primary and standby databases must be licensed if they reside on different physical servers. The danger with Active Data Guard is that some of our customers open their standby databases and do not realize that ADG is in use.

How to set up Oracle Data Guard in cloud?

Set Up and Manage Oracle Data Guard using Oracle Enterprise Manager Cloud Control 12c Adding a Standby Database. Go to Targets..Databases on the Enterprise Manager Cloud Control 12c console, and select the… Menu Options for Data Guard. Move to the primary database’s Home page in Enterprise Manager

What is Active Data Guard in Oracle 11g?