the Environment
###
四、配置ogg mgr进程
13、配置mgr进程[源端，目标端]
[oracle@source ogg]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.0.0 Build 078
Linux, x64, 64bit (optimized), Oracle 11 on Jul 28 2010 13:13:42
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
GGSCI (source) 1> edit params mgr ----添加如下两行内容
--This is the minimal configuration of manager process
PORT 7809
###通过系统命令查看刚才配置的，实际上将配置写入了一个文件
[oracle@source ogg]$ cd dirprm/
[oracle@source dirprm]$ pwd
/DBSoft/ogg/dirprm
[oracle@source dirprm]$ ls
mgr.prm
[oracle@source dirprm]$ cat mgr.prm
--This is the minimal configuration of manager process
PORT 7809
14、启动mgr，及查看mgr状态[源端、目标端]
GGSCI (source) 1> start mgr
Manager started.
GGSCI (source) 2> info mgr
Manager is running (IP port source.7809).
[oracle@source ogg]$ ps -ef|grep mgr
oracle 6185 1 0 16:14 ? 00:00:00 ./mgr PARAMFILE /DBSoft/ogg/dirprm/mgr.prm REPORTFILE /DBSoft/ogg/dirrpt/MGR.rpt PROCESSID MGR PORT 7809
15、查看mgr进程信息[源端、目标端]
GGSCI (source) 3> view report mgr
***********************************************************************
Oracle GoldenGate Manager for Oracle
Version 11.1.1.0.0 Build 078
Linux, x64, 64bit (optimized), Oracle 11 on Jul 28 2010 13:12:40
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
Starting at 2014-09-03 16:14:10
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Fri Jan 27 17:17:51 EST 2012, Release 2.6.18-308.el5
Node: source
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 6185
Parameters...
--This is the minimal configuration of manager process
PORT 7809
***********************************************************************
** Run Time Messages **
***********************************************************************
2014-09-03 16:14:10 INFO OGG-00983 Manager started (port 7809).
16、在源端链接oracle数据库并配置需要同步的表
GGSCI (source) 1> dblogin userid system, password oracle
GGSCI (source) 3> add trandata ggs.tcustmer
Successfully logged into database.
Logging of supplemental redo data enabled for table GGS.TCUSTMER.
GGSCI (source) 4> add trandata ggs.tcustord
Logging of supplemental redo data enabled for table GGS.TCUSTORD.
17、查看需要同步的表的信息
GGSCI (source) 6> info trandata ggs.*
Logging of supplemental redo log data is enabled for table GGS.TCUSTMER
Logging of supplemental redo log data is enabled for table GGS.TCUSTORD
####initLoad
五、配置ogg extract进程
18、源端配置extract抽取进程
GGSCI (source) 2> add extract einikk, SOURCEISTABLE
EXTRACT added.
GGSCI (source) 10> info extract *,tasks ----查看进程信息
EXTRACT EINIKK Initialized 2014-09-03 17:03 Status STOPPED
Checkpoint Lag Not Available
Log Read Checkpoint Not Available
First Record Record 0
Task SOURCEISTABLE
GGSCI (source) 3> edit params einik
--
-- GoldenGate Initial Data Capture
-- for TCUSTMER and TCUSTORD
--
EXTRACT EINIKK
USERID system , PASSWORD “oracle”
RMTHOST 192.168.7.21, MGRPORT 7809 ---远端的地址和端口
RMTTASK REPLICAT , GROUP RINIKK
TABLE ggs.TCUSTMER;
TABLE ggs.TCUSTORD;
19、目标端配置
GGSCI > add replicat rinikk,specialrun
GGSCI (source) 6> info replicat *,tasks
RE