OGG-01635 OGG-15149 centos服务器远程抽取AIX oracle11.2.0.4版本

发布于:2025-06-06 ⋅ 阅读:(24) ⋅ 点赞:(0)

背景描述

有一套ogg远程抽取的环境,源端是AIX7.1环境的oracle 11.2.0.4版本的数据库,中间是OGG抽取服务器,目标端是centos 7.9环境的oracle 19c。

采用集成模式远程抽取源端数据正常,但是经典模式远程抽取源数据的时候抽取进程启动成功,但是一直在初始化,没有正常抽取数据。

在这里插入图片描述

问题描述

抽取进程一直处在初始化状态

GGSCI (oggser) 9> info etaodb 

EXTRACT    ETAODB    **Initialized**   2025-06-05 10:27   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:06:03 ago)
Process ID           24241
Log Read Checkpoint  Oracle Redo Logs
                     2025-06-05 10:27:25  Seqno 0, RBA 0
                     SCN 0.0 (0)


GGSCI (oggser) 10> send etaodb
ERROR: No Command for SEND.

GGSCI (oggser) 11> send etaodb status

Sending STATUS request to EXTRACT ETAODB ...

2025-06-05 10:38:04  ERROR   OGG-15149  EXTRACT ETAODB is **initializing**, please try the command later.

启动日志提示BR也是在初始化

2025-06-05T10:33:10.010+0800  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start etaodb.
2025-06-05T10:33:10.011+0800  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host [10.128.255.146]:57608 (START EXTRACT ETAODB ).
2025-06-05T10:33:10.011+0800  INFO    OGG-00960  Oracle GoldenGate Manager for Oracle, mgr.prm:  Access granted (rule #1).
2025-06-05T10:33:10.014+0800  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT ETAODB starting.
2025-06-05T10:33:10.192+0800  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, etaodb.prm:  EXTRACT ETAODB starting.
2025-06-05T10:33:10.192+0800  INFO    OGG-03059  Oracle GoldenGate Capture for Oracle, etaodb.prm:  Operating system character set identified as UTF-8.
2025-06-05T10:33:10.192+0800  INFO    OGG-02695  Oracle GoldenGate Capture for Oracle, etaodb.prm:  ANSI SQL parameter syntax is used for parameter parsing.
2025-06-05T10:33:10.192+0800  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, etaodb.prm:  Successfully set environment variable TNS_ADMIN=/OSdata/oraclient/instantclient_12_1/instantclient_12_1/network/admin.
2025-06-05T10:33:11.016+0800  WARNING OGG-04033  Oracle GoldenGate Capture for Oracle, etaodb.prm:   LOGALLSUPCOLS has set the NOCOMPRESSDELETES and GETUPDATEBEFORES parameters on.
2025-06-05T10:33:11.151+0800  INFO    OGG-01635  Oracle GoldenGate Capture for Oracle, etaodb.prm:  BOUNDED RECOVERY: reset to initial or altered checkpoint.   <<<<<<<<<<<<<<<<<<<<
2025-06-05T10:33:11.151+0800  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, etaodb.prm:  Virtual Memory Facilities for: BR
                                  anon alloc: mmap(MAP_ANON)  anon free: munmap
                                  file alloc: mmap(MAP_SHARED)  file free: munmap
                                  target directories:
                                  /OSdata/ogg181_oracle/BR/ETAODB.
2025-06-05T10:33:11.151+0800  INFO    OGG-01851  Oracle GoldenGate Capture for Oracle, etaodb.prm:  filecaching started: thread ID: 140206369875712.
2025-06-05T10:33:11.161+0800  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, etaodb.prm:  Virtual Memory Facilities for: COM
                                  anon alloc: mmap(MAP_ANON)  anon free: munmap
                                  file alloc: mmap(MAP_SHARED)  file free: munmap
                                  target directories:
                                  ./dirtmp.

注释:BR相关的介绍请参考:
https://gavinsoorma.com.au/knowledge-base/goldengate-bounded-recovery/

尝试根据MOS的处理方法问题仍旧出现。
OGG Extract Hung With OGG-15149 EXTRACT xxxx is Initializing & Get Logfile Header Info Failed With Error 22 (Invalid Argument) Reading Redo Log (Doc ID 2413821.1)

可能的原因是centos版本的OGG不能使用经典模式抽取AIX环境下的数据库,仅能使用集成模式方式抽取。但是在集成模式下出现过一次故障,源端生产环境宕机了,重新启动的时候发现数据库不能使用数据泵导出导入数据了,后来也是经过白板折腾才发现是由于集成模式在数据库里面注册的进程异常导致的,把注册的进程重新取消注册之后就恢复正常了。

为了避免以后出现同样的问题才考虑使用经典模式抽取数据。

目前经典模式抽取失败,未找到解决方法。初步怀疑可能得使用AIX模式版本的OGG才能正常抽取。

若有网友发现并解决了此问题的也请留言,感谢!!!