Oracle GoldenGate 安装配置全记录

最新推荐文章于 2021-04-05 11:15:29 发布

丑大狗

最新推荐文章于 2021-04-05 11:15:29 发布

阅读量1.4k

点赞数 1

分类专栏： ETL 从入门到删库文章标签： oracle goldengate oracle goldengate OGG

本文链接：https://blog.csdn.net/u011478909/article/details/52996362

版权

从入门到删库同时被 2 个专栏收录

13 篇文章 2 订阅

订阅专栏

ETL

5 篇文章 0 订阅

订阅专栏

1 安装OGG

1.1 上传OGG压缩包

解压压缩包

1.2 配置环境变量

.bash_profile中添加如下内容

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

1.3 创建OGG工作目录

GGSCI (rac01) 3> create subdirs

Creating subdirectories under current directory /home/oracle/ogg

Parameter files /home/oracle/ogg/dirprm: already exists

Report files /home/oracle/ogg/dirrpt: created

Checkpoint files /home/oracle/ogg/dirchk: created

Process status files /home/oracle/ogg/dirpcs: created

SQL script files /home/oracle/ogg/dirsql: created

Database definitions files /home/oracle/ogg/dirdef: created

Extract data files /home/oracle/ogg/dirdat: created

Temporary files /home/oracle/ogg/dirtmp: created

Stdout files /home/oracle/ogg/dirout: created

2 为OGG配置数据库

2.1 源端、目标端创建GGS用户

SQL> create tablespace ggs_tbs datafile size 50m;

Tablespace created.

SQL> create user ggs identified by ggs default tablespace ggs;

User created.

SQL> grant dba to ggs;

Grant succeeded.

2.2 源端、目标端开启force logging和辅助日志

SQL> alter database force logging;

Database altered.

SQL> alter database add supplemental log data;

Database altered.

2.3 源端、目标端支持sequence

GGSCI (rac01) 1> edit params ./globals

输入：ggschema ggs

SQL> @sequence

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

ggs

2.4 源端、目标端支持ddl复制

SQL> alter system set recyclebin=off deferred scope=both;

System altered.

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:ggs

SQL> @ddl_setup.sql

Oracle GoldenGate DDL Replication setup script

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

You will be prompted for the name of a schema for the Oracle 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 Oracle GoldenGate schema name:ggs

SQL> @role_setup.sql

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 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:ggs

GRANT GGS_GGSUSER_ROLE TO <loggedUser>

SQL> @?/rdbms/admin/dbmspool.sql

Package created.

Grant succeeded.

SQL> @ddl_pin ggs;

3 源端配置OGG

3.1 配置manager

GGSCI (rac01) 3> edit params mgr （空文件直接保存退出即可，除非默认端口7809被占用）

GGSCI (rac01) 4> start mgr

Manager started.

3.2 添加表级trandata

GGSCI (rac01) 8> DBLOGIN USERID ggs

Password:

Successfully logged into database.

GGSCI (rac01) 9> add trandata hr.test (表名test可以为*通配符)

2016-10-25 08:04:43 WARNING OGG-00869 No unique key is defined for table 'TEST'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

Logging of supplemental redo data enabled for table HR.TEST.