The Active Data Guard Option is an evolution of Data Guard technology that incorporates significant innovation (multiple patents pending) designed for a specific purpose - to improve production database performance for critical transactions. Active Data Guard enables read-only access to a physical standby database while Redo Apply is active. Queries and reports can be offloaded from the production system to a synchronized physical standby database - all queries at the standby database return up-to-date results. An Active Data Guard Option license must be purchased in addition to Oracle Enterprise Edition in order to utilize these new capabilities.
Active Data Guard and Oracle Data Guard 11g are related technologies, each having a different area of focus. Oracle Data Guard provides a comprehensive set of capabilities for data availability and protection that are included with Oracle Database Enterprise Edition.
|Capabilities and corresponding license requirements||Oracle Enterprise Edition 11g||Active Data Guard Option||Advanced Compression Option|
|All Data Guard 10g features||X|
|New Data Guard 11g features (excludes Active Data Guard and Advanced Compression features)||X|
|Real-time Query, enables a physical standby to be open read-only while Redo Apply is active||X|
|The ability to enable RMAN block change tracking on a physical standby database||X|
|Data Guard Redo Transport compression||X|
No. An Oracle Database Enterprise Edition license is the only license required to use Data Guard features other than those explicitly included with the Active Data Guard Option as described in the table above.
No - as long as you do not enable the Real-time Query feature or RMAN block change tracking on your physical standby database. Thus your physical standby database could be open read-only, but it cannot be applying redo at the same time. Similarly, you can perform RMAN incremental backups your physical standby, but you cannot perform fast RMAN incremental backups using RMAN block change tracking. You must only purchase the Active Data Guard Option if you wish to use either or both of these features.
Data Guard 11g has many new features that enhance its value for data protection and availability, and just as with previous Data Guard releases, these new features are included with Oracle Database Enterprise Edition at no extra charge.
Previous capabilities did not allow Redo Apply to be active while a physical standby database was open read-only, and did not enable RMAN block change tracking on the standby database. This resulted in (a) read-only access to data that was frozen as of the time that the standby database was opened read-only, (b) failover and switchover operations that could take longer to complete due to the backlog of redo data that would need to be applied, and (c) incremental backups that could take up to 20x longer to complete - even on a database with a moderate rate of change. Previous capabilities are still included with Oracle Data Guard 11g, no additional license is required to use previous capabilities.
Oracle RAC offers many advantages for scalability and high availability that are well understood and embraced by thousands of Oracle customers. Active Data Guard is designed to address a different requirement where customers wish to physically isolate the overhead of processing ad-hoc queries and reports from their OLTP system by using a completely independent, synchronized replica of the production database. If the customer requirement can be addressed using read-only access to an up-to-date replica of the production database, then Active Data Guard is an ideal solution.
If read-only access satisfies the requirement - Active Data Guard is a closer fit for the requirement, and therefore is much easier to implement than any other approach. Active Data Guard supports all datatypes and is very simple to implement. An Active Data Guard replica can also easily support additional uses - offloading backups from the primary database, serve as an open read-write test system during off-peak hours (Snapshot Standby), and provide an exact copy of the production database for disaster recovery - fully utilizing standby servers, storage and software while in standby role.
Use SQL Apply for the following requirements: (a) when you require read-write access to a synchronized standby database but do not modify primary data, (b) when you wish to add local tables to the standby database that can also be updated, or (c) when you wish to create additional indexes to optimize read performance. The ability to handle local writes makes SQL Apply better suited to packaged reporting applications that often require write access to local tables that exist only at the target database. SQL Apply also provides rolling upgrade capability for patchsets and major database releases. This rolling upgrade functionality can also be used by physical standby databases beginning with Oracle 11g using Transient Logical Standby.
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. For further details, refer to the Active Data Guard best practices paper on the MAA OTN site.
This is described in Metalink Note 454848.1 that details installation and usage of standby statspack.