OGG11G安装配置文档 - 墨天轮文档

OGG11G安装配置文档

胡欢

2041

10页

19次

2019-09-24

10墨值下载

一、安装前准备

1.linux操作系统版本

Red Hat Enterprise Linux Server release 6.4

源库10.88.15.132 目标库：10.88.15.133

2.GoldenGate版本

Version 12.2.0.2.2 OGGCORE_12.2.0.2.0_PLATFORMS_170630.0419_FBO

3.oracle版本

11.2.0.4

注：ogg 12.2.+版本适用于oralce11g和oracle12c

二、先配置单向同步（含DDL)

（1）源端安装GoldenGate

1.创建用户

创建目录：

mkdir -p /ogg

chmod -R 777 /ogg

chown -R ogg:oinstall /ogg

创建ogg用户：

useradd -g oinstall -G dba ggate

设置用户密码：

passwd ggate

2.解压ogg软件

unzip 122022_fbo_ggs_Linux_x64_shiphome.zip

3.设置环境变量

su - ggate

vim .bash_profile

export ORACLE_BASE=/oracle/

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4

export ORACLE_SID=ogg

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/oracle/ggate

export GGATE=/ogg

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export PATH=$PATH:$ORACLE_HOME/bin:$GGATE

source .bash_profile 使环境变量生效

注：环境变量可直接在oracle用户下设置，加入以下变量

[oracle@localhost app]$ mkdir /u01/app/ogg

[oracle@localhost app]unzip 122022_fbo_ggs_Linux_x64_shiphome.zip

[oracle@localhost ~]$ vi .bash_profile

export GG_HOME=/ogg

export PATH=$ORACLE_HOME/bin:$GG_HOME:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$GG_HOME:/lib:/usr/lib

export PATH=$ORACLE_HOME/bin:$HOME/bin:$PATH:/ogg

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/ogg:/usr/lib

安装ogg在oracle用户下

