ogg升级部署(12C->19C)

环境:
Os:Centos 7
源端数据库:RAC 12.2.0.1.0
目的端数据库:11.2.0.4
原来版本:12.3.0.1.4
新版本: 19.1.0.0.4

 

 

1.停掉原来的ogg

这个过程模拟不停地写入数据
源端

GGSCI (rac01 as goldengate@slnngk1) 17> SEND EXTRACT extep LOGEND

Sending LOGEND request to EXTRACT EXTEP ...
NO

GGSCI (rac01) 10> stop extep
GGSCI (rac01) 13> stop dpep
GGSCI (rac01) 15> stop mgr

 

 

目的端

 

查看已经消费完停掉之前的trail文件后再停掉,可以查看具体的表是否有新数据写入,没有的话就停掉
GGSCI (ora11g) 9> SEND REPLICAT repep STATUS

Sending STATUS request to REPLICAT REPEP ...
  Current status: At EOF
  Sequence #: 117
  RBA: 18,009,511
  0 records in current transaction.
  
抽取进程当前状态为AT EOF,表示已抽取到trail文件的末尾,现在可以停止抽取进程

GGSCI (ora11g) 22> stop repep
GGSCI (ora11g) 23> stop mgr

 

 

 

 

2.这个时候源端和目的端的数据是不一致的

源端:
SQL> select count(1) from tb_test01;

  COUNT(1)
----------
    100000
    
目的端:
SQL> select count(1) from tb_test01;

  COUNT(1)
----------
     78982
     

 

3.记录下停掉时候的抽取、投递、复制进程的信息
源端：

GGSCI (rac01) 12> info extep

EXTRACT    EXTEP     Last Started 2025-11-04 10:40   Status STOPPED
Checkpoint Lag       00:00:03 (updated 00:01:31 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2025-11-04 10:47:36  Thread 1, Seqno 234, RBA 147620880
                     SCN 0.20742562 (20742562)
Log Read Checkpoint  Oracle Redo Logs
                     2025-11-04 10:48:14  Thread 2, Seqno 185, RBA 51693648
                     SCN 0.20749394 (20749394)

目的端:

GGSCI (ora11g as goldengate@ora11g) 8>DBLOGIN USERID goldengate, PASSWORD goldengate
GGSCI (ora11g as goldengate@ora11g) 8> info repep,detail

REPLICAT   REPEP     Last Started 2025-11-04 10:40   Status STOPPED
Checkpoint Lag       00:00:00 (updated 00:01:11 ago)
Log Read Checkpoint  File /goldengate12c_bak/dirdat/ep000000132
                     2025-11-04 10:48:14.526299  RBA 52314788

Current Log BSN value: 20654609

Last Committed Transaction CSN value: 20749394

 

这里以复制进程的scn开始抽取以及复制:20749394

 

 

##########################安装新版本的ogg################################
部署新的ogg
源端和目的端部署新版本的ogg,安装方法如下:
https://www.cnblogs.com/hxlasky/p/17118797.html

 

####################部署新的ogg#######################

源端
1.创建目录
[oracle@epidbhn goldengate19c]$ cd /goldengate19c
[oracle@epidbhn goldengate19c]$ ./ggsci
GGSCI (localhost.localdomain) 1> create subdirs

 

2.配置mgr
[oracle@epidbhn goldengate19c]$ cd /goldengate19c
[oracle@epidbhn goldengate19c]$ ./ggsci

 

3.拷贝参数文件到新版本的相应目录

源端

cp /goldengate12c/dirprm/*.prm /goldengate19c/dirprm/

目的端

cp /goldengate12c_bak/dirprm/*.prm /goldengate19c/dirprm/

 

4.目的端添加抽取进程和投递进程

抽取进程

ADD EXTRACT extep, TRANLOG, SCN 20749394,threads 2 
add EXTTRAIL ./dirdat/ep, EXTRACT extep, MEGABYTES 100

投递进程

ADD EXTRACT dpep, EXTTRAILSOURCE ./dirdat/ep
ADD RMTTRAIL ./dirdat/ep, EXTRACT dpep, MEGABYTES 100

 

5.目标端添加复制进程

add replicat repep, exttrail ./dirdat/ep, NODBCHECKPOINT

 

6.启动
先启动复制端
start mgr
start repep aftercsn 20749394

 

然后启动源端
start mgr
start extep
start dpep