Home IT Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Oracle GoldenGate Installation and Configuration Tutorial Introduction     - Using 30 seconds to write a detailed analysis of garbage removal system (Linux)

- RedHat6.4 installation tutorial --- Minimal Edition (Linux)

- Setting Derby as Linux / Windows running as a service from the start (Server)

- W and uptime command (Linux)

- Spring multi data source configuration (Programming)

- E: Sub-process / usr / bin / dpkg returned an error code (1) error solution (Linux)

- Linux landing problem (Linux)

- Use Pylint regulate your Python code (Programming)

- Linux installation and configuration curl command tool (Linux)

- Through eight skills to let you become a super Linux end-user (Linux)

- Linux server dual-card dual-IP and single-card dual-IP configuration method (ReHat / CentOS) (Server)

- Configuring the PXE server in Ubuntu 14.04 (Server)

- The istgt PSD on ported to Mac OS X (Linux)

- Linux Getting Started tutorial: Experience KVM Virtual Machine chapter (Linux)

- Modify Linux terminal prompt path length (Linux)

- Java proxy mode (Programming)

- Sorting Algorithm (1) Quick Sort C ++ implementation (Programming)

- The difference between statement and preparedStatement of the jdbc (Database)

- Computer security protection remove local and remote system log files (Linux)

- LNMP Note: Addressing mail function can not send mail (Server)

  Oracle GoldenGate Installation and Configuration Tutorial Introduction
  Add Date : 2017-04-13      
  Oracle GoldenGate Introduction

GoldenGate software is based on the log-structured data replication software. GoldenGate enables a large number of transactions in real-time capture, transformation and delivery, data source and target database synchronization, data holding sub-second delay.

GoldenGate can support a variety of topologies, including one to one, one to many, many to one, and stacked bi-directional replication, etc.

Data replication topology are the following

Goldegate scenarios

A static extraction of data records from one database and the loading of those records
to another database.
Continuous extraction and replication of transactional DML operations and DDL
changes (for supported databases) to keep source and target data consistent.
Extraction from a database and replication to a file outside the database.
Architecture Overview

Oracle Goldengate consists of the following components

Data pump
Trails or extract files

Extract process used to capture the data source, there are three types

When configured for INITIAL LOAD mode, the data source for the table.
Recovery log database (also referred to some database transaction log).
Third-party capture model by calling Extact API to send data to the database changes Extract process.
Extract Data pump is optional auxiliary component, if not configured Data pump, Extract the captured data directly to the Collector process on the target machine.

Use Data pump can provide the following advantages

Prevent network or target side Collector fails to protect data loss.
data pump can be used to worry too much, data conversion, or configured Pass-through mode, ie without any action, but the delivery of data.
Start multiple Data pump-many data distribution (or a table of data, according to the type of data sent to a different destination system)
Replicat running on the destination server, the file data is read from the Trail Reconstruction DML, DDL statements, and apply it to the destination database. You can configure multiple Replicat, concurrent work to improve the throughput of the system.

Trail To support continuous capture, copy, alter database, Oracle database to capture changes recorded on a series of temporary disk file. The disk file is called Trail file.

A Trail Extract files can only be a write. Extract each process must be linked to a Trail file.

After Checkpoints When Goldengate process becomes corrupt, you can recover Goldengate instance.

Manager is to manage the process Goldengate.

Before Extract and Replicat start, you must start the Manager process on each node.

Manager has the following functions

Start Oracle GoldenGate processes
Start dynamic processes
Maintain port numbers for processes
Perform trail management
Create event, error, and threshold reports
Collector, the remote system to receive data transmission, and writes Trail file.

group overview

In order to distinguish between multiple systems or Replicat Extract process, we need to define treatment group

A group including the following

A process, Extract or Replicat
Its profile
Its checkpoint file
Associated with this process in any other documents.
Oracle GoldenGate Installation and Configuration Guide

Oracle GoldenGate must first download the installation package. Download the following address


