报错信息如下
How to resolve Extract Abending With OGG-02077 Error (Doc ID 2037420.1)
这种情况是把抽取进程注册到数据库中了，你又强制启动相同的抽取进程，就会与数据库中注册的进程冲突，你可以执行下边语句删除数据库中抽取进程
Steps to clear the specific extract component to clear the extract completely
SQL> select capture_name, queue_name, queue_owner from dba_capture ;
SQL> select owner, name, queue_table from dba_queues where name in (select queue_name from dba_capture);
------> If it shows the capture name OGG$CAP_<EXTRACT_NAME>
Then run below
exec DBMS_CAPTURE_ADM.DROP_CAPTURE (' OGG$CAP_EXTRACT_NAME');
BEGIN
DBMS_STREAMS_ADM.REMOVE_QUEUE(
queue_name => 'OGG$Q_<EXTRACT_NAME>',
cascade => false,
drop_unused_queue_table => true);
END;
/
2015-06-17 05:51:08 ERROR OGG-02077 Extract encountered a read error in the asynchronous reader thread and is abending: Error code 1347, error message: ORA-01347: Supplemental log data no longer found.标签：capture,抽取,06,name,17,05,02077,queue,OGG From： https://www.cnblogs.com/dbahrz/p/17671443.html