GGSCI (badly9) 4> start mgr
Manager started.
GGSCI (badly9) 5> edit params eora
GGSCI (badly9) 6> view params eora
extract eora
dynamicresolution
userid ogg,password ogg
exttrail /u01/app/oracle/ogg/dirdat/et
table scott.*;
GGSCI (badly9) 7>dblogin userid ogg, password ogg
Successfully logged into database.
GGSCI (badly9) 8>add trandata scott.*
GGSCI (badly9) 9> add extract eora,tranlog,begin now
EXTRACT added.
GGSCI (badly9) 10> add exttrail /u01/app/oracle/ogg/dirdat/et,extract eora
EXTTRAIL added.
GGSCI (badly9) 11> start extract eora
Sending START request to MANAGER ...
EXTRACT EORA starting
GGSCI (badly9) 12> edit params pump_so
GGSCI (badly9) 13> view params pump_so
extract pump_so
dynamicresolution
passthru
rmthost 192.168.40.128,mgrport 7809,compress
rmttrail /u01/app/oracle/ogg/dirdat/pt
table scott.*;
GGSCI (badly9) 14> add extract pump_so,exttrailsource /u01/app/oracle/ogg/dirdat/et
EXTRACT added.
GGSCI (badly9) 15> add rmttrail /u01/app/oracle/ogg/dirdat/pt,extract pump_so
RMTTRAIL added.
GGSCI (badly9) 16> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EORA 00:00:00 00:00:02
EXTRACT RUNNING PUMP_SO 00:00:00 00:00:07
配置目标端进程：
因为目标端使用的是oracle 10g，启动ggsci的时候报错：
[oracle@jp ogg]$ ggsci
ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory
增加软链接：
ln -s /u01/app/oracle/product/10.2.0/db_1/lib/libnnz10.so libnnz11.so
启动再次报错：
[oracle@jp ogg]$ ggsci
ggsci: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory
再增加一个软链接：
ln -s /u01/app/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1 libclntsh.so.11.1
再次启动正常：
[oracle@jp 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 (jp) 1> create subdirs
Creating subdirectories under current directory /u01/app/oracle/ogg
Parameter files /u01/app/oracle/ogg/dirprm: already exists
Report files /u01/app/oracle/ogg/dirrpt: created
Checkpoint files /u01/app/oracle/ogg/dirchk: created
Process status files /u01/app/oracle/ogg/dirpcs: created
SQL script files /u01/app/oracle/ogg/dirsql: created
Database definitions files /u01/app/oracle/ogg/dirdef: created
Extract data files /u01/app/oracle/ogg/dirdat: created
Temporary files /u01/app/oracle/ogg/dirtmp: created
Stdout files /u01/app/oracle/ogg/dirout: created
GGSCI (jp) 2> edit params mgr
GGSCI (jp) 3> view params mgr
port 7809
dynamicportlist 7800-8000
autostart er *
autorestart extract *,waitminutes 2,retries 5
lagreporthours 1
laginfominutes 3
lagcriticalminutes 5
purgeoldextracts /u01/app/oracle/ogg/dirdat/rt*,usecheckpoints,minkeepdays 3
GGSCI (jp) 4> start mgr
Manager started.
GGSCI (jp) 5> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (jp) 12> edit params rep2
GGSCI (jp) 13> view params rep2
replicat rep2
userid ogg,password ogg
assumetargetdefs
reperror default,discard
discardfile ./dirrpt/rep1.dsc,append,megabytes 50
dynamicresolution
--map ogg.test,target o