ogg 的抽取进程 2015-06-17 05:51:08 ERROR OGG-02077
报错信息如下
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.
本文来自博客园,作者:蚌壳里夜有多长,转载请注明原文链接:https://www.cnblogs.com/dbahrz/p/17671443.html