1.show capture detail always waiting,
sp_ctrl (tplbiza:2300)> show capture detail
Host: tplbiza
Operations
Source Status Captured Since
---------- --------------- ---------- ------------------
o.TPL2A Running 0 16-Apr-12 17:59:56
Log reader threads:
Thread Instance Host Oracle Log Redo Log Log Offset Kbytes Read
------ ------------ ------------ ---------- -------- ------------ ------------
1 TPL2A tplbiza 69639 69629 119025680 139926847
2 TPL2B tplbizb 68229 68229 1678888 169552381
Last redo record processed:
None
Capture state : Waiting
Activation id : 0
Error count : 0
Operations captured : 0
Transactions captured : 0
Concurrent sessions : 0
HWM concurrent sessions : 0
Checkpoints performed : 0
Total operations processed : 0
Total transactions completed : 0
Total Kbytes read : 0
Redo records in progress : 0
Redo records processed : 0
Redo records ignored : 0
Redo records - last HRID : AAAH1qAEjAABM7ZAAU
2.Event_log report log_wrap
Notice 2012-04-16 18:03:59.144750 25428208 1 Capture: The database supplemental logging state = Enabled, primary_key = Disabled, unique_key = Disabled (capturing from TPL2A) [module oct]
Warning 2012-04-16 18:04:03.210951 25428208 1029 Capture: A portion of the redo log could not be parsed (capturing from TPL2A) [module oct]
Notice 2012-04-16 18:04:03.212514 25428208 1029 Capture: Begin record skip at seqno=68209 offset=173754896 rc=6 (capturing from TPL2A) [module oct]
Error 2012-04-16 18:04:03.213994 25428208 1029 Capture: LOG_WRAP detected 68209 173754896 0, start retry (../src/olog/olog.c:2579) (capturing from TPL2A) [module oct]
3.shareplex_actid
INSTANCE_NAME SEQNO OFFSET LOG_START_OFFSET
-------------------------------- ---------- ---------- --
Customer changed DB from single DB to RAC, it corrupted <vardir>/state/o.SID-threadmap file.
Incorrect:
0 1 TPL2A tplbiza
0 2 TPL2B tplbizb
Correct:
0 1 TPL2A tplbiza
1 2 TPL2B tplbizb
1.stop capture
2.correct o.SID-threadmap file,
3.correct shareplex_actid
select instance_name,seqno,offset,log_start_offset from shareplex_actid;
begin
update shareplex_actid
set seqno =<#>,
offset = 0,
log_start_offset=0
Where instance_name='<instance_name>';
commit;
end;
