ITPub博客

首页 > 数据库 > Oracle > goldengate部署实施案例

goldengate部署实施案例

Oracle 作者:luckyfriends 时间:2017-09-08 22:04:01 0 删除 编辑

一、安装redhat4,安装步骤略

二、安装oracle10g 安装步骤略

三、安装goldengate,注意要选对版本

    1、源端安装配置

       1.1安装goldengate
        
         linux: mkdir /u01/oracle/ggate
                cd /u01/oracle/ggate

         通过ftp,将goldengate的zip软件上传到/u01/oracle/ggate

                unzip 解压,将生成一个tar文件

                tar -xvf *.tar

       1.2配置.bash_profile
         
               vi .bash_profile
               添加:
               export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/u01/oracle/ggate
               export GGATE_HOME=/u01/oracle/ggate

               注意LD_LIBRARY_PATH,那一行,可以在原来安装oracle的基础上添加在后面便可

               配置完,运行 source ~./bash_profile

       1.3创建goldengate目录

               cd /u01/oracle/ggate

               ./ggsci  (进入goldengate命令行界面)

              Oracle GoldenGate Command Interpreter for Oracle
              Version 11.1.1.0.0 Build 078
              Linux, x86, 32bit (optimized), Oracle 10 on Jul 28 2010 13:24:18
              Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved


               现在在goldengate命令行工作
              
               create subdirs

       1.4配置数据库归档模式,进入sql命令行(如果关闭,建议开启)

               sqlplus "/as sysdba"

               alter system set log_archive_format='%s_%t_%r.log' scope=spfile;
      
               alter system set log_archive_dest_1='location=/u02/oracle/arc';

               shutdown immediate;

               startup mount;

               alter database archivelog;

               alter database open;

               alter database force logging;

               ----取消用  alter database no force logging;

               这下可以看一下归档是否已经起来,archive log list

        1.5开启minimal supplemental logging

               alter database add supplemental log data(primary key,unique) columns;

              
        1.6关闭回收站

               alter system set recyclebin=off scope=spfile;
           

        1.7配置复制的DDL支持

                创建用户授权:

                create user ggate identified by ggate default tablespace users temporary tablespace temp quota unlimited on users;

                grant connect,resource,dba to ggate;

                grant execute on utl_file to ggate;

                grant restricted session to ggate;
              
                               
               @$GGATE_HOME/marker_setup.sql;

               SCHEMA:GGATE

               @$GGATE_HOME/ddl_setup.sql;

               这里要看清楚,选择输入,否则会有问题!

               @$GGATE_HOME/role_setup.sql;

               授予角色权力:
               grant GGS_GGSUSER_ROLE to ggate;

               @$GGATE_HOME/ddl_enable.sql;

         1.8创建源端用户(用于同步的用户)

                create user sender identified by ggate default tablespace users temporary tablespace temp quota unlimited on users;

                grant dba,connect,resource to ggate;

                grant select on v_$session to ggate;

    2、源端复制队列配置

         2.1配置manager

            cd /u01/oracle/ggate           

            ./ggsci   (进入goldengate命令行)


            edit params mgr

            输入:PORT 7809

            与vi操作基本相同

          2.2配置源端复制队列
            
             同样是在goldengate命令行里做

             add extract ext1, tranlog, begin now

             add exttrail /u01/oracle/ggate/dirdat/lt, extract ext1

             edit params ext1
             输入如下内容:
             extract ext1
             userid ggate, password ggate     
             rmthost 目标机, mgrport 7809
             rmttrail /u01/oracle/ggate/dirdat/lt
             ddl include mapped objname sender.*;
             table sender.*;

             到这里,可以用info all查看一下,

             关闭进程:
             stop mgr
             stop ext1

    到这里源端基本上配置完毕


    3、目标端安装配置

       3.1安装goldengate
        
         linux: mkdir /u01/oracle/ggate
                cd /u01/oracle/ggate

         通过ftp,将goldengate的zip软件上传到/u01/oracle/ggate

                unzip 解压,将生成一个tar文件

                tar -xvf *.tar

       3.2配置.bash_profile
         
               vi .bash_profile
               添加:
               export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/u01/oracle/ggate
               export GGATE_HOME=/u01/oracle/ggate

               注意LD_LIBRARY_PATH,那一行,可以在原来安装oracle的基础上添加在后面便可

               配置完,运行 source ~./bash_profile

       3.3创建goldengate目录

               cd /u01/oracle/ggate

               ./ggsci  (进入goldengate命令行界面)

              Oracle GoldenGate Command Interpreter for Oracle
              Version 11.1.1.0.0 Build 078
              Linux, x86, 32bit (optimized), Oracle 10 on Jul 28 2010 13:24:18
              Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved


               现在在goldengate命令行工作
              
               create subdirs

        3.4创建目标端用户

               create user ggate identified by ggate default tablespace users temporary tablespace temp quota unlimited on users;

               create user receiver identified by ggate default tablespace users temporary tablespace temp quota unlimited on users;(接收同步的用户)

                grant connect,resource,dba to ggate;

                grant execute on utl_file to ggate;

                grant restricted session to ggate;

                grant connect,resource,dba to receiver;

                grant select on v_$session to receiver;

        3.5配置replicat

               ./ggsci

               edit params ./GLOBALS

               输入:
               GGSCHEMA ggate
               CHECKPOINTTABLE ggate.checkpoint
              
               edit params mgr

               输入:PORT 7809
              
               在goldengate命令行登录数据库

                dblogin userid ggate,password ggate

                add checkpointtable ggate.checkpoint (增加检测点)

                add replicat rep1, exttrail /u01/oracle/ggate/dirdat/lt, checkpointtable ggate.checkpoint(增加同不队列)

                edit params rep1

                添加如下内容:
                replicat rep1
                ASSUMETARGETDEFS
                userid ggate, password ggate
                discardfile /u01/oracle/ggate/dirdat/rep1_discard.txt, append, megabytes 10
                DDL include all
                map sender.*, target receiver.*;


     到这里上标端配置基本结束


四、额外增加的一个步骤,我是这样做

      分别在源端、目标端增加
     
      mkdir -p /u01/oracle/ggate/dirdat/lt

五、在goldengate命令行开启

        源端:start manager
              start ext1


        目标:start manager
              start rep1

六、测试:

    源端:create table sender.test(empid number(4),names varchar2(10),oldage number(3));
   
    目标:select * from receiver.test;

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

请登录后发表评论 登录
全部评论

注册时间:2009-06-06

  • 博文量
    463
  • 访问量
    3142957