Start existing Integrated Extract from previous SCN or timestamp

I came across scenario where i had to restart the integrated extract from previous SCN / Timestamp and it was not starting from given scn or timestamp.

How Integrated extract works: SCN requires a valid dictionary build in the existing archive logs.  Integrated Extract operates with a logminer dictionary.

Run below query to check the min scn present in dictionary:

COLUMN FIRST_CHANGE# HEADING 'First SCN' FORMAT 999999999

COLUMN NAME HEADING 'Log File Name' FORMAT A50



SELECT DISTINCT FIRST_CHANGE#, NAME FROM V$ARCHIVED_LOG

 WHERE DICTIONARY_BEGIN = 'YES'; 

select sequence#,first_change#,next_change# from v$archived_log where &scn between first_change# and next_change#;

Ref: How to start an Integrated Extract At an Older SCN (Doc ID 2046981.1)

Ref: Integrated Extract Not Extracting From Selected Timestamp (Doc ID 1579032.1)

Below query can be run at Target to check upto which scn data has already applied at target. That scn should be considered to reset extract at source side. LOG_CMPLT_CSN shows log complete SCN upto which data has been replicated by replicat at target.

select GROUP_NAME,LOG_CSN,LOG_BSN,LOG_CMPLT_CSN from GGADMIN.checkpointtable where group_name in ('RORCL1','RORCL2');



GROUP_NA LOG_CSN                        LOG_BSN                                       LOG_CMPLT_CSN

-------- ------------------------------ --------------------------------------------- ------------------------------

ROCRL1  54793963772                    54793845236                                   54793963772

RORCL2 54793642029                    54793845236                                   54793642029