goldengate是一个oracle收购的软件 目前非常的火爆 咱们也得跟上时代 是不？
首先去官网下载 http://edelivery.oracle.com/EPD/Download/get_form 下载了一个 linux X86版本
下下来是这么一个东西 V18156-01.zip 先解压一下 unzip 然后tar xvf
安装过程其实是非常的简单的 如下：
[oracle@dg01 goldengate]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 002
Linux, x86, 32bit (optimized), Oracle 10 on Sep 17 2009 23:49:42
Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved.
GGSCI (dg01) 1> create subdirs
Creating subdirectories under current directory /goldengate
Parameter files /goldengate/dirprm: created
Report files /goldengate/dirrpt: created
Checkpoint files /goldengate/dirchk: created
Process status files /goldengate/dirpcs: created
SQL script files /goldengate/dirsql: created
Database definitions files /goldengate/dirdef: created
Extract data files /goldengate/dirdat: created
Temporary files /goldengate/dirtmp: created
Veridata files /goldengate/dirver: created
Veridata Lock files /goldengate/dirver/lock: created
Veridata Out-Of-Sync files /goldengate/dirver/oos: created
Veridata Out-Of-Sync XML files /goldengate/dirver/oosxml: created
Veridata Parameter files /goldengate/dirver/params: created
Veridata Report files /goldengate/dirver/report: created
Veridata Status files /goldengate/dirver/status: created
Veridata Trace files /goldengate/dirver/trace: created
Stdout files /goldengate/dirout: created
GGSCI (dg01) 2> help
GGSCI Command Summary
SUBDIRS CREATE SUBDIRS
ER INFO ER, KILL ER, LAG ER, SEND ER, STATUS ER,
START ER, STATS ER, STOP ER
EXTRACT ADD, ALTER, CLEANUP, DELETE, INFO, KILL,
LAG, SEND, START, STATS, STATUS, STOP
EXTTRAIL ADD, ALTER, DELETE, INFO
GGSEVT VIEW
MANAGER INFO, REFRESH, SEND, START, STOP, STATUS
MARKER INFO
PARAMS EDIT, VIEW
REPLICAT ADD, ALTER, CLEANUP, DELETE, INFO, KILL,
LAG, SEND, START, STATS, STATUS, STOP
REPORT VIEW
RMTTRAIL ADD, ALTER, DELETE, INFO
TRACETABLE ADD, DELETE, INFO
TRANDATA ADD, DELETE, INFO
Database DBLOGIN, LIST TABLES,
ENCRYPT PASSWORD
DDL DUMPDDL
CHECKPOINTTABLE ADD CHECKPOINTTABLE, DELETE CHECKPOINTTABLE,
CLEANUP CHECKPOINTTABLE, INFO CHECKPOINTTABLE
Miscellaneous FC, HELP, HISTORY, INFO ALL, INFO MARKER, OBEY,
SET, SHELL, SHOW, VERSIONS, !
For help on a specific command, type HELP <command> <object>.
Example: HELP ADD REPLICAT
GGSCI (dg01) 3>
我这里就直接使用oracle用户了 当然你可以单独建一个os用户 用来安装goldegate
不过在数据库中 你还得建立相应的账户 示例如下：
SQL> create user goldengate identified by goldengate;
User created.
SQL> grant connect,resource to goldengate;
Grant succeeded.
SQL> grant select any dictionary to goldengate;
Grant succeeded.
SQL> grant select any table to goldengate;
Grant succeeded.
SQL> grant dba to goldengate;
Grant succeeded.
SQL>
SQL>
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /arch
Oldest online log sequence 150
Next log sequence to archive 151
Current log sequence 151
SQL> select SUPPLEMENTAL_LOG_DATA_MIN from v$database;
SUPPLEME
--------
NO
SQL> alter database add supplemental log data;
Database altered.
SQL>
至于上面的权限 其实只授予dba就够了。。。。
补充：安装和建立goldengate账户 在原库和目标库中操作完全一样
######### 配置
原库：
GGSCI (dg01) 5> edit params mgr
port 7809
dynamicportlist 7800-8000
autorestart extract *,waitminutes 2,resetminutes 5
GGSCI (dg01) 6> start mgr
Manager started.
GGSCI (dg01) 7> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
-----目标库操作完全一样 edit params mgr
原库操作：
GGSCI (dg01) 8> dblogin userid goldengate,PASSWORD goldengate
ERROR: Failed to open data source for user GOLDENGATE.
GGSCI (dg01) 9>
------登陆错误通常是由于listener.ora tnsnames.ora造成 注意IP等等。
GGSCI (dg01) 15> view params testdb1 ----配置抽取进程参数（其实可以直接修改 /goldengate/dirprm/testdb1.prm文件）
dynamicresolution
gettruncates
extract testdb1
userid ggs,password ggs
rmthost 192.168.1.11,mgrport 7809
rmttrail /opt/ggc/dirdat/et
table scott.*;
GGSCI (dg01) 11> dblogin USERID goldengate ---登陆原库
Successfully logged into database.
GGSCI (dg01) 12> add extract testdb1,tranlog,begin now
EXTRACT added.
GGSCI (dg01) 13> add rmttrail /opt/ggc/dirdat/et,extract testdb1,megabytes 100
RMTTRAIL added.
-----如上2步骤是配置抽取进程
GGSCI (dg01) 14> info extract testdb1
EXTRACT TESTDB1 Initialized 2010-11-15 09:03 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:27 ago)
Log Read Checkpoint Oracle Redo Logs
2010-11-15 09:03:00 Seqno 0, RBA 0
GGSCI (dg01) 15> view params testdb2
extract TESTDB2
dynamicresolution
PASSTHRU
rmthost 192.168.1.21,mgrport 7809, compress
rmttrail /opt/ggc/dirdat/et
numfiles 3000
TABLE scott.* ;
GGSCI (dg01) 48> add extract testdb2,exttrailsource /opt/ggc/dirdat/et,begin now ------配置投递进程
EXTRACT added.
GGSCI (dg01) 49> add rmttrail /opt/ggc/dirdat/et,extract testdb2
RMTTRAIL added.
目标库配置：
GGSCI (roger) 9> dblogin userid goldengate
Successfully logged into database.
GGSCI (roger) 11> view params alexldb1
replicat alexdb1
SETENV (ORACLE_SID=devdb)
userid ggs,password ggs
handlecollisions
--allownoopupdates
ASSUMETARGETDEFS
dynamicresolution
numfiles 3000
discardfile /opt/ggc/dirdat/alex.dsc,append,megabytes 50
map scott.*,target scott.* ;
--添加CHECKPOINT TABLE
GGSCI (roger) 10>edit params ./GLOBALS
checkpointtable ggs.checkpoint
GGSCI (roger) 10>add checkpointtable ggs.checkpoint
GGSCI (roger) 10>add replicat alexdb1,exttrail /opt/ggc/dirdat/et,CHECKPOINTTABLE ggs.checkpoint ---配置接受进程,并设置checkpoint table
[oracle@roger dirprm]$
补充：不增加ASSUMETARGETDEFS 参数，会报错：
2010-11-15 10:13:21 GGS ERROR 101 Could not find definition for ROGER.TEST.
GGSCI (roger) 32> start replicat alexdb1
Sending START request to MANAGER ...
REPLICAT ALEXDB1 starting
GGSCI (roger) 33> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING ALEXDB1 00:00:00 00:00:00
同步测试：
在原库进行操作，如下：
GGSCI (dg01) 65> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING TESTDB1 00:00:00 00:00:06
EXTRACT RUNNING TESTDB2 00:00:00 00:00:04
GGSCI (dg01) 66>
SQL> delete from test where object_id <100 and object_id >50;
49 rows deleted.
SQL> commit;
Commit complete.
SQL>
SQL> delete from test where object_id >900 and object_id <950;
47 rows deleted.
SQL> commit;
Commit complete.
查看状态：
GGSCI (dg01) 66> stats testdb1
Sending STATS request to EXTRACT TESTDB1 ...
Start of Statistics at 2010-11-15 10:18:20.
Output to ./oracle/gg:
Extracting from ROGER.TEST to ROGER.TEST:
*** Total statistics since 2010-11-15 09:30:10 ***
Total inserts 0.00
Total updates 0.00
Total deletes 96.00
Total discards 0.00
Total operations 96.00
*** Daily statistics since 2010-11-15 09:30:10 ***
Total inserts 0.00
Total updates 0.00
Total deletes 96.00
Total discards 0.00
Total operations 96.00
*** Hourly statistics since 2010-11-15 10:00:00 ***
No database operations have been performed.
*** Latest statistics since 2010-11-15 09:30:10 ***
Total inserts 0.00
Total updates 0.00
Total deletes 96.00
Total discards 0.00
Total operations 96.00
End of Statistics.
GGSCI (dg01) 67> status testdb2
EXTRACT TESTDB2: RUNNING
GGSCI (dg01) 68> stats testdb2
Extracting from ROGER.TEST to ROGER.TEST:
*** Total statistics since 2010-11-15 09:30:12 ***
Total inserts 0.00
Total updates 0.00
Total deletes 96.00
Total discards 0.00
Total operations 96.00
*** Daily statistics since 2010-11-15 09:30:12 ***
Total inserts 0.00
Total updates 0.00
Total deletes 96.00
Total discards 0.00
Total operations 96.00
*** Hourly statistics since 2010-11-15 10:00:00 ***
No database operations have been performed.
*** Latest statistics since 2010-11-15 09:30:12 ***
Total inserts 0.00
Total updates 0.00
Total deletes 96.00
Total discards 0.00
Total operations 96.00
End of Statistics.
GGSCI (dg01) 69>
目标库同步情况：
GGSCI (roger) 34> stats alexdb1
Sending STATS request to REPLICAT ALEXDB1 ...
Start of Statistics at 2010-11-15 10:19:14.
Replicating from ROGER.TEST to ROGER.TEST:
*** Total statistics since 2010-11-15 10:18:55 ***
Total inserts 0.00
Total updates 0.00
Total deletes 96.00
Total discards 0.00
Total operations 96.00
Total delete collisions 96.00
*** Daily statistics since 2010-11-15 10:18:55 ***
Total inserts 0.00
Total updates 0.00
Total deletes 96.00
Total discards 0.00
Total operations 96.00
Total delete collisions 96.00
*** Hourly statistics since 2010-11-15 10:18:55 ***
Total inserts 0.00
Total updates 0.00
Total deletes 96.00
Total discards 0.00
Total operations 96.00
Total delete collisions 96.00
*** Latest statistics since 2010-11-15 10:18:55 ***
Total inserts 0.00
Total updates 0.00
Total deletes 96.00
Total discards 0.00
Total operations 96.00
Total delete collisions 96.00
End of Statistics.
