GoldenGate DB11gr2配置手册

源端数据库配置

1.1源端数据库打开Archive Log:

SQL>shutdown immediate;

SQL>startup mount;

SQL>alter database archivelog;

SQL>alter database open;

SQL>archive log list;

1.2源端数据库打开数据库级最小附加日志及force logging：

SQL>SELECT supplemental_log_data_min, force_logging FROM v$database;

SQL>alter database add supplemental log data;

SQL>alter database force logging;

切换日志以使附加日志生效：

SQL>ALTER SYSTEM switch logfile;

1.3 Enabling Oracle GoldenGate in the Database:

SQL> show parameter enable_goldengate_replication

SQL> alter system set enable_goldengate_replication = true scope=both;

在源端创建用户并授权

2.1在源端数据库创建GoldenGate用户：

SQL> create user ogg identified by ogg;

SQL>GRANT DBA to ogg;

SQL> BEGIN
  dbms_goldengate_auth.grant_admin_privilege
  (
    grantee => 'ogg',
    privilege_type => 'CAPTURE',
    grant_select_privileges => TRUE
  );
END;
/

3. 静默安装OGG

./runInstaller -silent -responseFile /u01/app/oracle/ogg/fbo_ggs_AIX_ppc_shiphome/Disk1/response/oggcore.rsp

响应文件实例：

####################################################################

## ##

## Specify values for the variables listed below to customize ##

## your installation. ##

## ##

## Each variable is associated with a comment. The comment ##

## can help to populate the variables with the appropriate ##

## values. ##

## ##

## IMPORTANT NOTE: This file should be secured to have read ##

## permission only by the oracle user or an administrator who ##

## own this installation to protect any sensitive input values. ##

## ##

####################################################################

#-------------------------------------------------------------------------------

# Do not change the following system generated value.

#-------------------------------------------------------------------------------

oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v12_1_2

################################################################################

## ##

## Oracle GoldenGate installation option and details ##

## ##

################################################################################

#-------------------------------------------------------------------------------

# Specify the installation option.

# Specify ORA12c for installing Oracle GoldenGate for Oracle Database 12c and

# ORA11g for installing Oracle GoldenGate for Oracle Database 11g

#-------------------------------------------------------------------------------

INSTALL_OPTION=ORA11g

#-------------------------------------------------------------------------------

# Specify a location to install Oracle GoldenGate

#-------------------------------------------------------------------------------

SOFTWARE_LOCATION=/u01/app/oracle/ogg122

#-------------------------------------------------------------------------------

# Specify true to start the manager after installation.

#-------------------------------------------------------------------------------

START_MANAGER=FALSE

#-------------------------------------------------------------------------------

# Specify a free port within the valid range for the manager process.

# Required only if START_MANAGER is true.

#-------------------------------------------------------------------------------

MANAGER_PORT=7809

#-------------------------------------------------------------------------------

# Specify the location of the Oracle Database.

# Required only if START_MANAGER is true.

#-------------------------------------------------------------------------------

DATABASE_LOCATION=/u01/app/oracle/product/11.2.0/dbhome_1

################################################################################

## ##

## Specify details to Create inventory for Oracle installs ##

## Required only for the first Oracle product install on a system. ##

## ##

################################################################################

#-------------------------------------------------------------------------------

# Specify the location which holds the install inventory files.

# This is an optional parameter if installing on

# Windows based Operating System.

#-------------------------------------------------------------------------------

INVENTORY_LOCATION=/home/oracle/gg/inventory

#-------------------------------------------------------------------------------

# Unix group to be set for the inventory directory.

# This parameter is not applicable if installing on

# Windows based Operating System.

#-------------------------------------------------------------------------------

UNIX_GROUP_NAME=oracle

4. 源端配置OGG进程

4.1配置OGG extract进程exthr

GGSCI> edit param exthr

extract exthr

userid ogg@orcl, password ogg

exttrail ./dirdat/tm

table hr.*;

4.2在mgr中添加extract进程

GGSCI> add extract exthr,tranlog,begin now

GGSCI> add exttrail ./dirdat/tm,extract exthr,megabytes 10

GGSCI>info extract exthr

4.3在OGG中添加表级附加日志

GGSCI>dblogin userid ogg password ogg

GGSCI> add trandata hr.*

4.5配置OGG datapump进程pumhr

GGSCI> edit param pumhr

extract pumhr

passthru

rmthost 192.168.56.102, mgrport 7909

rmttrail ./dirdat/pn

table hr.*;

4.6在mgr中添加datapump进程pumhr

GGSCI> add extract pumhr,exttrailsource ./dirdat/tm

GGSCI> add rmttrail ./dirdat/pn,extract pumhr,megabytes 10

5.目标数据库端配置

5.1目标数据库参数配置

SQL>alter system set enable_goldengate_replication = true scope=both;

5.2创建数据库用户并授权

SQL> create user ogg identified by ogg;

SQL>GRANT DBA to ogg;

SQL>BEGIN

dbms_goldengate_auth.grant_admin_privilege

(

grantee => 'ogg',

privilege_type => 'APPLY',

grant_select_privileges => TRUE

);

END;

6.目标端配置OGG进程

6.1配置OGG replicat进程rephr

GGSCI>edit param rephr

Replicat rephr

UserID ogg@orcl, password ogg

AssumeTargetDefs

ddl include all

DiscardFile dirrpt/rhr.dsc, Append

Map hr.*, Target hr.*;

6.2 配置checkpoint表

GGSCI>edit param ./GLOBALS

输入信息

CHECKPOINTTABLE ogg.ggs_checkpoint

GGSCI> dblogin userid ogg,password ogg;

GGSCI>add CHECKPOINTTABLE ogg.ggs_checkpoint

GGSCI>exit

6.3在mgr中添加replicat进程rephr

GGSCI> add replicat rephr, exttrail ./dirdat/pn

6.4 OGG 常用命令

info + 进程名查看进程运行状态

stats+ 进程名查看进程统计信息

edit param +进程编辑配置文件

start/stop + 进程名开启/停止进程

view report + 进程名查看报告日志信息

info xxx,showch

GoldenGate DB11gr2配置手册

推荐阅读