Oracle GoldenGate（文中简称为OGG）是目前ORACLE主推的同构或异构数据库之间的同步软件之一。
以下主要介绍OGG在LINUX系统的安装及简单使用过程。

-- 上传OGG安装文件到服务器
[root@dg ~(23:56:19)]# su - oracle
[oracle@dg ~(23:56:23)]$ ls fbo*
fbo_ggs_Linux_x64_ora11g_64bit.tar

-- 创建OGG安装目标
[oracle@dg ~(23:56:27)]$ mkdir -p /home/oracle/ogg/11.2
[oracle@dg ~(23:56:47)]$ cd ogg/11.2/

-- 解压OGG安装文件到指定目录
[oracle@dg 11.2(23:56:55)]$ tar xvf ~/fbo_ggs_Linux_x64_ora11g_64bit.tar 

-- 查看解压后的OGG应用文件
[oracle@dg 11.2(23:57:12)]$ ls
bcpfmt.tpl                 ddl_session1.sql                 emsclnt            marker_status.sql
bcrypt.txt                 ddl_session.sql                  extract            mgr
cfg                        ddl_setup.sql                    freeBSD.txt        notices.txt
chkpt_ora_create.sql       ddl_status.sql                   ggcmd              oggerr
cobgen                     ddl_staymetadata_off.sql         ggMessage.dat      params.sql
convchk                    ddl_staymetadata_on.sql          ggsci              prvtclkm.plb
db2cntl.tpl                ddl_tracelevel.sql               help.txt           pw_agent_util.sh
ddl_cleartrace.sql         ddl_trace_off.sql                jagent.sh          remove_seq.sql
ddlcob                     ddl_trace_on.sql                 keygen             replicat
ddl_ddl2file.sql           defgen                           libantlr3c.so      retrace
ddl_disable.sql            demo_more_ora_create.sql         libdb-5.2.so       reverse
ddl_enable.sql             demo_more_ora_insert.sql         libgglog.so        role_setup.sql
ddl_filter.sql             demo_ora_create.sql              libggrepo.so       sequence.sql
ddl_nopurgeRecyclebin.sql  demo_ora_insert.sql              libicudata.so.38   server
ddl_ora10.sql              demo_ora_lob_create.sql          libicui18n.so.38   sqlldr.tpl
ddl_ora10upCommon.sql      demo_ora_misc.sql                libicuuc.so.38     tcperrs
ddl_ora11.sql              demo_ora_pk_befores_create.sql   libxerces-c.so.28  ucharset.h
ddl_ora9.sql               demo_ora_pk_befores_insert.sql   libxml2.txt        ulg.sql
ddl_pin.sql                demo_ora_pk_befores_updates.sql  logdump            UserExitExamples
ddl_purgeRecyclebin.sql    dirjar                           marker_remove.sql  usrdecs.h
ddl_remove.sql             dirprm                           marker_setup.sql   zlib.txt

-- 修改环境变量，添加以下两行
 [oracle@dg 11.2(23:58:16)]$ vi ~/.bash_profile

OGG_HOME=/home/oracle/ogg/11.2
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:$OGG_HOME; export LD_LIBRARY_PATH

-- 执行source ~/.bash_profile使环境变量生效

[oracle@dg 11.2(23:58:16)]$ pwd
/home/oracle/ogg/11.2

-- 执行ggsci进入OGG命令行管理
[oracle@dg 11.2(23:58:25)]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
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.

-- 创建OGG相关目录
GGSCI (dg) 1> create subdirs

Creating subdirectories under current directory /home/oracle/ogg/11.2

Parameter files                /home/oracle/ogg/11.2/dirprm: already exists
Report files                   /home/oracle/ogg/11.2/dirrpt: created
Checkpoint files               /home/oracle/ogg/11.2/dirchk: created
Process status files           /home/oracle/ogg/11.2/dirpcs: created
SQL script files               /home/oracle/ogg/11.2/dirsql: created
Database definitions files     /home/oracle/ogg/11.2/dirdef: created
Extract data files             /home/oracle/ogg/11.2/dirdat: created
Temporary files                /home/oracle/ogg/11.2/dirtmp: created
Stdout files                   /home/oracle/ogg/11.2/dirout: created

