ogg简单配置

去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

请使用浏览器的分享功能分享到微信等