ogg重新部署

1.源端操作，删除extract和pump进程，删除trail文件

dblogin userid ogg,password ogg
stop exti
stop extpump
delete exti
delete extpump
quit
rm -rf /home/oracle/ogg/dirdat/ms*

2.目标端操作，删除replicat进程和检查点，删除trail文件：

dblogin sourcedb ogg@172.24.104.46:3306 userid ogg
stop repi
delete repi
delete checkpointtable ogg.ggs_checkpoint
quit
rm -rf /opt/ogg/dirdat/ms*

3.源端操作，重建并启动extract和pump进程：

因为原来的参数文件都在这里不需要重新配置参数

GGSCI (template) 1> add extract exti,tranlog,begin now
EXTRACT added.
GGSCI (template) 2> add exttrail /home/oracle/ogg/dirdat/ms,extract exti,megabytes 1024
EXTTRAIL added.

GGSCI (template) 4> add extract extpump,exttrailsource /home/oracle/ogg/dirdat/ms
EXTRACT added.
GGSCI (template) 5> add rmttrail /opt/ogg/dirdat/ms,extract extpump
RMTTRAIL added.

GGSCI (template) 6> start exti
Sending START request to MANAGER ...
EXTRACT EXTI starting
GGSCI (template) 7> start extpump
Sending START request to MANAGER ...
EXTRACT EXTPUMP starting

4.目标端操作，重建replicat进程和检查点：

GGSCI (mysql1) 3> dblogin sourcedb ogg@172.24.104.46:3306 userid ogg
Password:
Successfully logged into database.

GGSCI (mysql1 DBLOGIN as ogg) 4> add checkpointtable ogg.ggs_checkpoint

Successfully created checkpoint table ogg.ggs_checkpoint.

add replicat repi,exttrail /opt/ogg/dirdat/ms,checkpointtable ogg.ggs_checkpoint

5.目标端数据库重置或者清空数据

.目标端数据库重置或者手动清空数据

6.启动源端OGG 全量抽取进程(extract)

nohup ./extract paramfile ./dirprm/extinit.prm reportfile ./dirrpt/extinit.rpt &
tail -f ./dirrpt/extinit.rpt

7.启动目标端OGG 全量回放进程(replicat)

nohup ./replicat paramfile ./dirprm/repinit.prm reportfile ./dirrpt/repinit.rpt &
tail -f ./dirrpt/repinit.rpt
检查全量同步是否正常

8. 启动目标端replicat进程

源端新增数据
目标端启动replicat进程
start repi
检查增量同步是否正常。