GoldenGate系列一:快速搭建单向同步GoldenGate环境
来源:互联网 发布:linux 百度云 编辑:程序博客网 时间:2024/06/04 18:35
1、环境准备
(1)下载安装包并解压至ORACLE_BASE
(2)修改环境变更
[oracle@irms156ogg]$ vi ~/.bashrcexportPATH=$ORACLE_HOME/bin:/u01/app/ogg:$PATH
(3)创建子目录
[oracle@irms157 ogg]$ ggsci GGSCI (irms157) 1> create subdirs Creating subdirectories under currentdirectory /u01/app/ogg Parameter files /u01/app/ogg/dirprm: alreadyexistsReport files /u01/app/ogg/dirrpt: createdCheckpoint files /u01/app/ogg/dirchk: createdProcess status files /u01/app/ogg/dirpcs: createdSQL script files /u01/app/ogg/dirsql: createdDatabase definitions files /u01/app/ogg/dirdef: createdExtract data files /u01/app/ogg/dirdat: createdTemporary files /u01/app/ogg/dirtmp: createdStdout files /u01/app/ogg/dirout: created
注:建议所有Goldengate操作均在Goldengate安装目录下进行。
2、开启管理进程
(1)创建管理进程参数文件
GGSCI (irms156) 1> edit params mgrport 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<source>environment.
[oracle@irms157 ogg]$ sqlplus /nolog SQL> conn / as sysdbaConnected.SQL> alter database add supplementallog data; Database altered. SQL> alter system switch logfile; System altered.
(2)为具体模式对象开启补充日志(Add supplemental logging)
GGSCI (irms156) 9> dblogin useridsystem, password Lu123456;Successfully logged into database. GGSCI (irms156) 10> add trandatascott.emp;ERROR: No viable tables matchedspecification.(注意不要有分号) GGSCI (irms156) 11> add trandatascott.emp Logging of supplemental redo dataenabled for table SCOTT.EMP. GGSCI (irms156) 13> add trandata scott.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 todefine the 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.
3、数据准备
(1)在目标端创建与源端一样的表
(2)把源端的初始数据导入至目标端
由于本实验采用scott模式,在每个oracle数据库均已默认安装,因此不再需要准备。第2步可使用datapump,goldengatedirect load, sql*loader等方法。
4、配置源端提取
(1)增加抽取组
GGSCI (irms156) 1> add extracteoragd, tranlog, begin now, threads 1EXTRACT added. GGSCI (irms156) 2> info extracteoragd EXTRACT EORAGD Initialized 2013-05-1414:58 Status STOPPEDCheckpoint Lag 00:00:00 (updated 00:00:13 ago)Log Read Checkpoint Oracle Redo Logs 2013-05-14 14:58:05 Thread 1, Seqno 0, RBA 0 SCN 0.0 (0)Log Read Checkpoint Oracle Redo Logs 2013-05-14 14:58:05 Thread 2, Seqno 0, RBA 0 SCN 0.0 (0)
(2)创建抽取进程参数文件
GGSCI (irms156) 3> edit params eoragd EXTRACT EORAGDUSERID system, PASSWORD Lu123456RMTHOST 10.252.48.155, MGRPORT 7809RMTTRAIL ./dirdat/gdTABLE scott.emp;TABLE scott.dept;TABLE scott.salgrade;TABLE scott.bonus;(3)Define the GoldenGate trailadd thetrail that will store the changes on the target.GGSCI (irms156) 8> add RMTTRAIL./dirdat/gd, EXTRACT EORAGDRMTTRAIL added.GGSCI(irms156) 9> info rmttrail * Extract Trail: ./dir/gd Extract: EORAGD Seqno: 0 RBA: 0 File Size: 5M(4)启动抽取进程并验证 GGSCI (irms156) 10> start extracteoragd Sending START request to MANAGER ...EXTRACT EORAGD starting GGSCI (irms156) 11> info extracteoragd, detailGGSCI(irms156) 12> view report eoragd
5、配置目标端检查点表
(1)配置全局参数文件并增加检查点表(checkpoint table)
GGSCI (irms155) 1> edit params./globalscheckpointtablescott.ggschkpt
(2)激活GLOBALS参数文件
直接退出再进入ggsci即可生效。
GGSCI (irms155) 2> exit
(3)增加检查点表
GGSCI (irms155) 1> dblogin useridsystem, password Lu123456Successfully logged into database. GGSCI (irms155) 3> addcheckpointtable scott.ggschkpt Successfully created checkpoint tablescott.ggschkpt.
6、配置目标端变更投递
(1)增加replicat组
GGSCI (irms155) 5> add replicatroranf, exttrail ./dirdat/gd, checkpointtable scott.ggschkptREPLICAT added.
与源端的配置保持一致。
(2)创建replicat参数文件
GGSCI (irms155) 7> edit params roranf REPLICAT RORANFUSERID system, PASSWORD Lu123456HANDLECOLLISIONSASSUMETARGETDEFSDISCARDFILE ./dirrpt/RORANF.DSC, PURGEMAP scott.emp, TARGET scott.emp;MAP scott.salgrade, TARGET scott.salgrade;MAP scott.bonus, TARGET scott.bonus;MAP scott.dept, TARGET scott.dept;
(3)启动replicat进程
GGSCI (irms155) 8> start replicatroranf Sending START request to MANAGER ...REPLICAT RORANF starting GGSCI (irms155) 9> info replicatroranf REPLICAT RORANF Last Started 2013-05-14 15:39 Status RUNNINGCheckpoint Lag 00:00:00 (updated 00:00:09 ago)Log Read Checkpoint File ./dirdat/nf000000 First Record RBA 0 GGSCI (irms155) 10> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING REPLICAT RUNNING RORANF 00:00:00 00:00:02
- GoldenGate系列一:快速搭建单向同步GoldenGate环境
- GoldenGate系列一:快速搭建单向同步GoldenGate环境
- GoldenGate系统二:快速搭建三方单向通信GoldenGate环境
- GoldenGate系统二:快速搭建三方单向通信GoldenGate环境
- GoldenGate 单向DDL同步
- GOLDENGATE DML单向同步
- 搭建GoldenGate的单向复制环境
- 搭建GoldenGate的单向复制环境
- GoldenGate单向表DML同步
- ORACLE GOLDENGATE DDL单向同步
- GoldenGate初体验(单向同步)
- Oracle11gR2_使用GoldenGate配置单向同步
- GoldenGate配置单向复制
- goldengate单向复制文档
- GoldenGate
- goldengate
- GoldenGate
- GoldenGate
- Libgdx中文社区开始招募版主了!
- C#制作WinForm控件
- Spring获得初始化容器
- CSS控制的内容超过容器宽度后显示省略号
- AspectJ切入点语法详解
- GoldenGate系列一:快速搭建单向同步GoldenGate环境
- C++标准库函数
- Chrome浏览器强制http重定向到https的简单方法
- ubuntu下ncurses如何禁用终端的快捷键
- linux 几个命令 strace gdb rz/sz supervise
- 自定义iOS的状态栏
- Unity3d GameObject 调用其它GameObject中的方法
- IOS开发之类目,延展,协议
- java过滤器四个实例