Golden Gate Overview

Overview:

2. What is it? Oracle GoldenGate provides real-time, low-impact capture, routing, transformation, and delivery of transactional data across heterogeneous environments.
   1. Non-intrusive:
      1. No triggers, no intermediate tables, no delta tags or timestamp fields
      2. Do not query data on the source table
   2. Low impact:
      1. CPU utilization <3%, low memory and network bandwidth requirements when directly deployed and running on the source-side data server
   3. High Real-time:
      1. Single data synchronization link can maintain >160gb/hours of database log processing capacity, synchronization delay within 10 seconds
   4. Heterogeneous sources and targets:
      1. Wide range of different database types and versions under heterogeneous hardware platforms and operating systems, including file and Message Queuing
   5. Reliability and transactional Integrity:
      1. Ensure transactional integrity and sequencing
      2. Automatically recovers from breakpoints after failure, data is not duplicated, not omitted
4. Application Scenarios:
   1. Heterogeneous sources:
      1. Log-based, real-time crawling
      2. Message Bus
   2. Goal:
      1. 0 Downtime migration upgrade, disaster recovery emergency: New Db/os/hw/app
      2. Flexible high Availability: a fully active distribution database
      3. Query Offload/split: Reporting Database
      4. Oracle's ETL scenario, ODI
      5. Real-time bi/real-time Dw:edw
      6. Data distribution: Multiple data centers
      7. Soa/eda:message BUS:BPM/BAM/CEP
   3. Characteristics:
      1. Standardized, single technology to address a wide range of different needs
      2. Domestic: The main scenario is used for the continuous availability of the system and the requirements of real-time data access for reporting/BI systems.
      3. High added value, high flexibility, good stuff!
      4. If you apply the specification on the basis of an in-depth understanding of OGG, you will avoid frequent abend.
6. Fundamentals: Real-time incremental data integration based on log capture technology
   1. Capture extract: The transaction log is read to capture (or filter) committed transactions when a transaction occurs. Any non-actual transactions are not copied to the target, and no propagation errors are guaranteed.
   2. Queue Trail: Prepares the data to queue the data for routing. This is also called Trail file.
   3. Transfer pump: Distributes data for routing to destinations, enabling multiple deliveries to be captured at once.
   4. Routing Tcpip: Compresses, encrypts data for routing to destinations, minimizes bandwidth consumption. (1/10 higher compression ratio)
   5. Delivery Replicat: Ensure transactional data integrity and transform data as needed.
8. Reliability:
   1. Ensure transactional integrity
   2. Goldegate of The Fault
      1. Process automatic restart with process failure
      2. Trail File Failure ––> Checkpoint
   3. Faults outside of Goldengate
      1. Server/db/Network fault –> Checkpoint
10. Flexibility: Data processing, flexible topology, heterogeneous support, flexible installation configuration
    1. Components that can be configured with Filter/map and translation rules
       1. Capture
       2. DataPump
       3. Replicat
    2. The installation of each component is flexible and different from other products;
    3. The configuration of each component is also flexible, as long as trail files, checkpoint information in, how to play on how to play!
12. Topological structure
    1. Analytical type:
       1. One-way, query shunt
       2. Merge, real-time bi, three-to-one
       3. integration, integration, real-time Data Warehouse ods--"EDW; three pairs one on one. Oltp-ods-edw
    2. Operation Type:
       1. Bidirectional, 1 to 1
       2. Broadcast, 1 to many
       3. Equivalence, load balancing, triangular bidirectional
       4. Cascade, distributed business; one to one, then to three.
14. Product line:
1. Oracle Goldengate (all installations require LICENSE,RAC each node requires license)
2. Management Pack for Goldengate
1. Director
2. Monitor
3. EM12C Plug-in
3. Goldengate Veridata (cannot be separated from the OGG environment)
4. Goldengate Application Adapter
16. Product Download:
1. support.oracle.com-11g Patch is the installation package (12c not)

Golden Gate Overview