Earlier versions of Oracle 11g standby databases have limitations as they can be used either for a recovery purpose or for a read-only purpose without recovery. From 11gR1 onwards, Oracle introduced more features, and standby databases can now work in recovery even in an open status. While recovery is in progress, real-time data can be accessible to the users just as production data is. Real time query can be used if Oracle Active Data Guard option has been purchased. Apart from that, some additional benefits of Active Data Guard are as follows:
You can use applications on Active Data Guard and the additional processing from the production can be reduced so that both primary and standby databases can be utilized.
If any ad-hoc jobs are running on Active Data Guard and if they don't meet the SLA provided by the
STANDBY_MAX_DATA_DELAYparameter using triggers, they can immediately be redirected to the primary database.Automatic block recovery. If there are any corrupted...
