当OGG抽取进程中遇到归档日志丢失，且丢失的数据不需要传输到目的端时，可以通过取消注册、删除和重新注册EXTRACT进程来修复。首先，使用GGSCI注销并删除EXT1数据库，然后尝试重新注册，但遇到了错误提示需要先删除EXTRACTEXT1。执行开始命令后，再次尝试注册EXT1，最终成功注册并继续抽取进程。
归档日志丢失导致ogg 抽取进程报错
OGG-02028 Failed to attach to logmining server OGG$EXT1 error 1,292 - ORA-01292: LogMiner for upstream capture cannot find log file
如果丢失归档对应的数据不需要传到目的端了，这种情况下如何修复抽取进程呢？
GGSCI (localhost.localdomain) 45> dblogin userid ggadmin@orcl,password ggadmin
Successfully logged into database.
GGSCI (localhost.localdomain as ggadmin@orcl) 48> unregister extract EXT1 database ;
2022-05-04 03:36:14 INFO OGG-01750 Successfully unregistered EXTRACT EXT1 from database.
GGSCI (localhost.localdomain as ggadmin@orcl) 49> register extract EXT1 database ;
2022-05-04 03:36:29 ERROR OGG-01891 EXTRACT EXT1 must first be deleted before it can be registered.
GGSCI (localhost.localdomain as ggadmin@orcl) 51> alter extract EXT1,begin now
EXTRACT altered.
GGSCI (localhost.localdomain as ggadmin@orcl) 52> register extract EXT1 database
2022-05-04 03:41:16 INFO OGG-02003 Extract EXT1 successfully registered with database at SCN 2474317.
1668
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
