GoldenGate升级步骤_ogg11.1.1.1.1.2-优快云博客

本文链接：https://blog.youkuaiyun.com/JasonLiu_2012/article/details/8688208

本文介绍了Oracle GoldenGate的升级过程，通过GGSCI命令行工具，完成了replicat的添加和启动，并通过`info rep232 showch`命令检查了replicat的运行状态。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

公司现在使用的ogg版本为11.1.1.1.2，在RAC上使用存在不少BUG，所以决定升级至11.2.1.0.1。target端的ogg版本应该大于或者等于source端的ogg版本，否则存在一定隐患，所以最好先升级target端，然后再升级source端。升级步骤大概如下：

Target端：
(oracle 11.2.0.3 单实例)
1、停止相关进程，备份参数文件
先stop掉source端pump进程，等target端的replicat进程无lag，再将target端的所有进程都stop掉。备份好target端所有参数文件。

2、记录source端pump的checkpoint并删除该进程

GGSCI (ulecardrac1) 4> info pump232 showch

EXTRACT    PUMP232   Last Started 2013-03-08 17:15   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:09 ago)
Log Read Checkpoint  File /vol1/ogg/dirdat/uc000008
                     2013-03-12 10:12:23.000000  RBA 2780482

记录下checkpoint后，在source端删除掉pump进程。
等target端升级完成后，应添加配置新的pump进程直接从记录的checkpoint开始续传日志。

3、target端安装新软件并初始化
在target端的$GGATE目录下删除掉所有内容，再将11.2.1.0.1解压至该目录。
创建好subdirs，配置好mgr进程(采用之前备份好的mgr参数文件)，并添加checkpoint表。

4、source端添加配置pump进程
pump进程的参数文件并未删除，所以无需改动

GGSCI (ulecardrac1) 5> ADD EXTRACT pump232, EXTTRAILSOURCE /vol1/ogg/dirdat/uc,EXTSEQNO 8, EXTRBA 2780482
EXTRACT added.
GGSCI (ulecardrac1) 6> ADD RMTTRAIL /data/oracle/ogg/dirdat/ur, EXTRACT pump232,MEGABYTES 100
RMTTRAIL added.
GGSCI (ulecardrac1) 7> start extract pump232             //开启pump进程
GGSCI (ulecardrac1) 7> info pump232 showch               //查看pump232的状态，如果Startup Checkpoint和配置的一样则正常

5、Target端添加配置replicat进程
把之前备份好的参数文件拷贝至$GGATE/dirprm/下

GGSCI (wls113) 4> add replicat rep232, exttrail /data/oracle/ogg/dirdat/ur
REPLICAT added.
GGSCI (wls113) 6> start rep232
GGSCI (wls113) 11> info rep232 showch                    //查看rep232的运行状态。

Source端：
(oracle 11.2.0.3 RAC)
1、停止相关进程，备份参数文件
stop extract→stop pump→stop replicat，注意一定要等进程无lag再进行stop。最后stop掉source端的mgr。
备份好source端所有的参数文件。

2、记录下source端extract进程的checkpoin

GGSCI (ulecardrac1) 6> info ext232 showch

......
Current Checkpoint Detail:

Read Checkpoint #1

Oracle RAC Redo Log

Startup Checkpoint (starting position in the data source):
Thread #: 1
Sequence #: 697
RBA: 1138704
Timestamp: 2013-03-12 03:52:04.000000
SCN: 1.996857836 (5291825132)
Redo File: +DATA/ulecard/onlinelog/group_1.261.795019633

Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 1
Sequence #: 697
RBA: 98965008
Timestamp: 2013-03-12 13:48:36.000000
SCN: 1.998872097 (5293839393)
Redo File: +DATA/ulecard/onlinelog/group_1.261.795019633

Current Checkpoint (position of last record read in the data source):
Thread #: 1
Sequence #: 697
RBA: 98968464
Timestamp: 2013-03-12 13:48:43.000000
SCN: 1.998872171 (5293839467)
Redo File: +DATA/ulecard/onlinelog/group_1.261.795019633

......

Read Checkpoint #2

Oracle RAC Redo Log

Startup Checkpoint (starting position in the data source):
Thread #: 2
Sequence #: 719
RBA: 1146384
Timestamp: 2013-03-12 03:51:56.000000
SCN: 1.996857807 (5291825103)
Redo File: +DATA/ulecard/onlinelog/group_4.266.795019805

Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Thread #: 2
Sequence #: 720
RBA: 70858768
Timestamp: 2013-03-12 13:48:42.000000
SCN: 1.998872150 (5293839446)
Redo File: +DATA/ulecard/onlinelog/group_6.272.799495201

Current Checkpoint (position of last record read in the data source):
Thread #: 2
Sequence #: 720
RBA: 70859264
Timestamp: 2013-03-12 13:48:42.000000
SCN: 1.998872150 (5293839446)
Redo File: +DATA/ulecard/onlinelog/group_6.272.799495201
......

