oracle goldengate 故障处理一例

最新推荐文章于 2022-02-22 06:00:00 发布

oqqtry1

最新推荐文章于 2022-02-22 06:00:00 发布

阅读量1k

点赞数

分类专栏： goldengate 文章标签： oracle oracle goldengate

本文链接：https://blog.csdn.net/oqqtry1/article/details/78094917

版权

当Oracle GoldenGate进程因找不到归档日志而卡住时，通过清理进程、数据库备份与导入来恢复同步。具体操作包括：1) alter命令开始清理；2) expdp进行数据库全量备份，使用flashback SCN；3) impdp导入到目标库，清理并导入数据；4) 使用start命令，指定aftercsn启动抽取进程。

摘要由CSDN通过智能技术生成

ogg找不到归档日志。

描述：由于长时间没启动ogg进程，源库的归档日志已经被清除，ogg的源库抽取进程卡住abend状态；查看ggserr.log，分析故障原因：

2017-09-26 13:43:59 INFO OGG-01513 Oracle GoldenGate Capture for Oracle, E_LISDB.prm: Positioning to Sequence 1341, RBA 27043856, SCN 0.17271992.
2017-09-26 13:45:20 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, E_LISDB.prm: Could not find archived log for sequence 1341 thread 1 under default destinations SQL <SELECT name FROM v$archived_log WHERE sequence# = :ora_seq_no AND thread# = :ora_thread AND resetlogs_id = :ora_resetlog_id AND archived = 'YES' AND deleted = 'NO' AND standby_dest = 'NO' order by name DESC>, error retrieving redo file name for sequence 1341, archived = 1, use_alternate = 0Not able to establish initial position for sequence 1341, rba 27043856.
2017-09-26 13:45:20 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, E_LISDB.prm: PROCESS ABEN