OGG

OGG

归档日志丢失导致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.