When we use capture point for mirroring what SCN is captured .In other words from what SCN point will the mirroring start for the particular table, is it the current SCN in when the command is run or is it the SCN of the subscription?
We have a condition where we cannot refresh from source tables(interface agreement) and can only read logs but I want to be mirroring from an SCN point (timestamp) which can be set by using setbookmark command.However I do not see any commands to capture bookmark to start mirroring from an SCN point
I read from documentation that mirroring will only start from capture point and all entries from where scrapper started to capture point will be ignored (refer below).
Source is Oracle 10g and Target is Oracle 10g
"Table capture point: This bookmark is the commit point in the database from
which operations for the table that has its capture point marked are
processed. All changes that are committed after the marked point are
replicated. The table capture point is set when you run the mark table
capture point routine for a table in a subscription. When the subscription is
restarted after marking the table capture point, it resumes from its
(subscription) bookmark position. However, changes to tables that have their
table capture point marked are ignored until the log scraper advances and
reaches the capture point. Each table can have its own table capture point;
they do not have to correspond."