Which are captured if you add extract begin now 1:00 pm,but start extract at 2:00 p.m?
A: Transactions is started on or after 1:00 p.m
B: Transactions is started on or after 2:00 p.m
C: Transactions is started before 1:00 p.m and commited after 1:00 pm.
D: Transactions is started before 1:00 p.m and commited after 2:00 pm.
结果是:A
实验一:
1、插入数据,不提交
2、在创建进程 抽取,传输和复制进程
3、提交数据
4、启动进程
----1 插入数据
insert into t1 select * From emp;
----2创建抽取进程
add extract exta,tranlog,threads 1,begin now
add exttrail F:\ggs_window\dirdat\aa,extract exta,megabytes 15
add extract dpa,exttrailsource F:\ggs_window\dirdat\aa
add rmttrail /ggs/dirdat/aa ,extract dpa
add replicat repa,exttrail /ggs/dirdat/aa nodbcheckpoint
---3、提交数据
commit;
---4 启动进程
结论:
GGSCI (a-hb-8-54) 136> stats exta
Sending STATS request to EXTRACT EXTA ...
No active extraction maps.
GGSCI (a-hb-8-54) 137> stats dpa
Sending STATS request to EXTRACT DPA ...
No active extraction maps.
捕捉不到数据的变化
目标端:
SQL> select * From t1;
no rows selected
实验二:
1、插入数据,不提交
2、在创建进程 抽取,传输和复制进程
3、启动进程
4、提交数据
----1 插入数据
insert into t1 select * From emp;
----2创建抽取进程
add extract exta,tranlog,threads 1,begin now
add exttrail F:\ggs_window\dirdat\aa,extract exta,megabytes 15
add extract dpa,exttrailsource F:\ggs_window\dirdat\aa
add rmttrail /ggs/dirdat/aa ,extract dpa
add replicat repa,exttrail /ggs/dirdat/aa nodbcheckpoint
---4 启动进程
---3、提交数据
commit;
结果: 没有捕捉到
实验 三:
1、在创建进程 抽取,传输和复制进程
2、插入数据,不提交
3、提交数据
4、启动进程
----1创建进程
add extract exta,tranlog,threads 1,begin now
add exttrail F:\ggs_window\dirdat\aa,extract exta,megabytes 15
add extract dpa,exttrailsource F:\ggs_window\dirdat\aa
add rmttrail /ggs/dirdat/aa ,extract dpa
add replicat repa,exttrail /ggs/dirdat/aa nodbcheckpoint
----2 插入数据
insert into t1 select * From emp;
---3、提交数据
commit;
---4 启动进程
结论: 数据同步
GGSCI (dba) 38> stats repa
Sending STATS request to REPLICAT REPA ...
Start of Statistics at 2015-04-22 17:29:53.
Replicating from SCOTT.T1 to SCOTT.T1:
*** Total statistics since 2015-04-22 17:29:49 ***
Total inserts 12.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 12.00
实验 四:
1、在创建进程 抽取,传输和复制进程
2、插入数据,不提交
3、启动进程
4、提交数据
----1创建进程
add extract exta,tranlog,threads 1,begin now
add exttrail F:\ggs_window\dirdat\aa,extract exta,megabytes 15
add extract dpa,exttrailsource F:\ggs_window\dirdat\aa
add rmttrail /ggs/dirdat/aa ,extract dpa
add replicat repa,exttrail /ggs/dirdat/aa nodbcheckpoint
----2 插入数据
insert into t1 select * From emp;
---3启动进程
---4、提交数据
commit;
结论:
GGSCI (dba) 38> stats repa
Sending STATS request to REPLICAT REPA ...
Start of Statistics at 2015-04-22 17:30:53.
Replicating from SCOTT.T1 to SCOTT.T1:
*** Total statistics since 2015-04-22 17:29:49 ***
Total inserts 12.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 12.00
通过上面的测试,我们发现goldengate 进程是在进程创建后开始捕捉事物的,如果在进程创建前开始的事物是捕捉不到的
goldengate translations 的捕捉
最新推荐文章于 2023-11-07 08:24:07 发布