Oracle has release new version of GoldenGate 12.3 in 18 August. This is very long awaited version – it postponed 2 or 3 times because of some very important new features. See some useful links for GoldenGate 12.3:
- We can download GoldenGate 12.3 here http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html
- Documentation is available here: http://docs.oracle.com/goldengate/c1230/gg-winux/docs.htm
New Features of GoldenGate 12.3
So there is list in release notes which describes new features of GoldenGate 12.3. Let’s talk a little bit about these features:
The most important and revolutionary feature is Microservices Architecture. Historically GoldenGate has the following architecture
Now we are switching to the following architecture:
GoldenGate becomes more service oriented and more manageable. Now we can use RESTFul interfaces to manage GG. There is one important point here – now we are in transition period. There are two version of GoldenGate during transition period – common and microservice-based. Now microservice based version is available for Oracle database only. So we should choose which version to use during installation.
We already have 3 types of replicat – classic, coordinated and integrated. All these replicat types have their own weak and strong sideS:
- Classic replicat is very simple and scalable but it is hard to manage it for large installations
- Coordinated replicat is simple to use, easy to manage? scalable but more complex. It doesn’t support schemas where foreign key are not disabled
- Integrated replicat is very clever and can work where foreign keys exists but it has some performance limitations especially if system has large transactions
Parallel replicat is a new variant of Replicat that applies transactions in parallel to improve the performance. It takes into account dependencies between transactions, similar to Integrated Replicat. The dependency computation, parallelism of the mapping, and apply is performed outside the database and can be off-loaded to another server. The transaction integrity is maintained in this process. In addition, parallel replicat supports the parallel apply of large transactions by splitting a large transaction into chunks and applying them in parallel. This is supported with Oracle Database only.
So it looks like best variant but only time will tell how weak or strong it is.
Integrated Replicat has been enhanced to allow you to replicate certain Oracle supplied PL/SQL procedures that cannot be replicated as DML or DDL. This requires that the source and target databases are Oracle Database 12c Release 2 (12.2) and later.
You can see partial list of PL/SQL packages replicated by GoldenGate.
Really GoldenGate doesn’t replicate package itself but replicates its actions. For example, replication of DBMS_DBFS_* will lead to calling same DBFS API commands on target system. Also this is very important for AQ replication – now it should be easy to migrate systems where AQ is used with zero downtime.
Automatic Conflict Detection and Resolution
You can configure and manage Oracle GoldenGate to automate conflict detection and resolution when it is configured in Oracle Database 12c Release 2 (12.2) and later. This feature create invisible columns in the table. This columns is filled automatically by Oracle Database 12.2+. Also Database creates tombstone log to support updates-delete conflicts. This feature is supported by Integrated Extract plus Integrated or Parallel Integrated Replicat.