自己整理的OGG配置说明

最新推荐文章于 2024-10-30 10:59:51 发布

ciyang1448

最新推荐文章于 2024-10-30 10:59:51 发布

阅读量156

点赞数

文章标签：数据库

1、更改权限
SQL> grant connect,resource,unlimited tablespace to ggusr;
SQL> grant execute on utl_file to ggusr;
2、执行DDL支持脚本
SQL> @$GGATE/marker_setup.sql
SQL> @$GGATE/ddl_setup.sql
SQL> @$GGATE/role_setup.sql
SQL> grant GGS_GGSUSER_ROLE to ggusr;
SQL> @$GGATE/ddl_enable.sql
3、安装GG软件
tar -xvof .tar
tar -xvf ../gg/ggs_Linux_x86_ora10g_32bit_v11_1_1_0_0_078.tar
cd /u01/gg11
ls -lF |grep / 就1个目录
GGSCI>CREATE SUBDIRS
4、添加，配置Extract进程(ext1)
ADD EXTRACT ext1, TRANLOG, BEGIN NOW
ADD EXTTRAIL /opt/u01/app/oracle/gg11/dirdat/ex, EXTRACT ext1, MEGABYTES 20
GGSCI (Z813) 20> ADD EXTRACT ext1 TRANLOG, BEGIN NOW
EXTRACT added.
GGSCI (Z813) 22> ADD EXTTRAIL /opt/u01/app/oracle/gg11/dirdat/ex, EXTRACT ext1, MEGABYTES 20
EXTTRAIL added.
GGSCI (Z814) 6> edit params ext1
extract ext1
setenv ( NLS_LANG = AMERICAN_AMERICA.ZHS16GBK )
userid ggusr, password ggusr
REPORT AT 01:59
reportrollover at 02:00
tranlogoptions rawdeviceoffset 0
TRANLOGOPTIONS CONVERTUCS2CLOBS
discardfile ./dirrpt/ext1.dsc,append, megabytes 10
DDL include all
ddloptions addtrandata,nocrossrename
gettruncates
exttrail /opt/u01/app/oracle/gg11/dirdat/ex
numfiles 3000
dynamicresolution
TABLE ggusr.*;
5、添加，配置Extract进程(expm)
ADD EXTRACT expm, EXTTRAILSOURCE /opt/u01/app/oracle/gg11/dirdat/ex, BEGIN now
ADD RMTTRAIL /opt/u01/app/oracle/gg11/dirdat/re, EXTRACT expm
(/u01/ggs/dirdata/re为远端接收目录,必须存在)
GGSCI (Z814) 6> edit params expm
extract expm
setenv ( NLS_LANG = AMERICAN_AMERICA.ZHS16GBK )
passthru
REPORT AT 01:59
reportrollover at 02:00
ram2G,transram 500M
rmthost 192.168.159.102, mgrport 7809, compress
rmttrail /opt/u01/app/oracle/gg11/dirdat/re
dynamicresolution
numfiles 3000
TABLE ggusr.*;

配置Remote端
6、添加，配置rep进程(rep1)
GGSCI (rac2) 45> dblogin userid ggusr,password ggusr
GGSCI (rac2) 46> add checkpointtable ggusr.checkpoint
ADD REPLICAT rep1, EXTTRAIL /opt/u01/app/oracle/gg11/dirdat/re, checkpointtable ggusr.checkpoint
GGSCI (Z814) 47> edit params rep1
replicat rep1
setenv ( NLS_LANG = AMERICAN_AMERICA.ZHS16GBK )
userid ggusr, password ggusr
sqlexec "Alter session set constraints=deferred"
REPORT AT 01:59
reportrollover at 02:00
reperror default,discard
discardfile ./dirrpt/rep1.dsc,append, megabytes 10
assumetargetdefs
allownoopupdates
dynamicresolution
numfiles 3000
--DDL &
INCLUDE ALL,EXCLUDE MAPPED OBJNAME "ggusr.*" &
EXCLUDE MAPPED OBJNAME "ggusr.t*" &
map ggusr.* , target ggusr.*;
ok配置完成