GoldenGate基本原理、安装过程和基本维护
目录 一、GoldenGate介绍 .......................................................................... 3
二、GoldenGate安装实施 .................................................................... 5
2.1创建GoldenGate软件安装目录 ................................................. 5
2.2 GoldenGate的管理用户 ........................................................... 5
2.3安装GoldenGate软件 .............................................................. 6
2.4设臵数据库归档模式 .................................................................. 6
2.5打开数据库的附加日志 ............................................................... 7
2.6开启数据库强制日志模式 ............................................................ 7
2.7创建GoldenGate管理用户 ........................................................ 7
2.8编辑GLOBALS参数文件 .......................................................... 8
2.9管理进程MGR参数配臵 ............................................................ 8
2.10抽取进程EXTN参数配臵 ......................................................... 9
2.11 传输进程DPEN参数配臵 ...................................................... 10
2.12建立OGG的DDL对象 ......................................................... 11
2.13 数据初始化 .......................................................................... 12
2.14 容灾端管理进程MGR参数配臵 .............................................. 14
2.15编辑GLOBALS参数文件 ...................................................... 15
2.16 容灾端复制进程REPN参数配臵 ............................................. 15
2.17创建复制进程repn ............................................................... 17
2.18启动生产端传输进程和容灾端复制进程 ..................................... 17
2.19测试场景.............................................................................. 17 三GoldenGate基本运维命令 ........................................................... 17
四、常见故障排除 .............................................................................. 18
评论0