Oracle GoldenGate 12c Overview & Components: Manager | Extract | Collector | Replicat | Data Pump
This post covers Overview and Components of Oracle GoldenGate (programming for constant information reconciliation and replication in heterogeneous IT Systems).
Oracle Goldengate is an unquestionable requirement know for DBAs and comprises of following parts:
Chief
Concentrate
Information Pump
Gatherer
Replicat
Trails Files
1. Extract
Ooracle GoldenGate extricate measure dwells on the source framework and catches the submitted exchanges from the source information base. The DB logs may contain submitted just as uncertain information at the same time, recollect, extricate measure catches just dedicated exchanges and keep in touch with them to nearby path documents. Note that Extract catches just the submitted exchange from its information source.
The concentrate can be arranged for any of the accompanying purposes:
Beginning Load: For the Initial Load strategy for replication, separate catches a static arrangement of information legitimately from the source table or articles.
Change Synchronization: In this strategy for replication, remove measure constantly catches information (DML and DDL) from the source information base to keep the source and target data set in a predictable condition of replication and it is sole technique to actualize consistent replication between the source and target information base.
The information wellspring of the concentrate cycle could be one of the accompanying
Source table (if the concentrate is designed for starting burden)
The information base exchange logs or recuperation logs, for example, (Oracle Redo Logs, Oracle Archive Logs, or SQL review trails or Sybase exchange logs) contingent upon the kind of source data set.
Outsider catch module can likewise be utilized to remove value-based information from the source data set. In this strategy, the information and metadata from an outside API are passed to the concentrate API.
Concentrate catches changes from source information base dependent on the concentrate design (contains the items to be reproduced from the source data set).
Various concentrate cycles can be designed on a source information base to work on same/diverse source objects.
The concentrate performs both of the accompanying undertakings in the wake of separating the information/records from the source information base articles.
Conveys the information removed from source to the objective worker Trail Files through gatherer measure
Composes the information removed from source on to the Local Trail Files on source framework
Alternatively, Extract can likewise be arranged to perform information separating, change and planning while at the same time catching information or potentially prior to moving the information to the objective framework.
