Goldengate 12c 12.2 New features

GoldenGate 12.2 has been available for download, adding a lot of new features

1. Heterogeneous Configuration Enhancement
Do not need sourcedefs and assumetargetdefs files, in the queue file already contains metadata information, such as table name, column name, column type, and so on, further reduce ogg in the heterogeneous environment configuration of the workload ；

2. Built-in heart rate meter
In earlier versions of Ogg, if you were to monitor the delay state of a process, you would need to create a heart chart by hand, and now you can configure it to enable the Heartbeat monitor feature.
Add Heartbeattable in Ggsci. At this point, the Heartbeat configuration table and view are automatically created, and all OGG processes update the data every 60 seconds by default. One of the views created is Gg_lag, which has a field incoming_lag that can see the local DB commit time and latency at the remote DB post, and also supports bidirectional replication with a outgoing_lag field You can see the time difference between the source DB and the heartbeat time of the target DB received. Gg_heartbeat is the main configuration table, and the other views are basically created from this table, which has a record of the delay information for each component, including the extraction, transfer, and delivery processes. Therefore, it is easy to analyze the information on this table to know where the performance bottleneck is. Historical delay and heartbeat information are stored in the Gg_lag_history and Gg_heartbeat_history tables.

3. parameter file check-CHKPRM, info param, getparaminfo.
In 12.2, you can use CHECKPRM to check the legality of the parameters before starting the process;
Info param can return multiple information for a process, including default values, valid range of values, etc., equivalent to viewing Ogg's online help in Ggsci;
When a process is running, you can use Send procname getparaminfo to view the environment parameters of the process runtime, not only the parameters contained in the process, but also information such as other environment parameters required by the process to run, especially parameter variables that can be viewed at some runtime defaults.

4. Seamless integration with Oracle RAC.
In earlier versions of Ogg, using the grid Infrastructure Agent (XAG) to provide high availability in the RAC, you must use AGCTL to control the start and stop of Ogg and not to use start/stop commands in Ggsci. In 12.2, once the Ogg instance is registered with the RAC using the AGCTL command, we can still use the Start/stop command in Ggsci. At the same time, a new parameter can be used in the Globals parameter: xag_enable.

5. Added synchronization table and DataPump integration.
In earlier versions of Ogg, if you were to add a synchronized table, you would need to get the CURRENT_SCN value from V$database and then pass the SCN to the FLASHBACK_SCN parameter in expdb before using start Replicat, AFTERCSN Xxx. In 12.2, add trandata or add Schematrandata automatically prepares the status of these tables. EXPDP when exporting, the SCN is added to the corresponding table, in which case the DML and DDL operations prior to the SCN can be automatically filtered by simply using the dboptions_enable_instantiation_filtering parameter in the REPLICAT process.

6. Improved queue file Repair technology.
In earlier versions of Ogg, if a queue file was missing or corrupted, the delivery process failed. In 12.2, if the queue file is corrupted or missing, the transfer process can be restarted, at which point the queue file is rebuilt, and the same principle can be done by extracting the process to rebuild the source side of the queue file. The delivery process automatically filters out duplicate records that have already been posted.

7. Support Invisible (not visible) column.
The new mapinvisiblecolumns parameter in OGG 12.2 supports data replication for non-visible columns in Oracle DB.

8. Enhanced data measurement and performance monitoring.
Ogg 12.2 enables real-time measurements of the extraction, transfer, and delivery processes through RESTful Web service. Real-time database and queue statistics for the extraction and delivery processes, for queue and network statistics for the transport process. Here's how to access it:
Http://
The prerequisite is to add the enablemonitoring parameter to the Globals file.

9. GoldenGate Studio
In 12.2, there is a tool platform called Goldengate STUDIO, a graphical interface that helps to quickly configure and deploy Ogg. Use mouse clicks and drag to implement Ogg deployment without worrying about the underlying details. The idea of OGG Studio is that first there will be a project, and then there are multiple solutions, each of which includes multiple logical designs and multiple physical deployments. Ogg Studio already has multiple out-of-the-box scenario templates, such as cascading, bidirectional, unidirectional, one-to-many replication topologies, for faster Ogg deployments. Finally, OGG Studio allows the design to be deployed to multiple sets of environments, such as development, testing, QA, production, etc., with just one click.

Ten. GoldenGate Cloud Services
The Ogg cloud service will be public, cloud-based, or hourly. Ogg cloud services enable real-time data replication between enterprise intranet and cloud platforms, including Oracle DB and non-Oracle DB. The Ogg cloud service also supports the delivery of data to big data platforms such as Hadoop or NoSQL.

11.9-digit queue file.
In 12.2, the default queue file created is 9-bit numbers, not 6 bits from previous versions. This increases the number of queue files by 1000 times times, which is equivalent to supporting 1 billion files per queue prefix. At the same time, you can update the existing 6-bit file format to 9-bit, using the CONVCHK program under the installation directory, and of course, you can also add trail_seqlen_6d parameters in globals to provide a back-compatibility feature, that is, only 6 digits.

Goldengate 12c 12.2 New features