Oracle GoldenGate 学习教程二、配置和使用(6)

在源端产生DML操作

OGG_OWNER@sydb>insert into togg(id,name)values(1003,'tt') ; 1 row created. Elapsed: 00:00:00.00 OGG_OWNER@sydb>insert into togg(id,name,type)values(1004,'sywu','user'); 1 row created. Elapsed: 00:00:00.01 OGG_OWNER@sydb>commit; Commit complete. Elapsed: 00:00:00.01

再次查看源端进程状态

GGSCI (sywu) 10> stats ESYDB001 Sending STATS request to EXTRACT ESYDB001 ... Start of Statistics at 2015-08-26 10:04:54. Output to /u01/app/product/ogg_src/dirdat/es: Extracting from OGG_OWNER.TOGG to OGG_OWNER.TOGG: *** Total statistics since 2015-08-26 10:04:33 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 *** Daily statistics since 2015-08-26 10:04:33 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 *** Hourly statistics since 2015-08-26 10:04:33 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 *** Latest statistics since 2015-08-26 10:04:33 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 End of Statistics. GGSCI (sywu) 11> stats PSYDB001 Sending STATS request to EXTRACT PSYDB001 ... Start of Statistics at 2015-08-26 10:04:58. Output to /u01/app/product/ogg_trg/dirdat/ps: Extracting from OGG_OWNER.TOGG to OGG_OWNER.TOGG: *** Total statistics since 2015-08-26 10:04:35 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 *** Daily statistics since 2015-08-26 10:04:35 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 *** Hourly statistics since 2015-08-26 10:04:35 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 *** Latest statistics since 2015-08-26 10:04:35 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 End of Statistics.

再次查看目标端进程状态

GGSCI (sywu) 7> stats RSYDB001 Sending STATS request to REPLICAT RSYDB001 ... Start of Statistics at 2015-08-26 10:05:03. Replicating from OGG_OWNER.TOGG to OGG_TRG.TOGG: *** Total statistics since 2015-08-26 10:04:45 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 *** Daily statistics since 2015-08-26 10:04:45 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 *** Hourly statistics since 2015-08-26 10:04:45 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 *** Latest statistics since 2015-08-26 10:04:45 *** Total inserts 2.00 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 2.00 End of Statistics.

数据稽查

SYS@sydb>select count(*) from ogg_owner.togg; COUNT(*) ---------- 1002 Elapsed: 00:00:00.00 SYS@sydb>select count(*) from ogg_trg.togg; COUNT(*) ---------- 1002 Elapsed: 00:00:00.05 SYS@sydb>column name format a10 SYS@sydb>select id,name,type from ogg_owner.togg where; ID NAME TYPE ---------- ---------- ------------------- 1004 sywu user Elapsed: 00:00:00.00 SYS@sydb>select id,name,type from ogg_trg.togg where; ID NAME TYPE ---------- ---------- ------------------- 1004 sywu user Elapsed: 00:00:00.01 5 总结

　　GoldenGate通过自身的数据加工、处理、发送、应用以及借用RDBMS数据库系统的优势保证数据的可同步性和准确性，并在错误和故障发生的情况下以RDBMS系统特有的特性(如Oracle 内部同步变更号(SCN)和检查点)保障了数据的可恢复性和一致性，为同步的数据实时性和准确性提供了准确性和可稽查性。

--The end(2015-08-26) 

GoldenGate更新丢失问题 

GoldenGate单向表DML同步

Oracle GoldenGate 系列：Extract 进程的恢复原理

Oracle GoldenGate安装配置

Oracle goldengate的OGG-01004 OGG-1296错误

Oracle GoldenGate快速入门教程：基本概念和配置

搭建一个Oracle到Oracle的GoldenGate双向复制环境

GoldenGate的安全配置