16. Verifying the data transfer on the target system

目标端验证数据传输：

该实验是一个最简单的验证数据传输的例子

1° 源库更新：

update SCOTT.EMP set sal=sal+1000;
commit;

2° 检查一小时内抽取进程统计信息：

stats EGGTEST1 hourly
-- Sending STATS request to EXTRACT EGGTEST1 ...
-- Start of Statistics at 2018-07-14 11:00:47.
-- Output to /ggs/dirdat/EGGTEST1/st:
-- Extracting from SCOTT.EMP to SCOTT.EMP:
-- *** Hourly statistics since 2018-07-14 11:00:11 ***
--         Total inserts                                      0.00
--         Total updates                                     14.00
--         Total deletes                                      0.00
--         Total discards                                     0.00
--         Total operations                                  14.00
-- End of Statistics.

3° 检查一小时内发送进程统计信息：

stats pggtest1 hourly
-- Sending STATS request to EXTRACT PGGTEST1 ...
-- Start of Statistics at 2018-07-14 11:02:56.
-- Output to /ggs/dirdat/PGGTEST1/rt:
-- Extracting from SCOTT.EMP to SCOTT.EMP:
-- *** Hourly statistics since 2018-07-14 11:00:12 ***
--         Total inserts                                      0.00
--         Total updates                                     14.00
--         Total deletes                                      0.00
--         Total discards                                     0.00
--         Total operations                                  14.00
-- End of Statistics.

4° 目标端检查一小时内应用进程统计信息：

stats rggtest1 hourly
-- Sending STATS request to REPLICAT RGGTEST1 ...
-- Start of Statistics at 2018-07-14 11:03:38.
-- Replicating from SCOTT.EMP to SCOTT.EMP:
-- *** Hourly statistics since 2018-07-14 11:00:16 ***
--         Total inserts                                      0.00
--         Total updates                                      9.00
--         Total deletes                                      0.00
--         Total discards                                     0.00
--         Total operations                                   9.00
-- End of Statistics.

5° 目标库检查表信息更新状况：

select * from emp;

6° 命令简介：

stats命令仅列出每个进程发现的每个表的变化信息：
STATS {EXTRACT | REPLICAT | ER} {名|通配符} [TABLE {名|通配符}] [TOTAL | DAILY | HOURLY | LATEST]
STATS EXTRACT EGGTEST* TABLE scott.* LATEST

stats命令另一种常用法：
STATS {EXTRACT | REPLICAT | ER} {名|通配符}, TOTALSONLY <table>
STATS REPLICAT RGGTEST1, TOTALSONLY SCOTT.*

stats命令检查OGG某个进程的速度：
STATS REPLICAT RGGTEST1 REPORTRATE HR
查看hourly、daily和进程启动后total进程信息

[TOC]