Windows平台OGG单向数据同步笔记（二）

1.实验环境

实验环境	源端软件版本	目标端软件版本
操作系统	Windows Server 2008 R2 64bit 192.168.1.1	Windows7专业版 64bit 192.168.1.2
数据库	Oracle 11.2.0.1.0	Oracle 11.2.0.1.0
OGG	OracleGoldenGate12.2.0.1.1	OracleGoldenGate12.2.0.1.1

    2.软件下载地址

      OGG下载地址：http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html；

    3.安装条件

      1）使用Administrator身份安装

      2）安装Microsoft Visual C++2010

    4.安装软件

      安装Oracle11g，安装位置为：C:\Oracle\product\11.2.0\dbhome_1；

      安装OGG，安装位置为：C:\OGG\product\12.1.2\oggcore_1。

    5.设置环境变量

      ORACLE_HOME=D:\app\Administrator\product\11.2.0\dbhome_1

      ORACLE_SID=ORCL

    6.ogg创建子目录

C:\OGG\product\12.1.2\oggcore_1>ggsci

OracleGoldenGate Command Interpreter for Oracle

Version12.2.0.1.1OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401

Windows x64(optimized), Oracle 11g on Dec 11 2015 17:32:51

Operatingsystem character set identified as GBK.

Copyright (C) 1995, 2015, Oracle and/or itsaffiliates. All rights reserved.

GGSCI (WIN-2WRATOWWKRQ) 1>create subdirs

    7.添加manager进行windows服务

      手动指定服务名GGMAR。

      用edit params ./GLOBALS命令（注意./GLOBALS为大写），进入编辑文件，输入下面内容。

       MGRSERVNAME GGMGR

          保存退出后，用installaddservice命令添加服务。

        C:\OGG\product\12.1.2\oggcore_1>install addservice

Service'GGMGR' created.

Installprogram terminated normally.

         8.配置数据库

      1）在源端库打开归档模式

SQL>archive log list

SQL> shutdown immediate

SQL> startup mount

SQL> alter database archivelog;

SQL> alter database open

      2）在源端库打开force logging

SQL>select force_logging from v$database;

FOR

---

NO

SQL> alter database force logging;

Database altered.

SQL> select force_logging fromv$database;

FOR

---

YES

      3）在源端库中打开supplemental log

SQL> selectsupplemental_log_data_min from v$database;

SUPPLEME

--------

NO

SQL> alter database addsupplemental log data;

Databasealtered.

 --切换日志，使更改生效

SQL> alter system switch logfile;

System altered.

SQL> selectsupplemental_log_data_min from v$database;

SUPPLEME

--------

YES

       4）在源端库中关闭回收站

SQL> show parameter recyclebin

NAME TYPE VALUE

------------- ----------- ------------------------------

recyclebin string on

SQL>show parameter recyclebin

NAME TYPE VALUE

------------- ----------- ------------------------------

recyclebin string on

SQL> alter system set recyclebin=off DEFERRED;

Systemaltered.

       5) 创建goldengate管理用户

           --在源端创建ggs用户

SQL> create user ggs identified byggs default tablespace users temporary tablespace temp;

SQL> grant connect ,resource,unlimitedtablespace to ggs;

SQL> grant execute on utl_file toggs;

SQL> grant select anydictionary,select any table to ggs;

SQL> grant alter any table to ggs;

SQL> grant flashback any table toggs;

SQL> grant execute ondbms_flashback to ggs;

   --在目标端创建ggs用户

SQL> create user ggs identified byggs default tablespace users temporary tablespace temp;

SQL> grant dba to ggs;

6）在源端添加表级的trandata

 GGSCI (WIN-2WRATOWWKRQ) 1> dblogin useridggs,password ggs

Successfully logged into database.

 GGSCI (WIN-2WRATOWWKRQ as ggs@orcl)2> add trandata  TEST.SYS_USER

Logging of supplemental redo dataenabled for table TEST.SYS_USER

注：表名可以使用通配符，如add trandata scott.*

       7）在目标端添加checkpoint表

           GGSCI (WIN-D4BMPDTTKAA) 1> view params./GLOBALS

MGRSERVNAME GGMGR

checkpointtable ggs.checkpoint

GGSCI (WIN-D4BMPDTTKAA) 2>dblogin useridggs,password ggs

Successfullylogged into database.

