Oracle GoldenGate系統之----安裝及使用

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檔案儲存