As an Oracle DBA, while working upon high availability of your database you may come across various Oracle strategic capabilities that fall into categories of Oracle Replication. Oracle provides various technologies for replication like golden gate, streams, and active dataguard. Replication being the primary purpose of all the mentioned technologies, have different internal operational behavior. The purpose is to achieve maximum database availability, these mentioned technologies fully accommodate the requirement but internally there are differences at internal operational level. DBA must learn and understand functionality of both and know which technique can be used and in what scenario?
Let have some discussion over the differences between Oracle Active Dataguard and Oracle Golden Gate.
Oracle Active Dataguard is simple and the most economical solution for replication. The concept of active dataguard is super set of traditional dataguard. It offers real time data protection and availability. Here in active replication you can place your secondary database in read-only mode, where secondary database is available to users for limited usage like reporting and query offloading. Active Dataguard promises zero data loss across large distances without hampering performance. Other benefits to count on you can consider the capability of Active Dataguard to automatically repair the physical corruption without incurring any performance impact and availability of the dedicated servers. Using special purpose network devices Active Dataguard ensure minimal bandwidth utilizations. With Active Dataguard DBAs can reduce the planned downtime to much extent while migrating or upgrading databases.
Oracle Golden Gate is most advanced logical replication product from Oracle. This is especially well known for its cross-platform operating capabilities. Golden Gate provides wide range of options addressing customer’s number of replication needs. The basic principal it works up on is to capture online changes, distribute and deliver transactions across various secondary system. The secondary database in this configuration is available is read-write mode during replication and synchronizations, incurring additional overhead to maintain both database in same state. The beauty of Golden Gate lies in its capability to replicate the changes in heterogeneous IT environment taking into consideration all the components of IT along with various Database Management Systems. We can rely on the technology even in case of network outage between primary and secondary server located geographically at long distances. The recent release of product promises improved performance, reliability, consistency, conflict detections, data integrity etc.
It is really important to understand the feasibility of solution taking into consideration financial aspect of the organization while selecting appropriate solution. Below are some comparison points that can let us decide which technology can be used to meet our requirements:
1. Use of Secondary Server: if there is any need to update the secondary server, you can do with Golden Gate. Database is available in read-write mode and users can perform operation on the database. Whereas the database in case of Active Dataguard is open in read-only mode.
2. Supplemental Logging: With Active Dataguard you need not require to put on the supplemental logging for tables not having primary keys or unique indexes. Some configurations and settings with minimal performance overhead active dataguard handles most workload. Golden Gate compulsory requires supplemental logging tables with without primary key and unique indexes.
3. Maintenance & Migrations: Oracle Golden Gate provides the zero-downtime using 2way or bi-directional replication. Whereas there are some scenarios where reduced downtime for various planned activities is not possible with Active Dataguard.
4. Cross-Edition migrations & replication: Golden Gate ensures the cross-platform replication and migration with zero-downtime. Active Dataguard requires the configuration to have same editions of database on the same operating platform on both primary and secondary environment. That means any cross-platform migration or replication is not provided by Active Dataguard.
5. Version backward Compatibility: Golden Gate is flexible enough to support the previous releases for replicating data from newer version or release. That means data of Oracle 11g can be replicated on Oracle 10g database.
Depending upon the requirements we can chose the replication technology. Even though we see the two different technologies separately there are some high availability architecture where both can be used.