ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 自己整理的OGG配置说明

自己整理的OGG配置说明

原创 Linux操作系统 作者:marvinoracle 时间:2011-06-06 18:07:42 0 删除 编辑

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配置完成

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24531354/viewspace-697226/,如需转载,请注明出处,否则将追究法律责任。

上一篇: DataGuard配置说明
下一篇: OGG配置参考文档
请登录后发表评论 登录
全部评论

注册时间:2010-09-02

  • 博文量
    67
  • 访问量
    181808