Embedded Files
Oracle Active Data Guard Option
Oracle Active Data Guard Option
This is a cost option for Oracle Enterprise Edition
Features
Features
Data Guard
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
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
Advanced Compression
- Data Guard Redo Transport compression
Logical Standby
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
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.
Page updated
Google Sites
Report abuse