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
点击(此处)折叠或打开
- UserExitExamples/
- UserExitExamples/ExitDemo_more_recs/
- UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.HPUX
- UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.SOLARIS
- UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.LINUX
- UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.AIX
- UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.vcproj
- UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.c
- UserExitExamples/ExitDemo_more_recs/readme.txt
- UserExitExamples/ExitDemo_passthru/
- UserExitExamples/ExitDemo_passthru/exitdemo_passthru.c
- UserExitExamples/ExitDemo_passthru/exitdemopassthru.vcproj
- UserExitExamples/ExitDemo_passthru/Makefile_passthru.HPUX
- UserExitExamples/ExitDemo_passthru/Makefile_passthru.AIX
- UserExitExamples/ExitDemo_passthru/Makefile_passthru.HP_OSS
- UserExitExamples/ExitDemo_passthru/Makefile_passthru.LINUX
- UserExitExamples/ExitDemo_passthru/readme.txt
- UserExitExamples/ExitDemo_passthru/Makefile_passthru.SOLARIS
- UserExitExamples/ExitDemo_lobs/
- UserExitExamples/ExitDemo_lobs/exitdemo_lob.c
- UserExitExamples/ExitDemo_lobs/Makefile_lob.HPUX
- UserExitExamples/ExitDemo_lobs/Makefile_lob.SOLARIS
- UserExitExamples/ExitDemo_lobs/Makefile_lob.AIX
- UserExitExamples/ExitDemo_lobs/exitdemo_lob.vcproj
- UserExitExamples/ExitDemo_lobs/Makefile_lob.LINUX
- UserExitExamples/ExitDemo_lobs/readme.txt
- UserExitExamples/ExitDemo_pk_befores/
- UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.AIX
- UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.LINUX
- UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.c
- UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.HPUX
- UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.vcproj
- UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.SOLARIS
- UserExitExamples/ExitDemo_pk_befores/readme.txt
- UserExitExamples/ExitDemo/
- UserExitExamples/ExitDemo/exitdemo.vcproj
- UserExitExamples/ExitDemo/Makefile_exit_demo.SOLARIS
- UserExitExamples/ExitDemo/Makefile_exit_demo.HP_OSS
- UserExitExamples/ExitDemo/exitdemo.c
- UserExitExamples/ExitDemo/Makefile_exit_demo.LINUX
- UserExitExamples/ExitDemo/exitdemo_utf16.c
- UserExitExamples/ExitDemo/Makefile_exit_demo.HPUX
- UserExitExamples/ExitDemo/Makefile_exit_demo.AIX
- UserExitExamples/ExitDemo/readme.txt
- bcpfmt.tpl
- bcrypt.txt
- cfg/
- cfg/password.properties
- cfg/MPMetadataSchema.xsd
- cfg/jps-config-jse.xml
- cfg/ProfileConfig.xml
- cfg/mpmetadata.xml
- cfg/Config.properties
- chkpt_ora_create.sql
- cobgen
- convchk
- db2cntl.tpl
- ddl_cleartrace.sql
- ddl_ddl2file.sql
- ddl_disable.sql
- ddl_enable.sql
- ddl_filter.sql
- ddl_nopurgeRecyclebin.sql
- ddl_ora10.sql
- ddl_ora10upCommon.sql
- ddl_ora11.sql
- ddl_ora9.sql
- ddl_pin.sql
- ddl_purgeRecyclebin.sql
- ddl_remove.sql
- ddl_session.sql
- ddl_session1.sql
- ddl_setup.sql
- ddl_status.sql
- ddl_staymetadata_off.sql
- ddl_staymetadata_on.sql
- ddl_trace_off.sql
- ddl_trace_on.sql
- ddl_tracelevel.sql
- ddlcob
- defgen
- demo_more_ora_create.sql
- demo_more_ora_insert.sql
- demo_ora_create.sql
- demo_ora_insert.sql
- demo_ora_lob_create.sql
- demo_ora_misc.sql
- demo_ora_pk_befores_create.sql
- demo_ora_pk_befores_insert.sql
- demo_ora_pk_befores_updates.sql
- dirjar/
- dirjar/xmlparserv2.jar
- dirjar/fmw_audit.jar
- dirjar/jps-internal.jar
- dirjar/org.springframework.jdbc-3.0.0.RELEASE.jar
- dirjar/org.springframework.context-3.0.0.RELEASE.jar
- dirjar/jps-upgrade.jar
- dirjar/oraclepki.jar
- dirjar/org.springframework.transaction-3.0.0.RELEASE.jar
- dirjar/xstream-1.3.jar
- dirjar/jsr250-api-1.0.jar
- dirjar/org.springframework.beans-3.0.0.RELEASE.jar
- dirjar/ldapjclnt11.jar
- dirjar/spring-security-cas-client-3.0.1.RELEASE.jar
- dirjar/jps-manifest.jar
- dirjar/org.springframework.aspects-3.0.0.RELEASE.jar
- dirjar/identityutils.jar
- dirjar/org.springframework.aop-3.0.0.RELEASE.jar
- dirjar/jacc-spi.jar
- dirjar/jmxremote_optional-1.0-b02.jar
- dirjar/slf4j-log4j12-1.4.3.jar
- dirjar/jps-api.jar
- dirjar/slf4j-api-1.4.3.jar
- dirjar/identitystore.jar
- dirjar/jps-unsupported-api.jar
- dirjar/osdt_xmlsec.jar
- dirjar/org.springframework.orm-3.0.0.RELEASE.jar
- dirjar/jagent.jar
- dirjar/commons-codec-1.3.jar
- dirjar/jps-ee.jar
- dirjar/spring-security-taglibs-3.0.1.RELEASE.jar
- dirjar/log4j-1.2.15.jar
- dirjar/osdt_core.jar
- dirjar/spring-security-acl-3.0.1.RELEASE.jar
- dirjar/xpp3_min-1.1.4c.jar
- dirjar/spring-security-web-3.0.1.RELEASE.jar
- dirjar/spring-security-core-3.0.1.RELEASE.jar
- dirjar/spring-security-config-3.0.1.RELEASE.jar
- dirjar/jps-mbeans.jar
- dirjar/org.springframework.test-3.0.0.RELEASE.jar
- dirjar/jdmkrt-1.0-b02.jar
- dirjar/jps-common.jar
- dirjar/org.springframework.web-3.0.0.RELEASE.jar
- dirjar/jps-patching.jar
- dirjar/jps-wls.jar
- dirjar/commons-logging-1.0.4.jar
- dirjar/org.springframework.expression-3.0.0.RELEASE.jar
- dirjar/org.springframework.instrument-3.0.0.RELEASE.jar
- dirjar/monitor-common.jar
- dirjar/osdt_cert.jar
- dirjar/org.springframework.asm-3.0.0.RELEASE.jar
- dirjar/org.springframework.context.support-3.0.0.RELEASE.jar
- dirjar/org.springframework.core-3.0.0.RELEASE.jar
- dirprm/
- dirprm/jagent.prm
- emsclnt
- extract
- freeBSD.txt
- ggMessage.dat
- ggcmd
- ggsci
- help.txt
- jagent.sh
- keygen
- libantlr3c.so
- libdb-5.2.so
- libgglog.so
- libggrepo.so
- libicudata.so.38
- libicui18n.so.38
- libicuuc.so.38
- libxerces-c.so.28
- libxml2.txt
- logdump
- marker_remove.sql
- marker_setup.sql
- marker_status.sql
- mgr
- notices.txt
- oggerr
- params.sql
- prvtclkm.plb
- pw_agent_util.sh
- remove_seq.sql
- replicat
- retrace
- reverse
- role_setup.sql
- sequence.sql
- server
- sqlldr.tpl
- tcperrs
- ucharset.h
- ulg.sql
- usrdecs.h
- zlib.txt
-- 查看解压后的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文件保存
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/429786/viewspace-777422/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/429786/viewspace-777422/