目录1.安装配置GoldenGate............................................................................................................................................................................31.1.设置环境变量............................................................................................................................................................................31.1.1.官方资料..........................................................................................................................................................................31.1.2.源端10.34.1.1机器.........................................................................................................................................................71.1.3.源端10.34.1.1上增加tns解析.......................................................................................................................................81.1.4.修改10.34.1.1上ASM数据库的参数...........................................................................................................................91.1.5.目标端10.34.1.72机器..................................................................................................................................................101.2.安装GG(只在小机1和分析2上建).................................................................................................................................111.3.官方系统要求..........................................................................................................................................................................131.4.目标机器manager进程添加到Windows服务......................................................................................................................161.5.GoldenGate相关命令..............................................................................................................................................................171.6.数据库准备..............................................................................................................................................................................191.6.1.源数据库要开归档........................................................................................................................................................191.6.2.打开数据库级别的补充日志(supplementallog).....................................................................................................191.6.3.在源端和目标端创建GoldenGate管理用户,并授权................................................................................................201.6.4.官方技术要求................................................................................................................................................................211.6.5.数据库字符集检查........................................................................................................................................................271.7.在源端添加表级的transdata...................................................................................................................................................281.8.在目标端添加checkpoint表...................................................................................................................................................291.9.源端...