Oracle Golden Gate 安装指南

操作系统版本：
[gdcul3308 /desf04/esf/gguser]$ uname -a
Linux gdcul3308 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
数据库版本： 单节点
SYS@O02ESF1>select * from v$version where rownum<2;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
在开始安装前，要确保操作系统中已存在gguser这个id。
1. 下载GG软件包
到 http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html 下载相应操作系统的GG软件包，对应Linux系统的软件包如下：
ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar [Linux]
2. 解压GG软件包
把下载的软件包放在$GG_HOME目录下，然后：
[gdcul3308 /desf04/esf/gguser]$ setenv $GG_HOME /desf04/esf/gguser
[gdcul3308 /desf04/esf/gguser]$ cd $GG_HOME
[gdcul3308 /desf04/esf/gguser]$ pbrun -u gguser tar -xvof  ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar
3. 设置GG的环境变量
setenv ORACLE_HOME /desf02/esf/oracle/rdbms/dbh_11202_00
setenv ORACLE_SID O02ESF1
setenv ORACLE_BASE /desf02/esf/oracle
setenv PATH /desf02/esf/oracle/rdbms/dbh_11202_00/bin:$PATH
setenv TNS_ADMIN $ORACLE_HOME/network/admin
setenv LD_LIBRARY_PATH /desf04/esf/gguser/:$ORACLE_HOME/lib
setenv USERLIB $LD_LIBRARY_PATH
4. 创建GG文件目录
[gdcul3308 /desf04/esf/gguser]$ cd $GG_HOME
[gdcul3308 /desf04/esf/gguser]$ pbrun -u gguser ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.0.0 Build 078
Linux, x64, 64bit (optimized), Oracle 11 on Jul 28 2010 13:13:42

Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.

GGSCI (gdcul3308) 2> create subdirs

Creating subdirectories under current directory /desf04/esf/gguser

Parameter files                /desf04/esf/gguser/dirprm: created
Report files                   /desf04/esf/gguser/dirrpt: created
Checkpoint files               /desf04/esf/gguser/dirchk: created
Process status files           /desf04/esf/gguser/dirpcs: created
SQL script. files               /desf04/esf/gguser/dirsql: created
Database definitions files     /desf04/esf/gguser/dirdef: created
Extract data files             /desf04/esf/gguser/dirdat: created
Temporary files                /desf04/esf/gguser/dirtmp: created
Veridata files                 /desf04/esf/gguser/dirver: created
Veridata Lock files            /desf04/esf/gguser/dirver/lock: created
Veridata Out-Of-Sync files     /desf04/esf/gguser/dirver/oos: created
Veridata Out-Of-Sync XML files /desf04/esf/gguser/dirver/oosxml: created
Veridata Parameter files       /desf04/esf/gguser/dirver/params: created
Veridata Report files          /desf04/esf/gguser/dirver/report: created
Veridata Status files          /desf04/esf/gguser/dirver/status: created
Veridata Trace files           /desf04/esf/gguser/dirver/trace: created
Stdout files                   /desf04/esf/gguser/dirout: created
5. 创建gguser schema
以sysdba登陆数据库，首先创建tablespace GG_TBS，用于存放gguser用户数据：
CREATE TABLESPACE "GG_TBS"
DATAFILE '/desf02/esf/o02esf1starter/gg_tbs.O02ESF1' SIZE 200M
LOGGING ONLINE PERMANENT BLOCKSIZE 8K
EXTENT MANAGEMENT LOCAL UNIFORM. SIZE 128K DEFAULT NOCOMPRESS  SEGMENT SPACE MANAGEMENT AUTO;
接着创建gguser用户，密码为gguser1：
CREATE USER GGUSER IDENTIFIED BY gguser1
DEFAULT TABLESPACE GG_TBS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
QUOTA UNLIMITED ON GG_TBS;
最后把相应权限赋给gguser：
GRANT EXECUTE ON UTL_FILE TO GGUSER;
GRANT DBA, CONNECT, RESOURCE to GGUSER;
6. 创建密码加密文件
cd $GG_HOME
pbrun –u gguser ./ggsci ENCRYPT PASSWORD gguser1
得到加密后的密码gguser1为 AACAAAAAAAAAAAHAJIBENEGDMADEQGTH
7. 创建参数文件auth_include.prm 用于将来的extract和replicat登陆数据库
cd $GG_HOME
cd dirprm
pbrun -u gguser vi auth_include.prm
userid gguser, PASSWORD AACAAAAAAAAAAAHAJIBENEGDMADEQGTH, ENCRYPTKEY DEFAULT
8. 禁用recycle bin
对于11g: 需要重启才能生效
ALTER SYSTEM SET recyclebin = OFF scope=spfile;
对于10g:
Alter system set recyclebin=off;
9. 编辑GLOBALS文件
cd $GG_HOME
pbrun -u gguser vi GLOBALS
GGSCHEMA gguser
10.运行marker_setup脚本
GGUSER@O02ESF1>@marker_setup.sql

Marker setup script

You will be prompted for the name of a schema for the GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.

Enter GoldenGate schema name: gguser


