goldengate monitor 11.1安装配置二——OGG测试

goldengate monitor 11.1安装配置一——OGG配置
[url]http://www.orasql.com/blog/archives/2014/01/15/ogg_monitor_1.htm[/url]
ogg配置完成之后，进行简单的数据同步测试：

在源端插入数据
[code]SQL> conn awen/oracle

Connected.
SQL> insert into ogg_obj select * from dba_objects where rownum<101;

100 rows created.

SQL> commit;

Commit complete.

SQL> insert into ogg_seg select * from dba_segments where rownum<101;

100 rows created.

SQL> commit;

Commit complete.[/code]
在目标端检查同步情况
[code]SQL> conn scott/oracle

Connected.
SQL> select count(*) from ogg_obj;

COUNT(*)
----------
100

SQL> select count(*) from ogg_seg;

COUNT(*)
----------
100[/code]
在源端删除数据
[code]SQL> conn awen/oracle

Connected.
SQL> delete from ogg_obj;

100 rows deleted.

SQL> delete from ogg_seg;

100 rows deleted.

SQL> commit;

Commit complete.[/code]
在目标端检查数据
[code]SQL> conn scott/oracle

Connected.
SQL> select count(*) from ogg_obj;

COUNT(*)
----------
0

SQL> select count(*) from ogg_seg;

COUNT(*)
----------
0

[oracle@localhost dirdat]$ ls -l
total 288
-rw-rw-rw- 1 oracle dba 136960 Aug 22 10:38 va000000
-rw-rw-rw- 1 oracle dba 124575 Aug 22 10:38 vb000000[/code]