OGG在线初始化（expdp/impdp）

1.创建初始数据
SQL> create table testogg.dept as select * from scott.dept;

2.配置MGR进程
GGSCI (dgdb1) 30> edit param mgr
port 7809

3.启动MGR进程
GGSCI (dgdb1) 31> start mgr

4.配置抽取进程
GGSCI (dgdb1) 33> add ext extc,tranlog,begin now
EXTRACT added.

5.配置抽取进程本地队列
GGSCI (dgdb1) 34> add exttrail /home/oracle/ogg/dirdat/lc,ext extc,megabytes 20
EXTTRAIL added.

6.配置抽取进程参数
GGSCI (dgdb1) 35> edit param extc

EXTRACT extc
setenv ( NLS_LANG = AMERICAN_AMERICA.ZHS16GBK )
setenv (ORACLE_SID = oggdb)
USERID goldengate, PASSWORD goldengate
EXTTRAIL /home/oracle/ogg/dirdat/lc
dynamicresolution
table testogg.dept;

7.配置传输进程
GGSCI (dgdb1) 36> add ext dpec,exttrailsource /home/oracle/ogg/dirdat/lc
EXTRACT added.

8.配置传输进程远程队列
GGSCI (dgdb1) 37> add rmttrail /home/oracle/ogg/dirdat/rc,ext dpec,megabytes 20
RMTTRAIL added.

9.配置传输进程参数
GGSCI (dgdb1) 38> edit param dpec

extract dpec
setenv ( NLS_LANG = AMERICAN_AMERICA.ZHS16GBK )
passthru
rmthost 192.168.162.81,mgrport 7809, compress
rmttrail /home/oracle/ogg/dirdat/rc
dynamicresolution
table testogg.dept;

10.添加表级附加日志
GGSCI (dgdb1) 40> dblogin userid goldengate, password goldengate
Successfully logged into database.

GGSCI (dgdb1) 41> add trandata testogg.dept

11.启动抽取进程
GGSCI (dgdb1) 42> start extc

Sending START request to MANAGER ...
EXTRACT EXTC starting

12.启动传输进程
GGSCI (dgdb1) 43> start dpec

Sending START request to MANAGER ...
EXTRACT DPEC starting

13.查看源端进程状态
GGSCI (dgdb1) 44> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     DPEC        00:00:00      00:01:19
EXTRACT     RUNNING     EXTC        00:01:45      00:00:07

14.获取当前数据库scn
SQL> select current_scn from v$database;

CURRENT_SCN
-----------
    1106419

15.根据当前SCN导出表数据
[oracle@dgdb1 ogg]$ expdp testogg/oracle directory=oggdir dumpfile=oggtest_dept.dmp logfile=oggtest_dept.log tables=dept flashback_scn=1106419

16.把导出文件传输到目标端
[oracle@dgdb1 ogg]$ scp /home/oracle/oggtest_dept.dmp oracle@dgdb2:/home/oracle

17.目标端创建用户并授予权限（测试给的dba权限）
SQL> create user testogg identified by oracle account unlock;

User created.

SQL> grant dba to testogg;

Grant succeeded.

18.目标端导入表数据
[oracle@dgdb2 ~]$ impdp testogg/oracle directory=oggdir dumpfile=oggtest_dept.dmp logfile=oggtest_dept.log tables=dept

19.配置投递进程
GGSCI (dgdb2) 28> add rep repc,exttrail /home/oracle/ogg/dirdat/rc,nodbcheckpoint
REPLICAT added.

20.配置投递进程参数
GGSCI (dgdb2) 29> edit param repc

replicat repc
setenv ( NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)
setenv (ORACLE_SID = destdb)
userid goldengate, password goldengate
reperror default,abend
discardfile /home/oracle/ogg/dirrpt/repc.dsc,append, megabytes 10
assumetargetdefs
dynamicresolution
map testogg.dept, target testogg.dept;

21.启动投递进程
GGSCI (dgdb2) 31> start repc,aftercsn 1106419

Sending START request to MANAGER ...
REPLICAT REPC starting

22.查看目标端进程状态
GGSCI (dgdb2) 32> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
REPLICAT    RUNNING     REPC        00:00:00      00:00:01

23.测试OGG同步
源端插入数据：
SQL> insert into dept values (50,'manage','golddentstat');
SQL> commit;
SQL> select * from dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON
        50 manage         golddentstat
		
目标端查询：
SQL> select * from dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON
        50 manage         golddentstat
		
源端更新数据：
SQL> update dept set loc='golddentstate' where deptno=50;

1 row updated.

SQL> commit;

SQL> select * from dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON
        50 manage         golddentstate

目标端查询数据：
SQL> select * from dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON
        50 manage         golddentstate
		
源端查看进程信息：
GGSCI (dgdb1) 47> stats extc

Sending STATS request to EXTRACT EXTC ...

Start of Statistics at 2022-07-02 01:48:15.

Output to /home/oracle/ogg/dirdat/lc:

Extracting from TESTOGG.DEPT to TESTOGG.DEPT:

*** Total statistics since 2022-07-02 01:29:38 ***
        Total inserts                                      1.00
        Total updates                                      1.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

*** Daily statistics since 2022-07-02 01:29:38 ***
        Total inserts                                      1.00
        Total updates                                      1.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

*** Hourly statistics since 2022-07-02 01:29:38 ***
        Total inserts                                      1.00
        Total updates                                      1.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

*** Latest statistics since 2022-07-02 01:29:38 ***
        Total inserts                                      1.00
        Total updates                                      1.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

End of Statistics.


GGSCI (dgdb1) 48> stats dpec

Sending STATS request to EXTRACT DPEC ...

Start of Statistics at 2022-07-02 01:48:21.

Output to /home/oracle/ogg/dirdat/rc:

Extracting from TESTOGG.DEPT to TESTOGG.DEPT:

*** Total statistics since 2022-07-02 01:29:38 ***
        Total inserts                                      1.00
        Total updates                                      1.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

*** Daily statistics since 2022-07-02 01:29:38 ***
        Total inserts                                      1.00
        Total updates                                      1.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

*** Hourly statistics since 2022-07-02 01:29:38 ***
        Total inserts                                      1.00
        Total updates                                      1.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

*** Latest statistics since 2022-07-02 01:29:38 ***
        Total inserts                                      1.00
        Total updates                                      1.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

End of Statistics.


GGSCI (dgdb1) 49>

目标端查询进程信息：
GGSCI (dgdb2) 34> stats repc

Sending STATS request to REPLICAT REPC ...

Start of Statistics at 2022-07-02 01:48:54.

Replicating from TESTOGG.DEPT to TESTOGG.DEPT:

*** Total statistics since 2022-07-02 01:29:41 ***
        Total inserts                                      1.00
        Total updates                                      1.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

*** Daily statistics since 2022-07-02 01:29:41 ***
        Total inserts                                      1.00
        Total updates                                      1.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

*** Hourly statistics since 2022-07-02 01:29:41 ***
        Total inserts                                      1.00
        Total updates                                      1.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

*** Latest statistics since 2022-07-02 01:29:41 ***
        Total inserts                                      1.00
        Total updates                                      1.00
        Total deletes                                      0.00
        Total discards                                     0.00
        Total operations                                   2.00

End of Statistics.