Hello,
We tried to re-position of primary extract but it got failed with
ERROR: Extract ----------- can not be positioned to SCN --------------
Interesting thing is that, the mentioned SCN is after FIRST_SCN (DBA_CAPTURE) and also when checked DBA_REGISTERED_ARCHIVED_LOG, we also found entry of that Archived Log exist..
we have TRANLOGOPTIONS CHECKPOINTRETENTIONTIME, 1 but somehow all these downstream dictionary entries exist even after 3/4 Days.. We also have those Archived Logs available on ASM..
In our case, capture on downstream having FIRST_SCN at 15/10/2017 and we tried to re-positioned it to 21/10/2017
So do anyone face this problem ? or Is it possible to re-position Primary Extract in Down stream deployment ?
FYI:
Its Oracle DB for Source and Downstream: 12c - 12.1.0.2.0
Trail file format is 11.2, as target is SQL Server which has OGG 11.2 ..
We need to re-position primary Extract as pump got failed with below error..some corruption in Trail File..
ERROR OGG-02198 Incompatible record (logical EOF) in trail file ./dirdat/../../aa000039253, rba .......
When check with logdump and POS to RBA, it throws Bad record found at RBA ----------, format 5.50 Header token
Thanks,
Chirag