(这种方法还没有测试，待测试）

4.安装ogg软件

图形化安装方法中，在software location部分选择环境变量中GGATE的值，不过要注意给GGATE目录适当的限；

Database Location部分就是ORACLE_HOME的值。

备注：图形化安装ogg不需要再另外创建ogg工作目录，已经创建好了。

ogg工作目录创建方法：

./ggsci 进入OGG控制台，执行create subdirs即可。

GGSCI (sfa-oracle-test02) 1> create subdirs

Creating subdirectories under current directory /ogg/product/12.2.0.2/dbhome_1

Parameter files /ogg/product/12.2.0.2/dbhome_1/dirprm: already exists

Report files /ogg/product/12.2.0.2/dbhome_1/dirrpt: already exists

Checkpoint files /ogg/product/12.2.0.2/dbhome_1/dirchk: already exists

Process status files /ogg/product/12.2.0.2/dbhome_1/dirpcs: already exists

SQL script files /ogg/product/12.2.0.2/dbhome_1/dirsql: already exists

Database definitions files /ogg/product/12.2.0.2/dbhome_1/dirdef: already exists

Extract data files /ogg/product/12.2.0.2/dbhome_1/dirdat: already exists

OGG

安装配置文档

2019年3月4日

9:40

分区

OGG11G

安装配置文档的第

页

Extract data files /ogg/product/12.2.0.2/dbhome_1/dirdat: already exists

Temporary files /ogg/product/12.2.0.2/dbhome_1/dirtmp: already exists

Credential store files /ogg/product/12.2.0.2/dbhome_1/dircrd: already exists

Masterkey wallet files /ogg/product/12.2.0.2/dbhome_1/dirwlt: already exists

Dump files /ogg/product/12.2.0.2/dbhome_1/dirdmp: already exists

为保证后面进程启动不会由于目录权限的问题而出错，这里先给各目录赋权

chmod -R 775 dir....

各目录用途如下：

点击这里

名字

用途

dirprm

存放OGG参数各的配置信息

dirrpt

存放进程报告文件

dirchk

存放检查点文件

dirpcs

存放进程状态文件

dirsql

存放SQL脚本文件

dirdef

存放DEFGEN工具生成的数据定义文件

dirdat

存放Trail文件，也就是Capture进程捕获的日志文件

dirtmp

当事物需要的内存超过已分配内存时，默认存储在这个目录

（2）目标端安装GoldenGate同上（安装步骤一样）

（3）配置源端数据库（目标数据库同样配置）

1.开启归档（如果归档没有开启需要开启）

alter system set log_archive_dest='/oradata/arch' scope=spfile; ------修改归档路径

alter system set db_recovery_file_dest='' scope=spfile; --关闭闪回

shutdown immediate;

startup mount;

alter database archivelog;

alter database open;

查看闪回是否关闭：

select flashback_on from v$database;

2.设置数据库force logging

SQL>select force_logging from v$database;

SQL>alter database force logging;

3.开启最小附加日志（DDL的话好开启数据库级别）

SQL>select supplemental_log_data_min from v$database; ----查看是否开启了最小附加日志模式

SQL>alter database add supplemental log data;

千万不要小看这步日志设置，其实在GoldenGate的配置中，这步是最容易出错的环节。如果开启DDL复制做冗灾备份，最好直接在数据库级别打开补全日志：

SQL>alter database add supplemental log data(primary key,unique,foreign key) columns;

检查一下，全是yes就ok

SQL>select supplemental_log_data_min,supplemental_log_data_pk,supplemental_log_data_ui from v$database;

4.源库关闭回收站

在执行上一步操作有一个温馨提示：‘NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.’ GoldenGate10G DDL不支持Oracle回

收站功能；本文提供的GoldenGate版本是11G；该操作也略；

SQL>show parameter recyclebin

SQL>alter system set recyclebin=off scope=spfile;

SQL>shutdown immediate;

SQL>startup;

SQL>show parameter recyclebin;

5.设置UNDO

SQL>alter system set undo_retention=86400;

UNDO_MANAGEMENT=AUTO

UNDO_RETENTION=86400

UNDO_RETENTION can be adjusted upward in high-volume environments.

注意：

For tables that contain

LOBs

, do one of the following:

Set the

LOB

storage clause to

RETENTION

. This is the default for tables that are created when

UNDO_MANAGEMENT

is set to

AUTO

If using

PCTVERSION

instead of

RETENTION

, set

PCTVERSION

to an initial value of 25. You can adjust it based on the fetch statistics that are reported with the

STATS EXTRACT

command (see Table 3-2). If

the value of the

STAT_OPER_ROWFETCH CURRENTBYROWID

STAT_OPER_ROWFETCH_CURRENTBYKEY

field in these statistics is high, increase

PCTVERSION

in increments of 10 until the statistics show

low values.

6.创建goldengate用户并授权

创建表空间：

CREATE TABLESPACE OGG DATAFILE

分区

OGG11G

安装配置文档的第

页

CREATE TABLESPACE OGG DATAFILE

'/oracle/oradata/ogg/ogg01.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED

NOLOGGING

ONLINE

EXTENT MANAGEMENT LOCAL AUTOALLOCATE

BLOCKSIZE 8K

SEGMENT SPACE MANAGEMENT AUTO

FLASHBACK ON;

创建用户：

CREATE USER GGATE

IDENTIFIED BY ggate

DEFAULT TABLESPACE OGG

TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

授权：

为易管理和维护统一将权限赋予角色ogg_role:

create role ogg_role;

grant CREATE SESSION,ALTER SESSION,ALTER SYSTEM,RESOURCE,SELECT ANY DICTIONARY,FLASHBACK ANY TABLE,SELECT ANY TABLE,SELECT ANY TRANSACTION,insert any table,update

any table,drop any table,CREATE TABLE to ogg_role;

grant select on dba_clusters to ogg_role;

grant select on v_$database to ogg_role;

grant select on sys.logmnr_buildlog to ogg_role;

grant execute on DBMS_FLASHBACK to ogg_role;

grant execute on DBMS_CAPTURE_ADM to ogg_role

grant execute on DBMS_STREAMS to ogg_role;

grant EXECUTE_CATALOG_ROLE to ogg_role;

grant ogg_role to ggate;

或者：

grant connect,resource,unlimited tablespace to ggate;

grant connect,resource,dba to ggate;

grant execute on utl_file to ggate;

grant select any dictionary,select any table to ggate;

grant alter any table to ggate;

grant flashback any table to ggate;

grant execute on DBMS_FLASHBACK to ggate;

grant insert any table to ggate;

grant delete any table to ggate;

grant update any table to ggate;

7.运行DDL同步需要的脚本

需要切换到该脚本所在的目录，然后进入oracle

cd /ogg/product/12.2.0.2/dbhome_1

sqlplus / as sysdba

SQL>@marker_setup.sql

Marker setup script

You will be prompted for the name of a schema for the Oracle GoldenGate database objects.

NOTE: The schema must be created prior to running this script.

NOTE: Stop all DDL replication before starting this installation.

Enter Oracle GoldenGate schema name:ggate

Marker setup table script complete, running verification script...

Please enter the name of a schema for the GoldenGate database objects:

Setting schema name to GGATE

MARKER TABLE

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

MARKER SEQUENCE

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

Script complete.

SQL>@ddl_setup.sql

Oracle GoldenGate DDL Replication setup script

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

分区

OGG11G

安装配置文档的第

页

of 10

10墨值下载

相关文档

评论