本文主要是介绍OGG 两个故障案例处理，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
案例一：ogg 删除 REPLICAT进程遇OCI Error ORA-00942: table or view does not exist (status = 942)错误解决办法
一、问题描述
在测试OGG双向同步时，在目标端配置了应用进程，在启动应用进程时发现有报错，打算删除该应用进程，在执行delete REPLICAT rtb删除时报如下错误，导致无法删除。
ERROR: Could not delete DB checkpoint for REPLICAT RTB (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table ogg.chkpoint, group ‘RTB’, key 3883182186 (0xe774a86a), SQL ).
使用force也同样报错：
GGSCI (xsky-node4) 34> delete rtb force
ERROR: Could not delete DB checkpoint for REPLICAT RTB (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table ogg.chkpoint, group ‘RTB’, key 3883182186 (0xe774a86a), SQL ).
二、解决办法
通过查阅资料，添加 ！符合可以删除
GGSCI (xsky-node4) 38> delete replicat rtb !
WARNING: Could not delete DB checkpoint for REPLICAT RTB (OCI Error ORA-00942: table or view does not exist (status = 942). Deleting from checkpoint table ogg.chkpoint, group ‘RTB’, key 3883182186 (0xe774a86a), SQL ).
GGSCI (xsky-node4) 39> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DPA 00:00:00 00:00:04
EXTRACT RUNNING EXA 00:00:00 00:00:05
此时再没rtb那个replicat进程了。
真的没想到通过 添加 ！感叹号可以删除，又学到一招,特此记录下。
案例二：OGG配置PUMP因绝对路径和相对路径导致进程PROCESS ABENDING问题记录
一、背景描述
这是最近遇到的一个案例，目前一套Oracle 11g RAC要下线，并将部分业务拆分迁移到其它生产库上，业务不允许停机迁移，于是就配置了OGG双向同步，在验证数据迁移配置OGG双向同步时，在源端配置PUMP，执行了如下命令 ADD RMTTRAIL ./dirdat/eb, EXTRACT dpb，并编辑了PUMP进程，在启动pump进程时报了如下错误，导致进程ABENDING
2023-06-08 09:51:19 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start dpb.
2023-06-08 09:51:19 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [192.168.4.21]:28513 (START EXTRACT DPB ).
2023-06-08 09:51:19 INFO OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #6).
2023-06-08 09:51:19 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT DPB starting.
2023-06-08 09:51:19 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, dpb.prm: EXTRACT DPB starting.
2023-06-08 09:51:19 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, dpb.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2023-06-08 09:51:19 INFO OGG-02696 Oracle GoldenGate Capture for Oracle, dpb.prm: NON-ANSI SQL parameter syntax is used for parameter parsing.
2023-06-08 09:51:19 INFO OGG-02095 Oracle GoldenGate Capture for Oracle, dpb.prm: Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.ZHS16GBK.
2023-06-08 09:51:19 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, dpb.prm: Virtual Memory Facilities for: COManon alloc: mmap(MAP_ANON) anon free: munmapfile alloc: mmap(MAP_SHARED) file free: munmaptarget directories:/ogg/dirtmp.
2023-06-08 09:51:19 ERROR OGG-01044 Oracle GoldenGate Capture for Oracle, dpb.prm: The trail '/ogg/dirdat/rb' is not assigned to extract 'DPB'. Assign the trail to the extract with the command "ADD EXTTRAIL/RMTTRAIL /ogg/dirdat/rb, EXTRACT DPB".
2023-06-08 09:51:19 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, dpb.prm: PROCESS ABENDING.
二、原因分析
查看了PUMP的配置文件，应该是跟配置文件中RMTTRAIL后使用了绝对路径，如下所示：
GGSCI (host501) 10> view param dpbEXTRACT dpb
SETENV(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
PASSTHRU
USERID ogg, PASSWORD AACAAAAAAAAAAADAHBLDCCIIOIRFNEPB, ENCRYPTKEY default
RMTHOST 192.168.xxx.xxx, MGRPORT 8701
RMTTRAIL /ogg/dirdat/eb
REPORTCOUNT EVERY 10 MINUTES, RATE
NUMFILES 5000
DYNAMICRESOLUTION
--AND TABLE AND SEQUENCE
而我为data pump指定远程trail文件地址，是采用了相对路径，./dirdat/eb
三、解决办法
通过delete dpb删除该pump进程，然后执行ADD RMTTRAIL /ogg/dirdat/rb, EXTRACT dpb，PUMP进程的配置文件未修改，重新启动该pump进程，这次正常启动，不再ABENDING.
之前部署OGG也遇到了很多问题，但这是第一次遇因路径产生故障的问题，特整理记录下来。
这篇关于OGG 两个故障案例处理的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
