Oracle goldengate Learning-basic concepts and configurations

Oracle goldengate Learning-basic concepts and configurations (1)

a    goldengate introduction

Oracle Golden Gatesoftware is a log-based structured data replication backup software that parses the sourcedatabase online logs or archive logs to obtain incremental changes to the data, and then apply these changes to the target database, so that the real
the current source database synchronizes with the target database. Oracle Golden Gatecan be in the heterogeneousITinfrastructure, including almost a large number of data sub-second-level real-time replication between all common operating system platforms and database platforms,thus in can in the emergency system, online reporting, real-time Data Warehouse supply, transaction tracking, data synchronization, centralized/distribution, disaster recovery, numberapplications in multiple scenarios, such as library upgrades and porting, and dual business centers. Meanwhile,Oracle Golden Gatecan achieve aon one, the broadcast(One -to-many), Aggregation(Many-to-one), bidirectional, point-to-point, Cascade, and many other flexible topologies.

Second, the technical structure

As with traditional logical replication,Oracle GoldenGatethe principle of implementation is by extracting the source endof theRedo LogorArchive Log, and then throughTCP/IPpost to the target side, and finally parse the restore and put the movie app toTarget side, so that the target side to achieve the same-origin number synchronization. Below areoraclegoldengatetechnology frame.

650) this.width=650; "src=" Http://blog.chinaunix.net/attachment/201303/11/23582874_1362966829ceUd.png "width=" 700 "height=" 228 "style=" border:0px;/>

Iii. the OGG process

1. Manager Process

     manager process is goldengate goldengate

Report Errors and events, allocate data storage space, publish threshold reports, and more.

2. Extract Process

Extract runs on the source side of the database and is responsible for capturing data from the source-side data tables or logs.

3. Pump Process

   pump     Its role is if the source side uses a local trail file,  PUMP  The process will put trail In the form of a data block

This is usually the recommended way to send to the target side via the TCP/IP protocol . the essence of pump process is A special form of extract process, if trails file is not used,so is thatExtractafter extracting the data, the process is delivered directly to the target side.

4.Trail File

  for more efficient and more secure delivery of database transaction information from the source side to the target. GoldenGate introduced The concept of trail file. As mentioned earlier , after extract extracted the data ,GoldengateWill transform the extracted transaction information into aGoldenGateproprietary format of the file. ThenPumpresponsible for the source side of theTrailthe file is posted to the target side, so this file exists on both ends of the source and target. TrailThe purpose of the file exists is to prevent a single point of failure, persistent, and the use ofCheckpointsystem to record its read-write location, and if a failure occurs, the data can be based onCheckpointrecord the location to be re-transmitted.

5.replicat

   replicat Span style= "Color:rgb (0,0,0); font-family: ' The song Body '; > process, we also call it the application process. Run on the target side, which is the last trail The contents of the file and resolves it to dml ddl statement, then applied to the target

6.GGSCI

Ggsci is a GoldenGate software Command Interface the abbreviation,

    It offers a very rich   goldengate goldengate

III. application development structure, support platform and database

650) this.width=650; "src=" Http://blog.chinaunix.net/attachment/201303/11/23582874_1362966855ev0V.png "width=" 700 "height=" 376 "style=" border:0px;/>

650) this.width=650; "src=" Http://blog.chinaunix.net/attachment/201303/11/23582874_1362966872j37z.png "width=" 700 "height=" 397 "style=" border:0px;/>

This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1550649

Oracle goldengate Learning-basic concepts and configurations