1.停掉原来的ogg
这个过程模拟不停地写入数据
源端
GGSCI (rac01) 10> stop extep
GGSCI (rac01) 13> stop dpep
GGSCI (rac01) 15> stop mgr
目的端
查看已经消费完停掉之前的trail文件后再停掉,可以查看具体的表是否有新数据写入,没有的话就停掉
GGSCI (ora11g) 17> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING
REPLICAT RUNNING REPEP 00:00:00 00:00:03 GGSCI (ora11g) 22> stop repep
GGSCI (ora11g) 23> stop mgr
2.这个时候源端和目的端的数据是不一致的
源端:
SQL> select count(1) from tb_test01;COUNT(1)
----------100000目的端:
SQL> select count(1) from tb_test01;COUNT(1)
----------78982
3.记录下停掉时候的抽取、投递、复制进程的信息
源端：
##########测试1
抽取进程
GGSCI (rac01) 1> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER STOPPED
EXTRACT STOPPED DPEP 00:00:00 00:07:32
EXTRACT STOPPED EXTEP 00:00:01 00:07:51 GGSCI (rac01) 2> info extepEXTRACT EXTEP Last Started 2025-10-29 10:11 Status STOPPED
Checkpoint Lag 00:00:01 (updated 00:07:54 ago)
Log Read Checkpoint Oracle Redo Logs2025-10-29 10:34:45 Thread 1, Seqno 221, RBA 8786960SCN 0.17865969 (17865969)
Log Read Checkpoint Oracle Redo Logs2025-10-29 10:34:47 Thread 2, Seqno 171, RBA 174125540SCN 0.17866188 (17866188)
取节点1(小的)的scn:17865969
####################部署新的ogg#######################
源端
1.创建目录
[oracle@epidbhn goldengate12c]$ cd /goldengate12c_new
[oracle@epidbhn goldengate12c]$ ./ggsci
GGSCI (localhost.localdomain) 1> create subdirs
2.配置mgr
[oracle@epidbhn goldengate12c]$ cd /goldengate12c_new
[oracle@epidbhn goldengate12c]$ ./ggsci
EDIT PARAMS MGR
输入如下内容:
[oracle@rac01 dirprm]$ more mgr.prm
port 7819
DYNAMICPORTLIST 7900-7950
PURGEOLDEXTRACTS ./dirdat/ep*, USECHECKPOINTS, MINKEEPHOURS 2, FREQUENCYMINUTES 30
userid goldengate, password AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC ,ENCRYPTKEY DEFAULT
AUTORESTART EXTRACT DPEP RETRIES 3 WAITMINUTES 5 RESETMINUTES 60
AUTORESTART EXTRACT extep RETRIES 3 WAITMINUTES 5 RESETMINUTES 60
3.配置抽取进程
EDIT PARAMS extep
[oracle@rac01 dirprm]$ more extep.prm
extract extep
userid goldengate, password AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC ,ENCRYPTKEY DEFAULT
SETENV (ORACLE_SID="slnngk1")
SETENV ( NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)
exttrail ./dirdat/ep
BR BRINTERVAL 20M
numfiles 5000
warnlongtrans 3h, checkinterval 10m
TRANLOGOPTIONS LOGRETENTION ENABLED
TRANLOGOPTIONS DBLOGREADER
--DDL parameter
DDL &
EXCLUDE INSTR 'shrink space CHECK' &
INCLUDE MAPPED OBJTYPE 'TABLE' &
INCLUDE MAPPED OBJTYPE 'INDEX' &
INCLUDE MAPPED OBJTYPE 'SEQUENCE' &
INCLUDE MAPPED OBJTYPE 'VIEW' &
INCLUDE MAPPED OBJTYPE 'PROCEDURE' &
INCLUDE MAPPED OBJTYPE 'FUNCTION' &
INCLUDE MAPPED OBJTYPE 'PACKAGE'
DDLOPTIONS ADDTRANDATA REPORT
table hxl.tb_test01,tokens(tk-scn=@getenv('ORATRANSACTION', 'SCN'));
table hxl.tb_test02,tokens(tk-scn=@getenv('ORATRANSACTION', 'SCN'));
ADD EXTRACT extep, TRANLOG, SCN 17865969,threads 2 ##测试1 取rac节点1的scn 小的scn 验证成功
ADD EXTRACT extep, TRANLOG, SCN 18030547,threads 2 ##测试2 取rac节点2的scn 小的scn 验证成功
ADD EXTRACT extep, TRANLOG, SCN 18269173,threads 2 ##测试3 取rac节点2的scn 小的scn 验证成功
ADD EXTRACT extep, TRANLOG, begin 2025-10-29 16:27:45,threads 2 ##测试4 通过时间点抽取
ADD EXTRACT extep, TRANLOG, SCN 18646858,threads 2 ##测试5
add EXTTRAIL ./dirdat/ep, EXTRACT extep, MEGABYTES 100
4.配置投递进程
EDIT PARAMS dpep
[oracle@rac01 dirprm]$ more dpep.prm
extract dpep
userid goldengate, password AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC ,ENCRYPTKEY DEFAULT
RmtHost 192.168.56.40, MgrPort 7819, Compress
RmtTrail ./dirdat/ep
gettruncates
Passthru
table hxl.*;
ADD EXTRACT dpep, EXTTRAILSOURCE ./dirdat/ep
ADD RMTTRAIL ./dirdat/ep, EXTRACT dpep, MEGABYTES 100
目标端
1.创建目录
[oracle@epidbhn goldengate12c]$ cd /goldengate12c_new
[oracle@epidbhn goldengate12c]$ ./ggsci
GGSCI (localhost.localdomain) 1> create subdirs
2.配置mgr
[oracle@epidbhn goldengate12c]$ cd /goldengate12c_new
[oracle@epidbhn goldengate12c]$ ./ggsci
EDIT PARAMS MGR
输入如下内容:
[oracle@ora11g dirprm]$ more mgr.prm
port 7819
DYNAMICPORTLIST 7900-7950
purgeoldextracts ./dirdat/*, usecheckpoints, minkeepdays 3
userid goldengate, password AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC ,ENCRYPTKEY DEFAULT
3.配置复制进程
add replicat repep, exttrail ./dirdat/ep, NODBCHECKPOINT
EDIT PARAM repep
[oracle@ora11g dirprm]$ more repep.prm
replicat repep
userid goldengate, password AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC ,ENCRYPTKEY DEFAULT
DiscardFile ./dirrpt/repep.dsc, append, Megabytes 200
gettruncates
AllowNoopUpdates
ASSUMETARGETDEFS
DBOPTIONS SUPPRESSTRIGGERS
DBOPTIONS DEFERREFCONST
HANDLECOLLISIONS
batchsql
MAP hxl.tb_test01,TARGET hxl.tb_test01;
MAP hxl.tb_test02,TARGET hxl.tb_test02;
DDLERROR 10655 IGNORE
DDLERROR 10636 IGNORE
###########启动
先启动复制端
start mgr
start repep
然后启动源端
start mgr
start extep
start dpep