OGG-02171 错误通常表示从数据源读取 LCR(逻辑更改记录)时出现问题。 这个错误可能由多种原因引起,以下是一些常见的解决步骤和检查点: 检查数据源状态: 确保数据源(如 Oracle 数据库)正在运行且可访问。 检查数据库连接信息(如用户名、密码、TNS 名称等)是否正确。 检查Trail 文件: 确认Trail 文件(OGG 用于存储 LC
SourceMethod : [processExtractLoop] SourceLine : [468] 2024-07-17 08:43:57 ERROR OGG-02171 Error reading LCR from data source. Status 510, data source type TranLogDataSource. 2、异常定位 根据Mos[Doc ID 2899818.1]文档可知ogg用户的权限不足导致. 3、解决方案 --授予ogg用户权限 sys@ORCLCDB>...
SQL>commit; 3)OGG 复制进程Abend2020-11-1011:36:59ERROR OGG-02171Error reading LCRfromdata source. Status509, data source type TrailDataSource.2020-11-1011:36:59ERROR OGG-02191Incompatible record101in/u01/ogg/base/dirdat/t1000000052, rba2,378when getting trail header.2020-11-1011:36:59ERRO...
2)The number of standby log file groups >= The number of source online log file groups+1.So if you have "n" threads at the source database, each having "m" redo log groups, you should configure n*(m+1) redo log groups at the downstream mining database. ALTER DATABASE ADD STANDBY...
2019-04-14 11:01:04 ERROR OGG-02171 Oracle GoldenGate Capture for Oracle, d_card.prm: Error reading LCR from data source. Status 500, data source type 0. 2019-04-14 11:01:04 ERROR OGG-01091 Oracle GoldenGate Capture for Oracle, d_card.prm: Unable to open file ""./dirdat/lt0000...
2019-04-14 11:01:04 ERROR OGG-02171 Oracle GoldenGate Capture for Oracle, d_card.prm: Error reading LCR from data source. Status 500, data source type 0.2019-04-14 11:01:04 ERROR OGG-01091 Oracle GoldenGate Capture for Oracle, d_card.prm: Unable to open file ""./dirdat/lt0...
: [/data/ogg/replicat()] 2024-12-06 17:50:55 ERROR OGG-02171 Error reading LCR from data source. Status 524, data source type TrailDataSource. Source Context : SourceModule : [er.replicat.ReplicatContext] SourceID : [er/replicat/ReplicatContext.cpp] ...
2019-04-14 11:01:04 ERROR OGG-02171 Oracle GoldenGate Capture for Oracle, d_card.prm: Error reading LCR from data source. Status 500, data source type 0. 2019-04-14 11:01:04 ERROR OGG-01091 Oracle GoldenGate Capture for Oracle, d_card.prm: Unable to open file ""./dirdat/lt0000...
之前有个客户遇到一个问题,OGG同步数据链路,突然有一天网络出现问题,导致OGG投递进程无法正常投递,无法写入目标端的该文件。 猜测是由于网络丢包等原因导致文件损坏,无法正常open,read,write. 解决方法,投递进程etrollover。 本篇文档是基于这种方式测试下etrollover 【测试没有完美还原网络的问题,只是对其进行了测试】 ...