千家信息网

怎么进行ogg配置

发表于:2025-01-23 作者:千家信息网编辑
千家信息网最后更新 2025年01月23日,本篇文章给大家分享的是有关怎么进行ogg配置,小编觉得挺实用的,因此分享给大家学习,希望大家阅读完这篇文章后可以有所收获,话不多说,跟着小编一起来看看吧。Ogg配置源库端 首先要是归档模式, 要开启数
千家信息网最后更新 2025年01月23日怎么进行ogg配置

本篇文章给大家分享的是有关怎么进行ogg配置,小编觉得挺实用的,因此分享给大家学习,希望大家阅读完这篇文章后可以有所收获,话不多说,跟着小编一起来看看吧。

Ogg配置

源库端 首先要是归档模式, 要开启数据库最小附加日志模式,和所需同步表的补全日志

命令如下

Sql > select supplemental_log_data_min from v$database;

--显示为no 表示未开启

Sql> alter database add supplemental log data;

--开启数据库级别的最小附加日志模式

Sql >select force_logging from v$database;

--查看是否开启了强制日志模式,以免丢失数据

Sql> Alter database force logging;

--开启日志强制模式

Sql> alter table add supplemental log data (primary key) columns;

节点一:

alter database force logging;

alter database add supplemental log data;

alter table scott.t1 add supplemental log data (primary key) columns;

节点2:

alter database force logging;

alter database add supplemental log data;

alter table scott.t2 add supplemental log data (primary key) columns;

alter table scott.t3 add supplemental log data (primary key) columns;

create directory dp_dir as '/home/oracle/expdp/';

创建goldengate用户并赋予权限:

create user goldengate identified by goldengate;

grant connect,resource to goldengate;

grant delete any table to goldengate;

grant update any table to goldengate;

grant insert any table to goldengate;

grant select any table to goldengate;

grant SELECT ANY DICTIONARY to goldengate;

--开启基于检查点的复制

Ggsic>dblogin userid goldengate,password goldengate

edit param ./GLOBALS

checkpointtable goldengate.checkpoint

然后保存退出,

add checkpointtable goldengate.checkpoint

ogg:

主进程配置

edit param mgr

PORT 7801

DYNAMICPORTLIST 7802-7820

Purgeoldextracts /home/oracle/ogg/dirdat/*/* USECHECKPOINTS,MINKEEPHOURS 10

AUTORESTART EXTRACT *,WAITMINUTES 2,RETRIES 5

节点一:

新增抽取进程:

edit param ext-t1

extract ext-t1

userid goldengate,password goldengate

exttrail /home/oracle/ogg/dirdat/scott/es

dynamicresolution

WARNLONGTRANS 1h,CHECKINTERVAL 3m

table scott.t1;

添加进程

add extract ext-t1,tranlog,begin now

添加本地队列

add exttrail /home/oracle/ogg/dirdat/scott/es,extract ext-t1, megabytes 1000

新增投递进程:

edit param pp-t1

extract pp-t1

userid goldengate ,password goldengate

RMTHOST 172.18.0.139, MGRPORT 7801,COMPRESS

rmttrail /home/oracle/ogg/dirdat/scott/t1

dynamicresolution

table scott.t1;

添加进程

add extract pp-t1,exttrailsource /home/oracle/ogg/dirdat/scott/es ,begin now

--添加远端队列

add rmttrail /home/oracle/ogg/dirdat/scott/t1, extract pp-t1,megabytes 1000

节点二:

新增抽取进程:

edit param ext-t2

extract ext-t2

userid goldengate,password goldengate

exttrail /home/oracle/ogg/dirdat/scott/es

dynamicresolution

WARNLONGTRANS 1h,CHECKINTERVAL 3m

table scott.t2;

table scott.t3;

添加进程

add extract ext-t2,tranlog,begin now

添加本地队列

add exttrail /home/oracle/ogg/dirdat/scott/es,extract ext-t2, megabytes 1000

新增投递进程:

edit param pp-t2

extract pp-t2

userid goldengate ,password goldengate

RMTHOST 172.18.0.139, MGRPORT 7801,COMPRESS

rmttrail /home/oracle/ogg/dirdat/scott/t2

dynamicresolution

table scott.t2;

table scott.t3;

添加进程

add extract pp-t2,exttrailsource /home/oracle/ogg/dirdat/scott/es ,begin now

--添加远端队列

add rmttrail /home/oracle/ogg/dirdat/scott/t2, extract pp-t2,megabytes 1000

目标端:

新增复制进程1:

edit param rp-t1

replicat rp-t1

userid goldengate,password goldengate

assumetargetdefs

HANDLECOLLISIONS

reperror default,discard

discardfile /home/oracle/ogg/dirdat/scott/t1.dsc,append,megabytes 1000

map scott.t1, target scott.t1;

新增复制进程:

add replicat rp-t1,exttrail /home/oracle/ogg/dirdat/scott/t1,begin now,checkpointtable goldengate.checkpoint

新增复制进程2:

edit param rp-t2

replicat rp-t2

userid goldengate,password goldengate

assumetargetdefs

HANDLECOLLISIONS

reperror default,discard

discardfile /home/oracle/ogg/dirdat/scott/t2.dsc,append,megabytes 1000

map scott.t2, target scott.t2;

map scott.t3, target scott.t3;

新增复制进程:

add replicat rp-t2,exttrail /home/oracle/ogg/dirdat/tbs01/t2,begin now,checkpointtable goldengate.checkpoint

创建测试表:

create table scott.t1 as select * from scott.emp;

alter table scott.t1 add constraint t1_pk primary key(empno)

create table scott.t2 as select * from scott.emp;

alter table scott.t2 add constraint t2_pk primary key(empno);

create table scott.t3 as select * from scott.emp;

alter table scott.t3 add constraint t3_pk primary key(empno);

目标库建立相应表结构:

create table scott.t1 as select * from scott.emp where 1=2;

alter table scott.t1 add constraint t1_pk primary key(empno)

create table scott.t2 as select * from scott.emp where 1=2;

alter table scott.t2 add constraint t2_pk primary key(empno);

create table scott.t3 as select * from scott.emp where 1=2;

alter table scott.t3 add constraint t3_pk primary key(empno);

expdp/impdp导出导入测试表数据。

启动进程:

1、 分别在各个源端和目标端启动start mgr

2、 启动各个源端抽取和投递进程

3、 数据导入目标端后,启动目标端复制进程

4、 使用info all查看各个进程状态,正常为running

5、 若出错,使用view report + 进程名查看报错并解决之。

测试:在源端表进行dml操作,观察目标端相应表数据变化。若两端一致,则ogg搭建成功

以上就是怎么进行ogg配置,小编相信有部分知识点可能是我们日常工作会见到或用到的。希望你能通过这篇文章学到更多知识。更多详情敬请关注行业资讯频道。

0