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