GGSCI (WIN-D4BMPDTTKAA) 3>add checkpointtableggs.checkpoint

Successfullycreated checkpoint table GGS.CHECKPOINT.

    9．配置goldengate进程组

       一般常用的进程组：

在源端：mgr进程，extract（抽取）进程，pump进程

在目标端：mgr进程，replicat（复制）

1）配置源端MGR管理进程

--配置参数文件

GGSCI (WIN-2WRATOWWKRQ) 3>edit params mgr

--添加以下内容保存退出

port 7500 --必须存在的参数

dynamicportlist 7501-7505

autorestart extract *,waitminutes2,retries 5

GGSCI (WIN-2WRATOWWKRQ) 4> start mgr

Starting Manager as service('GGMGR')...

Service started.

GGSCI (WIN-2WRATOWWKRQ) 5>view params mgr

port 7500

dynamicportlist 7501-7505

autorestart extract *,waitminutes2,retries 5

       2）配置源端Extract抽取进行组

--编辑添加extract进程配置文件

GGSCI (WIN-2WRATOWWKRQ) 6>view params eora

extract eora

dynamicresolution

userid ggs,password ggs

setenv(ORACLE_SID=ORCL)

exttrailC:\OGG\product\12.1.2\oggcore_1\dirdat\et

table TEST.SYS_USER;

--添加extract进程

GGSCI (WIN-2WRATOWWKRQ) 7> add extract eora,tranlog,begin now 

EXTRACT added.

--创建本地trail文件，extract进程组负责写这部分文件，pump进程负责读它：

GGSCI (WIN-2WRATOWWKRQ) 8>add exttrail C:\OGG\product\12.1.2\oggcore_1\dirdat\et,extracteora

EXTTRAIL added.

--启动extract进程，使用start eora或start ext eora或start extract eora

GGSCI (WIN-2WRATOWWKRQ) 9> start eora

       3）配置源端pump进程组

           -编辑添加pump进程配置文件

GGSCI (WIN-2WRATOWWKRQ) 10>view params pump_so

extract pump_so

Dynamicresolution

userid ggs,password ggs

rmthost 192.168.1.2, mgrport 7500

rmttrailC:\OGG\product\12.1.2\oggcore_1\dirdat\et

Table TEST.SYS_USER;

--添加pump进程

GGSCI (WIN-2WRATOWWKRQ) 11>add extractpump_so,exttrailsource C:\OGG\product\12.1.2\oggcore_1\dirdat\et

EXTTRAILadded.

--添加该rmttrail

GGSCI (WIN-2WRATOWWKRQ) 12>add rmttrail C:\OGG\product\12.1.2\oggcore_1\dirdat\et,extractpump_so

RMTTRAILadded.

--启动pump进程

GGSCI (WIN-VRO8RDT77CE) 51>start pump_so

       4）配置目标端MGR管理进程

           GGSCI(WIN-D4BMPDTTKAA) 2> view params mgr

port 7500

dynamicportlist 7501-7505

autostart er *

autorestart extract *,waitminutes2,retries 5

lagreporthours 1

laginfominutes 3

lagcriticalminutes 5

purgeoldextractsC:\OGG\product\12.1.2\oggcore_1\dirdat\et*,usecheckpoints,minkeepdays 3

           GGSCI(WIN-D4BMPDTTKAA) 3>start mgr

       5）配置目标端Replicat复制进程组

           --编辑添加Replicat进程配置文件

GGSCI (WIN-D4BMPDTTKAA) 4> view params repl

replicat repl

userid ggs,password ggs

assumetargetdefs

reperror default,discard

discardfile./dirrpt/repl.dsc,append,megabytes 50

dynamicresolution

MAP TEST.SYS_USER, targetTEST.SYS_USER;

--添加replicat进程

GGSCI (WIN-D4BMPDTTKAA) 5>add replicatrepl,exttrail C:\OGG\product\12.1.2\oggcore_1\dirdat\et,checkpointtableggs.checkpoint

REPLICATadded.

GGSCI (www-7d194fc9aa8) 25>start repl

    10.配置完成。

    11.常用命令

       1）启动服务

start 服务名

       2）编辑服务文件

           edit param 服务名

       3）查看服务日志

           view report 服务名

       4）查看服务运行状态

           info 服务名

       5）查看全部服务运行状态

           info all

       6）登录ogg用户

           dblogin userid ggs,password ggs