GGSCI (cndba) 6> stop rep1
Sending STOP request to REPLICAT REP1 ...
Request processed.
GGSCI (cndba) 7> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT STOPPED REP1 00:00:00 00:00:06
1.3.获取当前源端的scn号
SQL> select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
1184010
1.4.源端增量数据在产生
SQL> conn test/test
Connected.
SQL> insert into test values(6,'test');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from test;
ID NAME
---------- --------
1 zhangsan
2 lisi
3 wanger
4 test
5 test
6 test
GGSCI (cndba) 18> start rep1
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (cndba) 19> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP1 00:00:00 00:00:01
1.8.测试数据同步
--源端插入数据
SQL> insert into test1 values(100002,'test');
1 row created.
SQL> commit;
Commit complete.
SQL> select count(*) from test1;
COUNT(*)
----------
100002
--目标端查看数据
增量数据也同步过来
SQL> select * from test;
ID NAME
---------- --------
5 test
1 zhangsan
2 lisi
3 wanger
4 test
6 test
误删除的表数据数据也同步过来了
SQL> select count(*) from test1;
COUNT(*)
----------
100002