On source SharePlex, the /vardir/log (where vardir refers to SharePlex’ variable directory) contains logs pertaining to activation. One of those logs is named SID_log.rep where SID refers to the SID of the source Oracle instance. It is an interesting log file and contains cumulative entries of all objects that are brought in replication at various times. The entries are, timestamp, the log sequence #, offset, start and end activation ID, object_id and the name of the object. It can typically be used to analyze when an object was brought into replication, in terms of the time, the log sequence # and the offset of the database when the changes (DDL or DML) pertaining to the object started to replicate. Being a cumulative log, the entries pertaining to an object remain even after an object is taken out of replication. Here is a sample file:
01/03/17 15:50:45 seqno=14234 offset=143888 start_actid=47 end_actid=47 objectid
=200897 "SHA86"."TABLE2"
01/03/17 15:50:45 seqno=14234 offset=155272 start_actid=47 end_actid=47 objectid
=201598 "SHA86"."TABLEX"
01/03/17 15:50:45 seqno=14234 offset=161296 start_actid=47 end_actid=47 objectid
=201599 "SHA86"."TABLEY"
01/03/17 15:50:45 seqno=14234 offset=166928 start_actid=47 end_actid=47 objectid
=201600 "SHA86"."TABLEZ"
01/26/17 13:47:07 seqno=14404 offset=6160 start_actid=50 end_actid=50 objectid=2
20605 "TESTUSER"."TABLE1"