The Oracle GoldenGate installation package uploaded to the server
Extracting archive

[Oracle @ localhost app] $ mkdir / u01 / app / ogg
[Oracle @ localhost app] $ unzip -d / u01 / app / ogg ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip
Archive: ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip
  inflating: /u01/app/ogg/fbo_ggs_Linux_x64_ora11g_64bit.tar
  inflating: /u01/app/ogg/OGG_WinUnix_Rel_Notes_11.
  inflating: / u01 / app / ogg / Oracle GoldenGate README.txt
  inflating: / u01 / app / ogg / Oracle GoldenGate README.doc
[Oracle @ localhost app] $ cd ogg /
[Oracle @ localhost ogg] $ tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar

Modify environment variables, add PATH, LD_LIBARY_PATH

[Oracle @ localhost ~] $ vi .bash_profile
export PATH = / u01 / app / ogg /: $ ORACLE_HOME / bin: $ PATH
export LD_LIBRARY_PATH = / u01 / app / ogg: $ ORACLE_HOME / lib: / lib: / usr / lib


Enter ogg installation directory, run the command ggsci

[Oracle @ localhost ogg] $ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version OGGCORE_11.
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14
Copyright (C) 1995, 2012, Oracle and / or its affiliates. All rights reserved.
GGSCI (localhost.localdomain) 1>

Create a working directory OGG

GGSCI (localhost.localdomain) 1> create subdirs
Creating subdirectories under current directory / u01 / app / ogg
Parameter files / u01 / app / ogg / dirprm: already exists
Report files / u01 / app / ogg / dirrpt: created
Checkpoint files / u01 / app / ogg / dirchk: created
Process status files / u01 / app / ogg / dirpcs: created
SQL script files / u01 / app / ogg / dirsql: created
Database definitions files / u01 / app / ogg / dirdef: created
Extract data files / u01 / app / ogg / dirdat: created
Temporary files / u01 / app / ogg / dirtmp: created
Stdout files / u01 / app / ogg / dirout: created

Process Manager configuration parameters

GGSCI (localhost.localdomain) 6> EDIT PARAMS MGR

Add the following communication port definition Manger process

- This is the minimal configuration of Manager
PORT 7809

- Followed by comments

Start Process Manager

GGSCI (localhost.localdomain) 14> start mgr
Manager started.

View Manager process

GGSCI (localhost.localdomain) 17> info mgr
Manager is running (IP port localhost.localdomain.7809).

Stop Process Manager

GGSCI (localhost.localdomain) 18> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y / n)? Y
Sending STOP request to MANAGER ...
Request processed.
Manager stopped.

If you ignore your profile

GGSCI (localhost.localdomain) 20> stop mgr!
Sending STOP request to MANAGER ...
Request processed.
Manager stopped.
- JIRA 3.6.2 Upgrade from older version to the new version 6.0.8 (Linux)
- Sudo and Root Account in Ubuntu related (Linux)
- Vim highlight lookup operation (Linux)
- MongoDB3.0.x version of the user authorization profile (stand-alone environment) (Database)
- Android custom ViewPager create kaleidoscopic image transition effects (Programming)
- systemctl Command Complete Guide (Linux)
- Linux install Maven and SVN client (Linux)
- To install Ganglia configuration of experience under CentOS 5.5 (Linux)
- Getting Started with Linux system to learn: how to check in a package is installed on Ubuntu (Linux)
- Java integrated development environment common set of operations (Linux)
- Install Debian Linux with R on the Android system (Linux)
- C ++ you can become a new scripting language (Programming)
- The signature can not be verified under Debian (Linux)
- RPM package management tools under Linux (Linux)
- Django Web dynamic three linkage (Programming)
- Linux Network Programming --epoll model Detailed principles and examples (Programming)
- CentOS 6 Install Xen4.2 Virtualization Practice (Linux)
- Analytical Ceph: handle network layer (Server)
- Linux, set and view environment variables (Linux)
- php for Linux the MySQL extension module installation and configuration (Database)
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.