-- 查看所有进程运行状态
GGSCI (dg) 2> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED      
                                    

-- 编辑管理进程mgr
GGSCI (dg) 3> edit params mgr
PORT 7801

"dirprm/mgr.prm" [New] 1L, 10C written

-- 查看管理进程配置
GGSCI (dg) 4> view params mgr

PORT 7801

-- 启动管理进程
GGSCI (dg) 5> start mgr

Manager started.

-- 查看管理进程状态
GGSCI (dg) 6> info mgr

Manager is running (IP port dg.7802).

GGSCI (dg) 7> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          

[oracle@dg 11.2(23:58:47)]$ ls
bcpfmt.tpl                 ddl_setup.sql                    dirprm             marker_remove.sql
bcrypt.txt                 ddl_status.sql                   dirrpt             marker_setup.sql
cfg                        ddl_staymetadata_off.sql         dirsql             marker_status.sql
chkpt_ora_create.sql       ddl_staymetadata_on.sql          dirtmp             mgr
cobgen                     ddl_tracelevel.sql               emsclnt            notices.txt
convchk                    ddl_trace_off.sql                extract            oggerr
db2cntl.tpl                ddl_trace_on.sql                 freeBSD.txt        params.sql
ddl_cleartrace.sql         defgen                           ggcmd              prvtclkm.plb
ddlcob                     demo_more_ora_create.sql         ggMessage.dat      pw_agent_util.sh
ddl_ddl2file.sql           demo_more_ora_insert.sql         ggsci              remove_seq.sql
ddl_disable.sql            demo_ora_create.sql              help.txt           replicat
ddl_enable.sql             demo_ora_insert.sql              jagent.sh          retrace
ddl_filter.sql             demo_ora_lob_create.sql          keygen             reverse
ddl_nopurgeRecyclebin.sql  demo_ora_misc.sql                libantlr3c.so      role_setup.sql
ddl_ora10.sql              demo_ora_pk_befores_create.sql   libdb-5.2.so       sequence.sql
ddl_ora10upCommon.sql      demo_ora_pk_befores_insert.sql   libgglog.so        server
ddl_ora11.sql              demo_ora_pk_befores_updates.sql  libggrepo.so       sqlldr.tpl
ddl_ora9.sql               dirchk                           libicudata.so.38   tcperrs
ddl_pin.sql                dirdat                           libicui18n.so.38   ucharset.h
ddl_purgeRecyclebin.sql    dirdef                           libicuuc.so.38     ulg.sql
ddl_remove.sql             dirjar                           libxerces-c.so.28  UserExitExamples
ddl_session1.sql           dirout                           libxml2.txt        usrdecs.h
ddl_session.sql            dirpcs                           logdump            zlib.txt

相关目录及运行程序说明：

Parameter files                /home/oracle/ogg/11.2/dirprm -- 参数文件保存目录，如MGR管理进程
Report files                   /home/oracle/ogg/11.2/dirrpt -- 报告文件保存目录，OGG主要诊断手段之一，使用view report #GroupName查看报告
Checkpoint files               /home/oracle/ogg/11.2/dirchk -- 由Extract(抽取)或Replicat(应用)进程产生对应的CHECKPOINT文件，记录当前读写的位置
Process status files           /home/oracle/ogg/11.2/dirpcs -- 进程状态文件保存目录，记录当前运行进程的状态，进程名以大写显示
                                                                                -- 扩展名为pcm表示管理进程，pcr表示replicat进程，pce表示为extract进程
SQL script files               /home/oracle/ogg/11.2/dirsql -- SQL脚本保存目录
Database definitions files     /home/oracle/ogg/11.2/dirdef -- 由DEFGEN生成的数据库结构定义文件保存目录，主要用于异构数据库
Extract data files             /home/oracle/ogg/11.2/dirdat -- TRAIL文件和Extract(抽取)进程产生的文件默认目录
Temporary files                /home/oracle/ogg/11.2/dirtmp -- 由CACHE管理器分配,用于保存事务数据的目录
Stdout files                   /home/oracle/ogg/11.2/dirout -- 未使用，一般用于DISCARD文件保存