如何部署goldengate

这篇文章将为大家详细讲解有关如何部署goldengate，小编觉得挺实用的，因此分享给大家做个参考，希望大家阅读完这篇文章后可以有所收获。

一、安装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;

关于“如何部署goldengate”这篇文章就分享到这里了，希望以上内容可以对大家有一定的帮助，使各位可以学到更多知识，如果觉得文章不错，请把它分享出去让更多的人看到。