3、Target端删除replicat进程和rmttrail文件

4、Source端安装新软件并初始化
在source端的$GGATE目录下删除掉所有内容，再将11.2.1.0.1解压至该目录。
创建好subdirs，配置好mgr进程(采用之前备份好的mgr参数文件)，并开启相关表的附加日志。

5、Source端添加配置extract进程
把之前备份好的extract参数文件拷贝至$GGATE/dirprm/下

GGSCI (ulecardrac1) 32> add extract ext232, tranlog, begin now, threads 2
EXTRACT added.

GGSCI (ulecardrac1) 33> add exttrail /vol1/ogg/dirdat/uc, extract ext232, megabytes 100
EXTTRAIL added.

GGSCI (ulecardrac1) 34> alter extract ext232, tranlog, extseqno 697, extrba 98968464, thread 1 //对应Current Checkpoint
EXTRACT altered.

GGSCI (ulecardrac1) 35> alter extract ext232, tranlog, extseqno 720, extrba 70859264, thread 2 //对应Current Checkpoint
EXTRACT altered.

GGSCI (ulecardrac1) 36> ALTER EXTRACT ext232, IOEXTSEQNO 697, IOEXTRBA 98965008,thread 1 //对应Recovery Checkpoint

2013-03-12 15:21:13 INFO OGG-00988 WARNING: Unsupported operation. This might cause transactional inconsistency. Modifying input checkpoint #1, Oracle thread #1 of EXTRACT: ioseq = 697 iorba = 98965008.
Are you sure you want to continue? yes
EXTRACT altered.

GGSCI (ulecardrac1) 37> ALTER EXTRACT ext232, IOEXTSEQNO 720, IOEXTRBA 70858768,thread 2 //对应Recovery Checkpoint

2013-03-12 15:21:38 INFO OGG-00988 WARNING: Unsupported operation. This might cause transactional inconsistency. Modifying input checkpoint #2, Oracle thread #2 of EXTRACT: ioseq = 720 iorba = 70858768.
Are you sure you want to continue? yes
EXTRACT altered.

GGSCI (ulecardrac1) 38> info ext232 showch //check进程信息

GGSCI (ulecardrac1) 40> start ext232 //开启extract进程

GGSCI (ulecardrac1) 51> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EXT232 00:00:00 00:00:00

6、Source端添加pump进程并开启
采用之前备份好的参数文件

GGSCI (ulecardrac1) 58> add extract pump232, exttrailsource /vol1/ogg/dirdat/uc
EXTRACT added.

GGSCI (ulecardrac1) 60> add rmttrail /data/oracle/ogg/dirdat/ur, extract pump232, megabytes 100
RMTTRAIL added.

GGSCI (ulecardrac1) 62> start pump232
Sending START request to MANAGER ...
EXTRACT PUMP232 starting

GGSCI (ulecardrac1) 65> info pump232 showch

EXTRACT PUMP232 Last Started 2013-03-12 15:26 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:03 ago)
Log Read Checkpoint File /vol1/ogg/dirdat/uc000000
2013-03-12 15:26:47.000000 RBA 3522104

Current Checkpoint Detail:

Read Checkpoint #1

GGS Log Trail

Startup Checkpoint (starting position in the data source):
Sequence #: 0
RBA: 0
Timestamp: Not Available
Extract Trail: /vol1/ogg/dirdat/uc

Current Checkpoint (position of last record read in the data source):
Sequence #: 0
RBA: 3522104
Timestamp: 2013-03-12 15:26:47.000000
Extract Trail: /vol1/ogg/dirdat/uc

......

7、Target端添加replicat并开始
参数文件之前并未删除，所以无需编辑参数

GGSCI (dwdg1) 5> add replicat rep232, exttrail /data/oracle/ogg/dirdat/ur
REPLICAT added.

GGSCI (dwdg1) 7> start rep232
Sending START request to MANAGER ...
REPLICAT REP232 starting

GGSCI (dwdg1) 19> info rep232 showch

REPLICAT   REP232    Last Started 2013-03-12 15:32   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:00 ago)
Log Read Checkpoint  File /data/oracle/ogg/dirdat/ur000000
                     2013-03-12 15:54:48.374868  RBA 5321905


Current Checkpoint Detail:

Read Checkpoint #1

  GGS Log Trail

  Startup Checkpoint (starting position in the data source):
    Sequence #: 0
    RBA: 0
    Timestamp: Not Available
    Extract Trail: /data/oracle/ogg/dirdat/ur

  Current Checkpoint (position of last record read in the data source):
    Sequence #: 0
    RBA: 5321905
    Timestamp: 2013-03-12 15:54:48.374868
    Extract Trail: /data/oracle/ogg/dirdat/ur

心得：
1、target端的ogg版本需要大于或者等于source端ogg版本
2、source端如果是RAC结构，在升级后先add extract进程，然后分thread来进行alter，指定到原来的checkpoint(包括Recovery Checkpoint和Current Checkpoint)。