首页 > Linux操作系统 > Linux操作系统 > goldengate安装
源端数据库:
Oracle数据库需要开启归档日志,并开启最小附加日志模式。
SQL> select supplemental_log_data_min from v$database; --查看是否开启了最小附加日志模式
SQL> alter database add supplemental log data; --开启最小附加日志模式
实际生产应用中,最好同时打开ORACLE的强制日志模式,以防止源数据库因直接路径加载忽略redo生成而导致这部分数据无法同步:
SQL> select force_logging from v$database;
SQL> alter database force logging;
./ggsci
GGSCI> CREATE SUBDIRS
GGSCI>edit param mgr
配置mgr
PORT 7801
DYNAMICPORTLIST 7802-7820
保存,生成的参数文件保存在GG_HOME\ dirprm下
GGSCI>start mgr
GGSCI>info all
配置extract进程
GGSCI>add extract extl,tranlog THREADS 2,begin now
GGSCI>edit param extl
extract extl
userid tiger,password tiger
exttrail /oracle/product/gg/dirdat/l1
dynamicresolution
table tiger.test1;
GGSCI>add exttrail /oracle/product/gg/dirdat/l1 extract extl
GGSCI>ADD EXTRACT pump1, EXTTRAILSOURCE /oracle/product/gg/dirdat/l1, BEGIN now
GGSCI>edit param pump1
extract pump1
userid tiger, password tiger
rmthost 10.10.81.34, mgrport 7801
rmttrail /oracle/product/gg/dirdat/rl
PASSTHRU
table tiger.test1;
GGSCI>add rmttrail /oracle/product/gg/dirdat/rl extract pump1
GGSCI>start extl
GGSCI>start pump1
目标端数据库
GGSCI>add replicat repl exttrail /oracle/product/gg/dirdata/rl,begin now,nodbcheckpoint
GGSCI>edit param repl
replicat repl
userid tiger,password tiger
assumetargetdefs
discardfile /oracle/product/gg/dirdat/repl.dsc,append,megabytes 500
MAP tiger.*, TARGET tiger.*;
GGSCI>start repl
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/22521389/viewspace-732492/ ,如需转载,请注明出处,否则将追究法律责任。