一.中央数据库ggs安装(1.26和1.27)
1.ggs软件源文件
/backup/ggs_soft/V22236-01.zip
2.安装
cd /backup/ggs_soft
unzip V22236-01.zip -d V22236-01
unzip ggs_Solaris_x86_64_ora10g_64bit.zip -d /backup/ggs_soft
tar -C /backup/ggs -xvf ggs_Solaris_sparc_ora10g_64bit_v11_1_1_0_0_078.tar
二.索引数据库ggsggs安装(123.74)
1.ggs软件源文件
/backup/ggs_soft/ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
2.安装
cd /backup/ggs_soft
tar -C /backup/ggs -xvf ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
三.配置数据库相关环境
1.中央数据库配置
--打开强制日志
alter database force logging;
--将数据库附加日志打开
alter database add supplemental log data;
--必须关闭数据库回收站功能
alter system set recyclebin=off;
2.配制tns
ASM1=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = center-rac1-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ASM)
(INSTANCE_NAME=+ASM1)
)
)
ASM2=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = center-rac2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ASM)
(INSTANCE_NAME=+ASM2)
)
)
3.建表空间
--ggs原端
create tablespace ogg datafile '+WXXRDATA' size 100m autoextend on;
--ggs目标端
create tablespace ogg datafile '/wxxrdata3/wxxrdb/ogg01.dbf' size 100m autoextend on;
4.配置ogg用户
--创建用户
drop user ogg cascade;
create user ogg identified by h2bstr9def default tablespace ogg;
conn ogg/h2bstr9def
--create user goldengate identified by goldengate default tablespace users temporary tablespace temp quota unlimited on users ;
2.在源数数据授权
grant connect,resource to ogg;
grant create session,alter session to ogg;
grant select any dictionary,select any table to ogg;
grant alter any table to ogg;
--grant flashback any table to ogg;
--grant execute on dbms_flashback to ogg;
3.在目标数数据授权
--授于系统权限
grant connect,resource to ogg;
grant create session,alter session to ogg;
grant select any dictionary,select any table to ogg;
grant create table to ogg;
--授于同步对象的实体权限
grant insert,update,delete on product.attrs to ogg;
grant insert,update,delete on product.ogghb to ogg;
/***
grant dba to ogg;
***/
四.配置ogg目录和进程
1.建子目录和管理进程
--首先创建子目录
create subdirs
--编辑管理进程参数
edit params mgr
输入以下内容
port 7801
dynamicportlist 7802-7820
autorestart er *,retries 3,waitminutes 5,resetminutes 60
purgeoldextracts ./dirdat/la,usecheckpoints,minkeepfiles 10
purgeoldextracts ./dirdat/ra,usecheckpoints,minkeepfiles 10
purgeddlhistory minkeepdays 3,maxkeepdays 5,frequencyminutes 30
purgemarkerhistory minkeepdays 3, maxkeepdays 5, frequencyminutes 30
保存退出
--启动管理进程
start mgr
2.配置全局参数
1.全局参数
--修改配置文件
edit param globals
输入
ggschema ogg
保存退出
2.如果是目标数据库,还可与配置检查点进程
--修改配置文件
checkpointtable ogg.ogg_checkpoint
保存退出
--登录数据库
dblogin userid ogg,password h2bstr9def
--创建检查点进程表
add checkpointtable ogg.ogg_checkpoint
3.分别为源和目标数据库取得加密的用户名密码
--ogg用户
encrypt password h2bstr9def
输出如下
Encrypted password: AACAAAAAAAAAAAKAAJMIGHSDMCWDXGKEXBZDOAFBVFSEKBAI
--sys用户
encrypt password H2oisWater
输出如下
Encrypted password: AACAAAAAAAAAAAKAPHSERHOBZAGHOCZETIYHJHCECCRBYGXC
/***以下配置文件中将使用加密的用户名密码[只加密口令,不加密用户名]***/
4.在源数据库上配置主捕获进程并修改其参数(extract进程)
--登录数据库
dblogin userid ogg,password h2bstr9def
--增加捕获进程
add extract ecenter,tranlog,threads 2,begin 2012-10-15 19:23:29
--修改配置参数
edit params ecenter
输入以下内容
extract ecenter
--setenv (ORACLE_HOME=/oracle/product/10G)
--setenv (ORACLE_SID=LHXDB2)
userid ogg,password AACAAAAAAAAAAAKAAJMIGHSDMCWDXGKEXBZDOAFBVFSEKBAI,encryptkey default
tranlogoptions altarchivelogdest instance wxxrdb1 +WXXRRECV/wxxrdb,altarchivelogdest instance wxxrdb2 +WXXRRECV/wxxrdb
tranlogoptions asmuser sys@ASM1,asmpassword AACAAAAAAAAAAAKAPHSERHOBZAGHOCZETIYHJHCECCRBYGXC,encryptkey default
threadoptions maxcommitpropagationdelay 90000
exttrail ./dirdat/la
discardfile ecenter.dsc,append,megabytes 5
--ddl include mapped
--ddloptions addtrandata
fetchoptions ,usesnapshot,nouselatestversion,missingrow report
statoptions reportfetch
warnlongtrans 1H,checkinterval 5M
dynamicresolution
gettruncates
table product.attrs;
table product.ogghb;
保存退出
--配置主抽取进程对应的添加该extract对应的trail文件,用来存储抽取的数据.单个文件大小设置为100MB
add exttrail ./dirdat/la,extract ecenter,megabytes 100
--启动进程
start extract ecenter
--有错误的话使用以下语句查看原因
view report ecenter
5.在源数据库上配置次捕获进程并修改其参数(datadump进程)
--增加datadump进程
add extract dindexdb,exttrailsource ./dirdat/la
--修改配置参数
edit param dindexdb
输入以下内容
extract dindexdb
userid ogg,password AACAAAAAAAAAAAKAAJMIGHSDMCWDXGKEXBZDOAFBVFSEKBAI,encryptkey default
rmthost 192.168.1.74,mgrport 7801
rmttrail ./dirdat/ra
discardfile dindexdb.dsc,append,megabytes 5
passthru
gettruncates
table product.attrs;
table product.ogghb;
保存退出
--配置次抽取进程对应的添加该extract对应的trail文件,用来存储抽取的数据.单个文件大小设置为100MB
add rmttrail ./dirdat/rb extract dindexdb,megabytes 100
--启动进程
start extract dindexdb
--有错误的话使用以下语句查看原因
view report dindexdb
6.在目标数据库上配置接收进程
--登录数据库
dblogin userid ogg,password h2bstr9def
--检查附加日志是否打开
info trandata product.attrs
--增加附加日志
add trandata product.attrs
--增加投递进程(已经配置检查点进程)
add replicat rcenter exttrail ./dirdat/rb,checkpointtable ogg.ogg_checkpoint
--修改配置参数(注,我这个中配置Extract process那个示例对应的,所以这里的exttrail文件名正好是Extract process中定义的RMTTRAIL ./dirdat/la这点需要大家注意.)
edit param rcenter
输入以下内容
replicat rcenter
userid ogg,password AACAAAAAAAAAAAKAAJMIGHSDMCWDXGKEXBZDOAFBVFSEKBAI,encryptkey default
assumetargetdefs
discardfile ./dirdat/rcenter.dsc,append,megabytes 100
ddl include mapped
ddloptions report
batchsql
dboptions deferrefconst
--dboptions suppresstriggers
dboptions lobwritesize 102400
handlecollisions
ddlerror default discard retryop maxretries 5 retrydelay 20
reperror default,discard
gettruncates
map product.*, target product.*;
保存退出
--启动进程
start replicat rcenter
--检查结果
view report rcenter
四.检查
进程 info all
延时 lag
目标数据库下select * from ogg_checkpoint
1.ggs软件源文件
/backup/ggs_soft/V22236-01.zip
2.安装
cd /backup/ggs_soft
unzip V22236-01.zip -d V22236-01
unzip ggs_Solaris_x86_64_ora10g_64bit.zip -d /backup/ggs_soft
tar -C /backup/ggs -xvf ggs_Solaris_sparc_ora10g_64bit_v11_1_1_0_0_078.tar
二.索引数据库ggsggs安装(123.74)
1.ggs软件源文件
/backup/ggs_soft/ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
2.安装
cd /backup/ggs_soft
tar -C /backup/ggs -xvf ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
三.配置数据库相关环境
1.中央数据库配置
--打开强制日志
alter database force logging;
--将数据库附加日志打开
alter database add supplemental log data;
--必须关闭数据库回收站功能
alter system set recyclebin=off;
2.配制tns
ASM1=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = center-rac1-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ASM)
(INSTANCE_NAME=+ASM1)
)
)
ASM2=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = center-rac2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ASM)
(INSTANCE_NAME=+ASM2)
)
)
3.建表空间
--ggs原端
create tablespace ogg datafile '+WXXRDATA' size 100m autoextend on;
--ggs目标端
create tablespace ogg datafile '/wxxrdata3/wxxrdb/ogg01.dbf' size 100m autoextend on;
4.配置ogg用户
--创建用户
drop user ogg cascade;
create user ogg identified by h2bstr9def default tablespace ogg;
conn ogg/h2bstr9def
--create user goldengate identified by goldengate default tablespace users temporary tablespace temp quota unlimited on users ;
2.在源数数据授权
grant connect,resource to ogg;
grant create session,alter session to ogg;
grant select any dictionary,select any table to ogg;
grant alter any table to ogg;
--grant flashback any table to ogg;
--grant execute on dbms_flashback to ogg;
3.在目标数数据授权
--授于系统权限
grant connect,resource to ogg;
grant create session,alter session to ogg;
grant select any dictionary,select any table to ogg;
grant create table to ogg;
--授于同步对象的实体权限
grant insert,update,delete on product.attrs to ogg;
grant insert,update,delete on product.ogghb to ogg;
/***
grant dba to ogg;
***/
四.配置ogg目录和进程
1.建子目录和管理进程
--首先创建子目录
create subdirs
--编辑管理进程参数
edit params mgr
输入以下内容
port 7801
dynamicportlist 7802-7820
autorestart er *,retries 3,waitminutes 5,resetminutes 60
purgeoldextracts ./dirdat/la,usecheckpoints,minkeepfiles 10
purgeoldextracts ./dirdat/ra,usecheckpoints,minkeepfiles 10
purgeddlhistory minkeepdays 3,maxkeepdays 5,frequencyminutes 30
purgemarkerhistory minkeepdays 3, maxkeepdays 5, frequencyminutes 30
保存退出
--启动管理进程
start mgr
2.配置全局参数
1.全局参数
--修改配置文件
edit param globals
输入
ggschema ogg
保存退出
2.如果是目标数据库,还可与配置检查点进程
--修改配置文件
checkpointtable ogg.ogg_checkpoint
保存退出
--登录数据库
dblogin userid ogg,password h2bstr9def
--创建检查点进程表
add checkpointtable ogg.ogg_checkpoint
3.分别为源和目标数据库取得加密的用户名密码
--ogg用户
encrypt password h2bstr9def
输出如下
Encrypted password: AACAAAAAAAAAAAKAAJMIGHSDMCWDXGKEXBZDOAFBVFSEKBAI
--sys用户
encrypt password H2oisWater
输出如下
Encrypted password: AACAAAAAAAAAAAKAPHSERHOBZAGHOCZETIYHJHCECCRBYGXC
/***以下配置文件中将使用加密的用户名密码[只加密口令,不加密用户名]***/
4.在源数据库上配置主捕获进程并修改其参数(extract进程)
--登录数据库
dblogin userid ogg,password h2bstr9def
--增加捕获进程
add extract ecenter,tranlog,threads 2,begin 2012-10-15 19:23:29
--修改配置参数
edit params ecenter
输入以下内容
extract ecenter
--setenv (ORACLE_HOME=/oracle/product/10G)
--setenv (ORACLE_SID=LHXDB2)
userid ogg,password AACAAAAAAAAAAAKAAJMIGHSDMCWDXGKEXBZDOAFBVFSEKBAI,encryptkey default
tranlogoptions altarchivelogdest instance wxxrdb1 +WXXRRECV/wxxrdb,altarchivelogdest instance wxxrdb2 +WXXRRECV/wxxrdb
tranlogoptions asmuser sys@ASM1,asmpassword AACAAAAAAAAAAAKAPHSERHOBZAGHOCZETIYHJHCECCRBYGXC,encryptkey default
threadoptions maxcommitpropagationdelay 90000
exttrail ./dirdat/la
discardfile ecenter.dsc,append,megabytes 5
--ddl include mapped
--ddloptions addtrandata
fetchoptions ,usesnapshot,nouselatestversion,missingrow report
statoptions reportfetch
warnlongtrans 1H,checkinterval 5M
dynamicresolution
gettruncates
table product.attrs;
table product.ogghb;
保存退出
--配置主抽取进程对应的添加该extract对应的trail文件,用来存储抽取的数据.单个文件大小设置为100MB
add exttrail ./dirdat/la,extract ecenter,megabytes 100
--启动进程
start extract ecenter
--有错误的话使用以下语句查看原因
view report ecenter
5.在源数据库上配置次捕获进程并修改其参数(datadump进程)
--增加datadump进程
add extract dindexdb,exttrailsource ./dirdat/la
--修改配置参数
edit param dindexdb
输入以下内容
extract dindexdb
userid ogg,password AACAAAAAAAAAAAKAAJMIGHSDMCWDXGKEXBZDOAFBVFSEKBAI,encryptkey default
rmthost 192.168.1.74,mgrport 7801
rmttrail ./dirdat/ra
discardfile dindexdb.dsc,append,megabytes 5
passthru
gettruncates
table product.attrs;
table product.ogghb;
保存退出
--配置次抽取进程对应的添加该extract对应的trail文件,用来存储抽取的数据.单个文件大小设置为100MB
add rmttrail ./dirdat/rb extract dindexdb,megabytes 100
--启动进程
start extract dindexdb
--有错误的话使用以下语句查看原因
view report dindexdb
6.在目标数据库上配置接收进程
--登录数据库
dblogin userid ogg,password h2bstr9def
--检查附加日志是否打开
info trandata product.attrs
--增加附加日志
add trandata product.attrs
--增加投递进程(已经配置检查点进程)
add replicat rcenter exttrail ./dirdat/rb,checkpointtable ogg.ogg_checkpoint
--修改配置参数(注,我这个中配置Extract process那个示例对应的,所以这里的exttrail文件名正好是Extract process中定义的RMTTRAIL ./dirdat/la这点需要大家注意.)
edit param rcenter
输入以下内容
replicat rcenter
userid ogg,password AACAAAAAAAAAAAKAAJMIGHSDMCWDXGKEXBZDOAFBVFSEKBAI,encryptkey default
assumetargetdefs
discardfile ./dirdat/rcenter.dsc,append,megabytes 100
ddl include mapped
ddloptions report
batchsql
dboptions deferrefconst
--dboptions suppresstriggers
dboptions lobwritesize 102400
handlecollisions
ddlerror default discard retryop maxretries 5 retrydelay 20
reperror default,discard
gettruncates
map product.*, target product.*;
保存退出
--启动进程
start replicat rcenter
--检查结果
view report rcenter
四.检查
进程 info all
延时 lag
目标数据库下select * from ogg_checkpoint
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27042095/viewspace-758121/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27042095/viewspace-758121/