oracle goldengate 必须追加日志,oracle goldengate DML配置

最新推荐文章于 2022-12-16 10:44:54 发布

转载最新推荐文章于 2022-12-16 10:44:54 发布 · 195 阅读

文章标签：

本文详细介绍了如何配置Oracle GoldenGate的Extract、Pump和Replicat进程，包括环境变量设置、本地和远程trail文件管理，以及DML操作测试。重点展示了从源端到目标端的完整配置流程，并处理了resetlogs后的问题重置步骤。

2. 配置Extract进程组

1) 编辑配置文件

edit params eora

extract eora

dynamicresolution

setenv

(NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252)

userid ogg,password

ogg

exttrail

/usr/oracle_11/app/ogg/dirdat/et

table ogg.*;

说明:

extract eora定义extract进程名字

dynamicresolution setenv设置环境变量

userid 登录数据库

exttrail指定本地trail文件地址

table 定义同步的表

2) 添加抽取进程

add extract eora, tranlog,begin now

3) 添加本地trail文件

add exttrail /usr/oracle_11/app/ogg/dirdat/et,extract eora

说明:

创建本地trail文件，主extract进程负责写这部分文件，pump负责把这部分文件传到目标服务器端。

4) 启动服务

start extract eora

GGSCI (ssbServer) 11> info all

Program Status Group Lag at Chkpt Time Since

Chkpt

MANAGER RUNNING

EXTRACT RUNNING EORA

00:00:00 00:02:58

检查是否启动到RUNNING

如果没有启动到RUNNING，查看日志ggserr.log检查问题

位置:/u01/app/oracle/ogg

3. 配置Pump进程组

1) 编辑配置文件

edit params pump_so

extract pump_so

dynamicresolution

passthru

rmthost 192.168.1.103,mgrport

7809,compress

rmttrail

E:\oracle\ogg\dirdat\pt

table ogg.*;

2) 添加pump进程

GGSCI (ssbServer)

13> add

extract pump_so,exttrailsource

/usr/oracle_11/app/ogg/dirdat/et

3) 添加远程trail文件

GGSCI (ssbServer) 14> add rmttrail

E:\oracle\ogg\dirdat\pt,extract pump_so

说明: 指定远程trail文件

4) 启动pump进程

GGSCI (ssbServer) 15> start extract pump_so

查看状态

GGSCI (ssbServer) 16> info all

Program Status Group Lag at Chkpt Time Since

Chkpt

MANAGER RUNNING

EXTRACT RUNNING EORA

00:00:00 00:00:01

EXTRACT RUNNING PUMP_SO

00:00:00 00:00:51

-------------源端配置完成--------

目标端配置

E:\oracle>cd ogg

E:\oracle\ogg>ggsci

GGSCI (songsb) 1> edit params

mgr

port 7809

dynamicportlist 7800-8000

autostart er *

autorestart extract *,waitminutes

2,resetminutes 5

lagreporthours 1

laginfominutes 3

lagcriticalminutes 5

purgeoldextracts

E:\oracle\ogg\dirdat\rt*,usecheckpoints,minkeepdays 3

GGSCI (songsb) 2> start mgr

Manager started.

查看状态

GGSCI (songsb) 3> info all

Program Status Group Lag at Chkpt Time Since

Chkpt

MANAGER RUNNING

2. 添加检查表

GGSCI (songsb) 1> dblogin userid

ogg,password ogg

Successfully logged into database.

GGSCI (songsb) 2> add checkpointtable

ogg.checkpoint

Successfully created checkpoint table

ogg.checkpoint.

GGSCI (songsb) 3> edit params

./GLOBALS

CHECKPOINTTABLE ogg.checkpoint

3. 配置目标端Peplicat进程组

1) 编辑配置文件

edit params repl

replicat repl

setenv

(ORACLE_SID=ORCL) 本例中有两个实例，所以定义了环境变量userid ogg,password ogg

assumetargetdefs

reperror

default,discard

discardfile

/u01/app/oracle/ogg/dirrpt/repl.dsc,append,megabytes

dynamicresolution

map hr.*, target hr.*;

2) 添加复制进程

add replicat repl,exttrail /u01/app/oracle/ogg/dirdat/pt,

CHECKPOINTTABLE ogg.checkpoint

GGSCI (songsb) 8> start repl

Sending START request to MANAGER

...

REPLICAT REPL starting

查看状态

GGSCI (songsb) 9> info all

Program Status Group Lag at Chkpt Time Since

Chkpt

MANAGER RUNNING

REPLICAT RUNNING REPL 00:00:00 00:00:04

ogg用户登录后，发现有两张表CHECKPOINT,CHECKPOINT_LOX

注1：ogg_11.1.1.1.2只有CHECKPOINT一张表。

注2：ogg_11.2.x.x.1有CHECKPOINT,CHECKPOINT_LOX两张表。

5. DML配置测试

1)源端,创建一个表create table test (id number,name

varchar(20))

2)目标端,创建一个表create table

test (id number,name varchar(20))

3)源端insert into test values

(1,'a')

4)查看目标端

select * From test

---------------------------------以上为dml的配置----------------------------------------

由于配置好后，源库执行了resetlogs操作后，golden无法正常工作,下面的重置过程

1.stop mgr

2.stop

eora

3.stop

pump_so

GGSCI (ssbServer) 27> dblogin userid

ogg,password ogg

Successfully logged into database.

GGSCI (ssbServer) 28> delete extract

eora

Deleted EXTRACT EORA.

GGSCI (ssbServer) 29> delete extract pump_so

Deleted EXTRACT PUMP_SO.

7.重建extract进程,原eora和pump_so的参数不变

GGSCI (ssbServer) 40> add extract eora,tranlog,begin

now

EXTRACT added.

GGSCI (ssbServer) 41> add exttrail

/usr/oracle_11/app/ogg/dirdat/et,extract eora

EXTTRAIL added.

GGSCI (ssbServer) 42> add extract pump_so,exttrailsource

/usr/oracle_11/app/ogg/dirdat/et

EXTRACT added.

GGSCI (ssbServer) 43> add rmttrail

E:\oracle\ogg\dirdat\pt,extract pump_so

RMTTRAIL added.

start mgr

start eora

start pump_so

GGSCI (ssbServer) 50> info all

Program Status

Group

Lag at

Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING

EORA 00:00:00

00:00:08

EXTRACT RUNNING

PUMP_SO 00:00:00 00:00:28