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
响应文件实例：
####################################################################
## Copyright(c) Oracle Corporation
2017. All rights reserved. ##
##
##
## 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