Adding new object from a given SCN

Owned by Jakub Sejba
Last updated: Nov 13, 2017
1 min read

When using AS OF <scn> clause of PREPARE TABLE command to include tables in the on-going replication from pre-specified SCN one has to consider several things beforehand.

  1. make sure that the current SCN of replication (where MINE and APPLY is right now) is not greater than the SCN in PREPARE AS OF <scn> command, e.g.:
    SCN   ---|-------|--------------|---------------------|-----------
            100     150            200                   300 
           APPLY   MINE       PREPARE AS OF           Source DB

  2. make sure that the table has supplemental logging enabled as of SCN used in PREPARE AS OF <scn> command. If supplemental logging is not enabled Replicate will have to use current SCN instead, e.g.:

    dbvrep> prepare as of 2225767872 table TEST1.FORALL_TEST
Prepare enabled supplemental logging, waiting for SCN advance enough to prevent ORA-01466 during consistent export....Waited 2 seconds until scn_to_timestamp changed.
We've just added supplemental logging to the table and thus we must use a current SCN and can't use the required one of 2225767872.
Connecting to running apply [TEST1.FORALL_TEST]: [Apply table removed (0 metadata record(s)). Apply table added (1 metadata record(s)).]
Connecting to running mine [TEST1.FORALL_TEST]: [Table prepared (1 internal records).]
Table TEST1.FORALL_TEST instantiated at SCN 2225768428