ogg12c测试oracle 11.2.0.4同步
来源:互联网 发布:淘宝刷屏兼职是真的吗 编辑:程序博客网 时间:2024/04/30 00:32
本次实验oracle数据库为11.2.0.4
gg版本为:
Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 7 2014 09:14:25
1.源端安装
12c的gg采用oui图形界面运行runInstaller安装如下:
gg版本为:
Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Aug 7 2014 09:14:25
1.源端安装
12c的gg采用oui图形界面运行runInstaller安装如下:
在源端数据库内授权:
create user ggs identified by ggs;
grant connect,resource,unlimited tablespace to ggs;
grant execute on utl_file to ggs;
grant select any dictionary,select any table to ggs;
grant alter any table to ggs;
grant flashback any table to ggs;
SQL> alter database add supplemental log data;
Database altered.
SQL> alter database force logging;
GGSCI (bre1) 11> dblogin userid ggs,password ggs
Successfully logged into database.
2.目标端安装:
目标端和源端一样使用oui界面安装
create user ggs identified by ggs;
grant connect,resource,unlimited tablespace to ggs;
grant execute on utl_file to ggs;
grant select any dictionary,select any table to ggs;
grant alter any table to ggs;
grant flashback any table to ggs;
SQL> alter database add supplemental log data;
Database altered.
SQL> alter database force logging;
GGSCI (bre1) 11> dblogin userid ggs,password ggs
Successfully logged into database.
2.目标端安装:
目标端和源端一样使用oui界面安装
在数据库创建用户并授权:
create user ggt identified by ggt;
grant dba to ggt;
创建checkpointtable,在ogg home创建GLOBALS文件:
[oracle@bre2 oracle]$ cat GLOBALS
checkpointtable ggt.chkpt
GGSCI (bre2) 2> dblogin userid ggt,password ggt
Successfully logged into database.
GGSCI (bre2 as ggt@bre2) 3>
GGSCI (bre2 as ggt@bre2) 3>
GGSCI (bre2 as ggt@bre2) 3> add checkpointtable
No checkpoint table specified. Using GLOBALS specification (ggt.chkpt)...
Successfully created checkpoint table ggt.chkpt.
3.配置源端程序
一、配置extract进程:
GGSCI (bre1) 54> edit params ext_t1
Extract ext_t1
setenv(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
userid ggs@192.168.56.45/bre1,password ggs
exttrail dirdat/sp
table test.CJ_CW_CWSJ;
GGSCI (bre1) 18> add extract ext_t1,tranlog,begin now
EXTRACT added.
GGSCI (bre1) 20> add exttrail dirdat/sp,extract ext_t1,megabytes 100
EXTTRAIL added.
GGSCI (bre1) 21> start extract ext_t1
Sending START request to MANAGER ...
EXTRACT EXT_T1 starting
GGSCI (bre1) 22> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT_T1 00:00:00 00:02:03
由于是11.2.0.4版本,需要在数据库内设置参数:
ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;
GGSCI (bre1) 28> start extract ext_t1
Sending START request to MANAGER ...
EXTRACT EXT_T1 starting
GGSCI (bre1) 29> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT_T1 00:07:16 00:00:01
二、配置datapump进程:
GGSCI (bre1) 55> edit params dp_t1
extract dp_t1
passthru
rmthost 192.168.56.46 ,mgrport 7008
rmttrail dirdat/rp
table test.Cj_Cw_Cwsj;
GGSCI (bre1) 50> add extract dp_t1,exttrailsource dirdat/sp
EXTRACT added.
GGSCI (bre1) 51> add rmttrail dirdat/rp,extract dp_t1,megabytes 100
RMTTRAIL added.
GGSCI (bre1) 52> start ext dp_t1
Sending START request to MANAGER ...
EXTRACT DP_T1 starting
GGSCI (bre1) 53> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DP_T1 00:00:00 00:01:39
EXTRACT RUNNING EXT_T1 00:00:00 00:00:04
4.配置目标端程序
配置replicat进程:
GGSCI (bre2) 29> edit params rep_t1
replicat rep_t1
setenv(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
userid ggt,password ggt
handlecollisions
assumetargetdefs
map test.*,target test.*;
GGSCI (bre2) 7> add replicat rep_t1,exttrail dirdat/rp
REPLICAT added.
create user ggt identified by ggt;
grant dba to ggt;
创建checkpointtable,在ogg home创建GLOBALS文件:
[oracle@bre2 oracle]$ cat GLOBALS
checkpointtable ggt.chkpt
GGSCI (bre2) 2> dblogin userid ggt,password ggt
Successfully logged into database.
GGSCI (bre2 as ggt@bre2) 3>
GGSCI (bre2 as ggt@bre2) 3>
GGSCI (bre2 as ggt@bre2) 3> add checkpointtable
No checkpoint table specified. Using GLOBALS specification (ggt.chkpt)...
Successfully created checkpoint table ggt.chkpt.
3.配置源端程序
一、配置extract进程:
GGSCI (bre1) 54> edit params ext_t1
Extract ext_t1
setenv(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
userid ggs@192.168.56.45/bre1,password ggs
exttrail dirdat/sp
table test.CJ_CW_CWSJ;
GGSCI (bre1) 18> add extract ext_t1,tranlog,begin now
EXTRACT added.
GGSCI (bre1) 20> add exttrail dirdat/sp,extract ext_t1,megabytes 100
EXTTRAIL added.
GGSCI (bre1) 21> start extract ext_t1
Sending START request to MANAGER ...
EXTRACT EXT_T1 starting
GGSCI (bre1) 22> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EXT_T1 00:00:00 00:02:03
由于是11.2.0.4版本,需要在数据库内设置参数:
ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;
GGSCI (bre1) 28> start extract ext_t1
Sending START request to MANAGER ...
EXTRACT EXT_T1 starting
GGSCI (bre1) 29> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT_T1 00:07:16 00:00:01
二、配置datapump进程:
GGSCI (bre1) 55> edit params dp_t1
extract dp_t1
passthru
rmthost 192.168.56.46 ,mgrport 7008
rmttrail dirdat/rp
table test.Cj_Cw_Cwsj;
GGSCI (bre1) 50> add extract dp_t1,exttrailsource dirdat/sp
EXTRACT added.
GGSCI (bre1) 51> add rmttrail dirdat/rp,extract dp_t1,megabytes 100
RMTTRAIL added.
GGSCI (bre1) 52> start ext dp_t1
Sending START request to MANAGER ...
EXTRACT DP_T1 starting
GGSCI (bre1) 53> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DP_T1 00:00:00 00:01:39
EXTRACT RUNNING EXT_T1 00:00:00 00:00:04
4.配置目标端程序
配置replicat进程:
GGSCI (bre2) 29> edit params rep_t1
replicat rep_t1
setenv(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
userid ggt,password ggt
handlecollisions
assumetargetdefs
map test.*,target test.*;
GGSCI (bre2) 7> add replicat rep_t1,exttrail dirdat/rp
REPLICAT added.
0 0
- ogg12c测试oracle 11.2.0.4同步
- oracle 11.2.0.4 ogg for centos6.8安装及数据半同步测试
- OGG Director连接 OGG12c
- 同步测试
- 博客间同步测试
- 测试新浪微波同步
- 博客同步测试
- DG同步测试脚本
- 同步更新测试
- Oracle 11.2.0.4 升级到12.1.0.2 测试
- GoldenGate学习之旅-5(ogg12C的安装)
- oracle dblink-数据同步
- oracle数据同步
- oracle数据同步
- oracle数据库同步技术
- oracle数据同步
- oracle数据库同步技术
- oracle数据库同步技术
- 远程通信(RPC,Webservice,RMI,JMS、EJB、JNDI的区别)对比
- stl stack做一个字符串中的括号匹配
- Webview解析html源码
- 基于对话框的应用程序,点击按钮打开一个网页
- 生成1000万行7位数字文件(编程珠玑)
- ogg12c测试oracle 11.2.0.4同步
- Android布局
- 大数的阶乘
- bracktrack5r3安装+bt5r3下安装vmwaretools
- Java专题之IO
- 在生产环境部署CDH集群遇到的问题
- nginx nginx.conf配置文件
- makefile工程管理
- Android中HttpURLConnection的基础