GoldenGate单向表DML同步(二)
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x64, 64bit (optimized), Oracle 11g on Oct 4 2011 23:49:46
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (dd1) 1> create subdirs
Creating subdirectories under current directory /data/oracle/ogg11
Parameter files /data/oracle/ogg11/dirprm: created
Report files /data/oracle/ogg11/dirrpt: created
Checkpoint files /data/oracle/ogg11/dirchk: created
Process status files /data/oracle/ogg11/dirpcs: created
SQL script files /data/oracle/ogg11/dirsql: created
Database definitions files /data/oracle/ogg11/dirdef: created
Extract data files /data/oracle/ogg11/dirdat: created
Temporary files /data/oracle/ogg11/dirtmp: created
Veridata files /data/oracle/ogg11/dirver: created
Veridata Lock files /data/oracle/ogg11/dirver/lock: created
Veridata Out-Of-Sync files /data/oracle/ogg11/dirver/oos: created
Veridata Out-Of-Sync XML files /data/oracle/ogg11/dirver/oosxml: created
Veridata Parameter files /data/oracle/ogg11/dirver/params: created
Veridata Report files /data/oracle/ogg11/dirver/report: created
Veridata Status files /data/oracle/ogg11/dirver/status: created
Veridata Trace files /data/oracle/ogg11/dirver/trace: created
Stdout files /data/oracle/ogg11/dirout: created
GGSCI (dd1) 2> exit
GoldenGate安装完成，以上配置安装两个节点都要执行。
4. 对源库进行设置
确认已经开启归档：
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /data/oracle/archivelog
Oldest online log sequence 7
Next log sequence to archive 9
添加附加日志：
SQL> alter database add supplemental log data;
Database altered.
SQL> alter system switch logfile;
System altered.
编辑源
数据库管理进程参数文件，输入端口号：
[oracle@dd1 ~]$ cd $ORACLE_BASE/ogg11
[oracle@dd1 ogg11]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x64, 64bit (optimized), Oracle 11g on Oct 4 2011 23:49:46
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (dd1) 1> edit params mgr
PORT 7809
启动管理进程：
GGSCI (dd1) 2> start mgr
Manager started.
查看管理进程信息：
GGSCI (dd1) 3> info mgr
Manager is running (IP port dd1.7809).
5. 对目标库进行设置
编辑目标库管理进程参数文件，输入端口：
[oracle@kf2 ~]$ cd $ORACLE_BASE/ogg11
[oracle@kf2 ogg11]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x64, 64bit (optimized), Oracle 11g on Oct 4 2011 23:49:46
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (kf2.calvin) 1> edit params mgr
-- this is configuration of this manager process
PORT 7809
启动管理进程：
GGSCI (kf2.calvin) 2> start mgr
Manager started.
查看管理进程信息：
GGSCI (kf2.c