去oracle下载对应的平台和数据库版本ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip解压到目录ogg
[oracle@irdexnew ~]# cd /opt/oracle/ogg
[oracle@irdexnew ogg]# ls
bcpfmt.tpl ddl_ora10upCommon.sql defgen freeBSD.txt libxml2.txt replicat
bcrypt.txt ddl_ora11.sql demo_more_ora_create.sql ggcmd logdump retrace
cfg ddl_ora9.sql demo_more_ora_insert.sql ggMessage.dat marker_remove.sql reverse
chkpt_ora_create.sql ddl_pin.sql demo_ora_create.sql ggsci marker_setup.sql role_setup.sql
cobgen ddl_purgeRecyclebin.sql demo_ora_insert.sql help.txt marker_status.sql sequence.sql
convchk ddl_remove.sql demo_ora_lob_create.sql jagent.sh mgr server
db2cntl.tpl ddl_session1.sql demo_ora_misc.sql keygen notices.txt sqlldr.tpl
ddl_cleartrace.sql ddl_session.sql demo_ora_pk_befores_create.sql libantlr3c.so oggerr tcperrs
ddlcob ddl_setup.sql demo_ora_pk_befores_insert.sql libdb-5.2.so OGG_WinUnix_Rel_Notes_11.2.1.0.1.pdf ucharset.h
ddl_ddl2file.sql ddl_status.sql demo_ora_pk_befores_updates.sql libgglog.so Oracle GoldenGate 11.2.1.0.1 README.doc ulg.sql
ddl_disable.sql ddl_staymetadata_off.sql dirjar libggrepo.so Oracle GoldenGate 11.2.1.0.1 README.txt UserExitExamples
ddl_enable.sql ddl_staymetadata_on.sql dirprm libicudata.so.38 params.sql usrdecs.h
ddl_filter.sql ddl_tracelevel.sql emsclnt libicui18n.so.38 prvtclkm.plb zlib.txt
ddl_nopurgeRecyclebin.sql ddl_trace_off.sql extract libicuuc.so.38 pw_agent_util.sh
ddl_ora10.sql ddl_trace_on.sql fbo_ggs_Linux_x86_ora11g_32bit.tar libxerces-c.so.28 remove_seq.sql
[oracle@irdexnew ogg]# ldd ggsci
linux-gate.so.1 => (0x00eea000)
/etc/libcwait.so (0x00be3000)
libdl.so.2 => /lib/libdl.so.2 (0x0036d000)
libgglog.so => /opt/oracle/ogg/libgglog.so (0x00570000)
libggrepo.so => /opt/oracle/ogg/libggrepo.so (0x00a52000)
libdb-5.2.so => /opt/oracle/ogg/libdb-5.2.so (0x00751000)
libicui18n.so.38 => /opt/oracle/ogg/libicui18n.so.38 (0x001fa000)
libicuuc.so.38 => /opt/oracle/ogg/libicuuc.so.38 (0x00371000)
libicudata.so.38 => /opt/oracle/ogg/libicudata.so.38 (0x00eeb000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00110000)
libxerces-c.so.28 => /opt/oracle/ogg/libxerces-c.so.28 (0x01dc8000)
libantlr3c.so => /opt/oracle/ogg/libantlr3c.so (0x00128000)
libnnz11.so => not found
libclntsh.so.11.1 => not found
libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x033b3000)
libm.so.6 => /lib/libm.so.6 (0x00138000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00d9f000)
libc.so.6 => /lib/libc.so.6 (0x008de000)
/lib/ld-linux.so.2 (0x001de000)
[oracle@irdexnew ogg]# export LD_LIBRARY_PATH=/opt/oracle/product/11g/lib
[oracle@irdexnew ogg]# ldd ggsci
linux-gate.so.1 => (0x005a7000)
/etc/libcwait.so (0x00319000)
libdl.so.2 => /lib/libdl.so.2 (0x0036d000)
libgglog.so => /opt/oracle/ogg/libgglog.so (0x00371000)
libggrepo.so => /opt/oracle/ogg/libggrepo.so (0x00e87000)
libdb-5.2.so => /opt/oracle/ogg/libdb-5.2.so (0x005a8000)
libicui18n.so.38 => /opt/oracle/ogg/libicui18n.so.38 (0x00735000)
libicuuc.so.38 => /opt/oracle/ogg/libicuuc.so.38 (0x00896000)
libicudata.so.38 => /opt/oracle/ogg/libicudata.so.38 (0x00ed3000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00110000)
libxerces-c.so.28 => /opt/oracle/ogg/libxerces-c.so.28 (0x009b7000)
libantlr3c.so => /opt/oracle/ogg/libantlr3c.so (0x00128000)
libnnz11.so => /opt/oracle/product/11g/lib/libnnz11.so (0x04710000)
libclntsh.so.11.1 => /opt/oracle/product/11g/lib/libclntsh.so.11.1 (0x01db0000)
libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x001fa000)
libm.so.6 => /lib/libm.so.6 (0x00344000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00d9f000)
libc.so.6 => /lib/libc.so.6 (0x03da7000)
/lib/ld-linux.so.2 (0x001de000)
libnsl.so.1 => /lib/libnsl.so.1 (0x00138000)
libaio.so.1 => /usr/lib/libaio.so.1 (0x0014f000)
[oracle@irdexnew ogg]# ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x86, 32bit (optimized), Oracle 11g on Apr 23 2012 08:09:25
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (irdexnew) 1> CREATE SUBDIRS
Creating subdirectories under current directory /opt/oracle/ogg
Parameter files /opt/oracle/ogg/dirprm: already exists
Rept files /opt/oracle/ogg/dirrpt: created
Checkpoint files /opt/oracle/ogg/dirchk: created
Process status files /opt/oracle/ogg/dirpcs: created
SQL script files /opt/oracle/ogg/dirsql: created
Database definitions files /opt/oracle/ogg/dirdef: created
Extract data files /opt/oracle/ogg/dirdat: created
Temporary files /opt/oracle/ogg/dirtmp: created
Stdout files /opt/oracle/ogg/dirout: created
GGSCI (irdexnew) 2> edit param mgr
PORT 7801
DYNAMICPORTLIST 7802-7820
~
~
~
~
~
~
"dirprm/mgr.prm" [New] 4L, 46C written
GGSCI (irdexnew) 3> start mgr
Manager started.
GGSCI (irdexnew) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
GGSCI (irdexnew) 5> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (irdexnew) 6>
以上是在源端和目标段设置,下面分别在两端
在源端
select supplemental_log_data_min from v$database;
SQL>alter database add supplemental log data; --开启最小附加日志模式
alter table MI_GOODS_DECL add supplemental log data (primary key) columns;
GGSCI>add extract extl,tranlog,begin now
--add extract extl,tranlog,begin now , THREADS 3 ---如果是rac,增加threads参数跟线程总数
GGSCI>edit param extl
setenv(NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")
setenv(ORACLE_BASE="/s01/oracle/app/oracle")
setenv(ORACLE_HOME="/s01/oracle/app/oracle/product/11g")
setenv(ORACLE_SID=tst)
extract extl
userid ept,password ept
rmthost 10.98.32.72, mgrport 7801
rmttrail /opt/oracle/ogg/ggtrail/tst161/rl
dynamicresolution
--TRANLOGOPTIONS ASMUSER sys@GEE_ASM,ASMPASSWORD oracle ---如果是rac使用了asm存储,要在tns中配置连接asm实例名,配置登陆用户名和密码
gettruncates
table ept.mi_goods_decl;
GGSCI>add rmttrail /opt/oracle/ogg/ggtrail/tst161/rl extract extl
GGSCI> start extl
在目标端
mkdir -p /opt/oracle/ogg/ggtrail/tst161
GGSCI>add replicat repl exttrail /opt/oracle/ogg/ggtrail/tst161/rl,begin now,nodbcheckpoint-新增复制
GGSCI>edit param repl--配置复制进程参数
replicat repl
userid ept,password oracle
assumetargetdefs
reperror default,discard
discardfile /opt/oracle/ogg/ggtrail/tst161/repsz.dsc,append,megabytes 100
gettruncates
map ept.mi_goods_decl, target ept.mi_goods_decl;
开启复制进程:
GGSCI>start repl