背景描述
有一套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才能正常抽取。
若有网友发现并解决了此问题的也请留言,感谢!!!