Hi to all,
Streaming Setup : Bi-directional
Schema Based
Recently I found a conflict error on the apply process 56 total errors using "select * from dba_apply_error;".
ERROR :ORA-00001: unique constraint (XXXXXXXXX.XXXXXXX) violated <----------------56 total errors
So deleted manually the errors using EXEC DBMS_APPLY_ADM.DELETE_ALL_ERRORS(apply_name => 'Source_Apply');
The problem is that when I query the using "select * from dba_apply_error;" the errors still there.
Please help
select LOGMINER_ID, CAPTURE_USER, start_scn ncs, to_char(STATUS_CHANGE_TIME,'DD-MM HH24:MI:SS') change_time
,CAPTURE_TYPE,RULE_SET_NAME, negative_rule_set_name , status from dba_capture
order by logminer_id;
-------------------------------------------------------------------------------------------------------------
LOGMINER_ID|CAPTURE_USER|NCS|CHANGE_TIME|CAPTURE_TYPE|RULE_SET_NAME|NEGATIVE_RULE_SET_NAME|STATUS
41 |STRMADMIN|2343610016|05-05 17:39:14|LOCAL|RULESET$_74 | |ENABLED
-------------------------------------------------------------------------------------------------------------
select a.logminer_id , a.CAPTURE_NAME cap, queue_name , AVAILABLE_MESSAGE_NUMBER, CAPTURE_MESSAGE_NUMBER lcs,
AVAILABLE_MESSAGE_NUMBER-CAPTURE_MESSAGE_NUMBER delay_scn,
last_enqueued_scn , applied_scn las , last_enqueued_scn-applied_scn delay2
from dba_capture a, v$streams_capture b where a.capture_name = b.capture_name (+)
order by logminer_id;
-----------------------------------------------------------------------------------------------------------------------------------
LOGMINER_ID|CAP |QUEUE_NAME |AVAILABLE_MESSAGE_NUMBER|LCS |DELAY_SCN|LAST_ENQUEUED_SCN|LAS |DELAY2
41 |Source_Captures|Source_capture|2344404027 |2344001018|403009 |2344001018 |2343610016|391002
-----------------------------------------------------------------------------------------------------------------------------------
SELECT c.logminer_id,
SUBSTR(s.program,INSTR(s.program,'(')+1,4) PROCESS_NAME,
c.sid,
c.serial#,
c.state,
to_char(c.capture_time, 'HH24:MI:SS MM/DD/YY') CAPTURE_TIME,
to_char(c.enqueue_message_create_time,'HH24:MI:SS MM/DD/YY') ENQUEUE_MESG_TIME ,
(SYSDATE-c.capture_message_create_time)*86400 LATENCY_SECONDS,
c.total_messages_captured,
c.total_messages_enqueued
FROM V$STREAMS_CAPTURE c, V$SESSION s
WHERE c.SID = s.SID
AND c.SERIAL# = s.SERIAL#
order by logminer_id;
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
LOGMINER_ID|PROCESS_NAME|SID|SERIAL# |STATE |CAPTURE_TIME |ENQUEUE_MESG_TIME|LATENCY_SECONDS|TOTAL_MESSAGES_CAPTURED|TOTAL_MESSAGES_ENQUEUED
41 |C001 |93 |9970 |PAUSED FOR FLOW CONTROL|17:39:17 05/05/11|00:38:36 05/05/11|135862 |1363 |1
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------
ORA-00001: unique constraint 56 ROWS
-------------------------------------------------------------------------------------------------------------
EXEC DBMS_APPLY_ADM.DELETE_ALL_ERRORS(apply_name => 'Source_Apply');
Errors still there everytime I query dba_apply_error;
experts please help..
Edited by: user13640691 on May 9, 2011 12:16 AM