1、源端和目标端状态确认
源端:
GGSCI (rac1) 85> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DPFULL 00:00:00 00:00:07
EXTRACT RUNNING EXTFULL 00:00:00 00:00:08
目标端:
GGSCI (rac2) 101> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REPFULL 00:00:00 00:00:02
2、源端对同步表添加新列(无需停止OGG)
SQL> select * from test.a;
ID NA
---------- --
1 a
2 a
3 a
4 a
5 a
6 a
6 rows selected.
SQL> alter table test.a add (sex int);
Table altered.
<
源端:
GGSCI (rac1) 85> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DPFULL 00:00:00 00:00:07
EXTRACT RUNNING EXTFULL 00:00:00 00:00:08
目标端:
GGSCI (rac2) 101> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REPFULL 00:00:00 00:00:02
2、源端对同步表添加新列(无需停止OGG)
SQL> select * from test.a;
ID NA
---------- --
1 a
2 a
3 a
4 a
5 a
6 a
6 rows selected.
SQL> alter table test.a add (sex int);
Table altered.
<