Database definitions files /u01/app/ogg/dirdef: created
Extract data files /u01/app/ogg/dirdat: created
Temporary files /u01/app/ogg/dirtmp: created
Stdout files /u01/app/ogg/dirout: created
注:建议所有Goldengate操作均在Goldengate安装目录下进行。
2、开启管理进程
(1)创建管理进程参数文件
GGSCI (irms156) 1> edit params mgr
port 7809
(2)启动管理器
GGSCI(irms156) 2> start mgr
Managerstarted.
GGSCI(irms156) 3> info mgr
Manager isrunning (IP port irms156.7809).
GGSCI(irms156) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
3、在源端开启补充日志
(1)Oracle-specificinstallation steps
Thefollowing steps are only required when GoldenGate will be capturing data fromthe server. Therefore it is only needed when you are installing GoldenGate forOracle as your environment.
ERROR: No viable tables matchedspecification.(注意不要有分号)
GGSCI (irms156) 11> add trandatascott.emp
Logging of supplemental redo dataenabled for table SCOTT.EMP.
GGSCI (irms156) 13> add trandatascott.salgrade
2013-05-14 14:29:47 WARNING OGG-00869 No unique key is defined for table'SALGRADE'. All viable columns will be used to represent the key, but may notguarantee uniqueness. KEYCOLS may beused to define the key.
Logging of supplemental redo dataenabled for table SCOTT.SALGRADE.
GGSCI (irms156) 14> add trandatascott.bonus
2013-05-14 14:30:12 WARNING OGG-00869 No unique key is defined for table 'BONUS'.All viable columns will be used to represent the key, but may not guaranteeuniqueness. KEYCOLS may be used to definethe key.
Logging of supplemental redo dataenabled for table SCOTT.BONUS.
GGSCI (irms156) 15> add trandatascott.dept
Logging of supplemental redo dataenabled for table SCOTT.DEPT.
GGSCI(irms156) 16> info trandata scott.emp
Logging ofsupplemental redo log data is enabled for table SCOTT.EMP.
Columnssupplementally logged for table SCOTT.EMP: EMPNO.