ogg 的抽取进程 2015-06-17 05:51:08 ERROR OGG-02077 -526互联

报错信息如下

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.