oracle goldengate安装笔记

ORACLE GoldenGate安装测试

平台：REDHAT LINUX 6

DB：ORACLE 10G205

一、在源数据库操作系统上新增GoldenGate的用户，需要和oracle数据库用户在一个

组：

二、在源数据库的操作系统上安装GoldenGate软件

三、设置源数据库为归档模式，回收站为off（设置DDL复制需要），并设置为最细log

四、在源数据库上创建GoldenGate的账号，并赋权限

五、在目的主机DB2上新增GoldenGate的用户，需要和oracle数据库用户在一个组：

十一、配置GGS的manager 1

2

3

4

十二、验证结果

十三、问题总结：

源数据库不配置SUPPLEMENTAL_LOG_DATA_MIN为YES的话，extract会一直起不来，且为stopped状态

sys@RHDB> select SUPPLEMENTAL_LOG_DATA_MIN from v$database;

SUPPLEME

--------

NO

[ogg@RHDB-1 fbo_ggs_Linux_x64_ora10g_64bit]$ tail -4 ggserr.log

2012-05-31 13:33:28 ERROR OGG-00730 Oracle GoldenGate Capture for Oracle, ext1.prm: No minimum supplemental logging is enabled. This may cause extract process to handle key update incorrectly if key column is not in first row piece.

2012-05-31 13:33:28 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.

开启数据库的最细log模式：

sys@RHDB> alter database add supplemental log data;

Database altered.

sys@RHDB> select SUPPLEMENTAL_LOG_DATA_MIN from v$database;

SUPPLEME

--------

YES

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

源数据库配置SUPPLEMENTAL_LOG_DATA_MIN为YES，目的数据库不配的话，extract会一直起不来，且为ABENDED状态

GGSCI (RHDB-1) 11> start extract ext1

Sending START request to MANAGER ...

EXTRACT EXT1 starting

GGSCI (RHDB-1) 12> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT STOPPED EXT1 00:00:00 02:15:57

GGSCI (RHDB-1) 13> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT ABENDED EXT1 02:16:04 00:00:19

[ogg@RHDB-1 fbo_ggs_Linux_x64_ora10g_64bit]$ tail -10 ggserr.log

target directories:

/home/ogg/fbo_ggs_Linux_x64_ora10g_64bit/dirtmp.

2012-05-31 13:41:24 INFO OGG-01515 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioning to begin time May 31, 2012 11:25:26 AM.

2012-05-31 13:41:24 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, ext1.prm: Positioned to Sequence 104, RBA 24428048, SCN 0.0, May 31, 2012 11:25:26 AM.

2012-05-31 13:41:24 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 started.

2012-05-31 13:41:30 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, ext1.prm: Socket buffer size set to 27985 (flush size 27985).

2012-05-31 13:41:30 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, ext1.prm: No recovery is required for target file

/home/ogg/fbo_ggs_Linux_x64_ora10g_64bit/dirdat/lt000000, at RBA 0 (file not opened).

2012-05-31 13:41:30 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, ext1.prm: Output file /home/ogg/fbo_ggs_Linux_x64_ora10g_64bit/dirdat/lt is using format RELEASE 11.2. 2012-05-31 13:41:30 ERROR OGG-00717 Oracle GoldenGate Capture for Oracle, ext1.prm: Found unsupported in-memory undo record in sequence 104, at RBA 24428048, with SCN 0.1454118 (1454118) ... Minimum supplemental logging must be enabled to prevent data loss. 2012-05-31 13:41:30 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.

配置目的数据库的如下后，依然报错

sys@RHDB> alter database add supplemental log data;

Database altered.

[ogg@RHDB-1 fbo_ggs_Linux_x64_ora10g_64bit]$ tail -4 ggserr.log

2012-05-31 13:57:32 INFO OGG-01053 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery completed for target file /home/ogg/fbo_ggs_Linux_x64_ora10g_64bit/dirdat/lt000003, at RBA 1060.

2012-05-31 13:57:32 INFO OGG-01057 Oracle GoldenGate Capture for Oracle, ext1.prm: Recovery completed for all targets.

2012-05-31 13:57:32 ERROR OGG-00717 Oracle GoldenGate Capture for Oracle, ext1.prm: Found unsupported in-memory undo record in sequence 104, at RBA 24428048, with SCN 0.1454118 (1454118) ... Minimum supplemental logging must be enabled to prevent data loss. 2012-05-31 13:57:32 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.

重启配置源端的EXTRACT，不再报错：

GGSCI (RHDB-1) 30> alter extract ext1, tranlog, begin now

EXTRACT altered.

GGSCI (RHDB-1) 31> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT STOPPED EXT1 00:00:00 00:00:03

GGSCI (RHDB-1) 32> start EXTRACT ext1

Sending START request to MANAGER ...

EXTRACT EXT1 starting