Marker setup table script. complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to GGUSER

MARKER TABLE
-------------------------------
OK

MARKER SEQUENCE
-------------------------------
OK

Script. complete.
11. 运行ddl_setup脚本
SYS@O02ESF1>@ddl_setup

GoldenGate DDL Replication setup script

Verifying that current user has privileges to install DDL Replication...
Checking user sessions...

Check complete.



You will be prompted for the name of a schema for the GoldenGate database objects.
NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.

Enter GoldenGate schema name: gguser

You will be prompted for the mode of installation.
To install or reinstall DDL replication, enter INITIALSETUP
To upgrade DDL replication, enter NORMAL
Enter mode of installation: INITIALSETUP

Working, please wait ...
Spooling to file ddl_setup_spool.txt


Using GGUSER as a GoldenGate schema name, INITIALSETUP as a mode of installation.

Working, please wait ...

DDL replication setup script. complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to GGUSER

DDLORA_GETTABLESPACESIZE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

CLEAR_TRACE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

CREATE_TRACE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

TRACE_PUT_LINE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

INITIAL_SETUP STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

DDLVERSIONSPECIFIC PACKAGE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

DDLREPLICATION PACKAGE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

DDLREPLICATION PACKAGE BODY STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

DDL HISTORY TABLE
-----------------------------------
OK

DDL HISTORY TABLE(1)
-----------------------------------
OK

DDL DUMP TABLES
-----------------------------------
OK

DDL DUMP COLUMNS
-----------------------------------
OK

DDL DUMP LOG GROUPS
-----------------------------------
OK

DDL DUMP PARTITIONS
-----------------------------------
OK

DDL DUMP PRIMARY KEYS
-----------------------------------
OK

DDL SEQUENCE
-----------------------------------
OK

GGS_TEMP_COLS
-----------------------------------
OK

GGS_TEMP_UK
-----------------------------------
OK

DDL TRIGGER CODE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

DDL TRIGGER INSTALL STATUS
-----------------------------------
OK

DDL TRIGGER RUNNING STATUS
------------------------------------------------------------------------------------------------------------------------
ENABLED

STAYMETADATA IN TRIGGER
------------------------------------------------------------------------------------------------------------------------
OFF

DDL TRIGGER SQL TRACING
------------------------------------------------------------------------------------------------------------------------
0

DDL TRIGGER TRACE LEVEL
------------------------------------------------------------------------------------------------------------------------
0

LOCATION OF DDL TRACE FILE
------------------------------------------------------------------------------------------------------------------------
/desf02/esf/oracle/diag/rdbms/o02esf1/O02ESF1/trace/ggs_ddl_trace.log

Analyzing installation status...


STATUS OF DDL REPLICATION
------------------------------------------------------------------------------------------------------------------------
SUCCESSFUL installation of DDL Replication software components

Script. complete.
12. 运行role_setup脚本
SYS@O02ESF1>@role_setup

GGS Role setup script

This script. will drop and recreate the role GGS_GGSUSER_ROLE
To use a different role name, quit this script. and then edit the params.sql script. to change the gg_role parameter to the preferred name. (Do not run the script.)

You will be prompted for the name of a schema for the GoldenGate database object
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.

Enter GoldenGate schema name: gguser
SP2-0606: Cannot create SPOOL file "role_setup_spool.txt"
SP2-0606: Cannot create STORE file "role_setup_set.txt"

PL/SQL procedure successfully completed.


Role setup script. complete

Grant this role to each user assigned to the Extract, GGSCI, and Manager process

GRANT GGS_GGSUSER_ROLE TO

where is the user assigned to the GoldenGate processes.
13. 运行ddl_enable脚本
SYS@O02ESF1>@ddl_enable

Trigger altered.

14. 运行ddl_pin脚本
SYS@O02ESF1>@ddl_pin.sql gguser

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

15. 修改数据库参数
SYS@O02ESF1>alter database force logging;

Database altered.

SYS@O02ESF1>ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

Database altered.

SYS@O02ESF1>archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /desf02/esf/o02esf1dump/arch
Oldest online log sequence     9
Next log sequence to archive   11
Current log sequence           11
16. 配置manager
cd $GG_HOME/dirprm
pbrun -u gguser vi mgr.prm

--port that manager runs on
port 7909

--Forces manager to restart extract, datapump and replicat if they shut down
AUTORESTART ER *, RETRIES 12, WAITMINUTES 5, RESETMINUTES 60

--Manages trail files to conserve space
PURGEOLDEXTRACTS ./dirdat/O02ESF1/*, USECHECKPOINTS, MINKEEPFILES 10, FREQUENCYMINUTES 15

--Specifies to log the lag time as a warning in the event log
LAGCRITICALMINUTES 5

--Specifies how often to report lag info to the event log
LAGREPORTMINUTES 60
LAGINFOMINUTES 0
17.启动manager
GGSCI (gdcul3308) 1> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     STOPPED


GGSCI (gdcul3308) 2> start manager

Manager started.

GGSCI (gdcul3308) 5> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING

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

转载于:http://blog.itpub.net/26277071/viewspace-708943/