OGG Re-initiate with SCN

How to import with flashback_SCN :
==========================


> select scn_to_timestamp(8697520) from dual;

> select timestamp_to_scn('10-JUN-14 10.50.55.000000000 AM') from dual;

My workaround is ,

 I take the backup dump from source machine with flashback_scn (10616719792607). My source machine is running on .
After one day ,  I import it to the target pc and replicate database from source to target end .


Solution :

  On source ,

        - delete all trail files and all extract : delete extract *

        - Add the extract again

        - take the timestamp of the scn :

                   select scn_to_timestamp(10616719792607) from dual;

             output :   2016-01-25 17:12:41.000000   << should be 24 Format . (YYYY-MM-DD HH:MM:SS )

     

   On Target ,

               - delete replicate (REP3) as well as checkpoint

                - DBLOGIN USERID ggs_owner, PASSWORD ggs_owner
                   delete CHECKPOINTTABLE GGS_OWNER.CHKPTAB

                   ADD CHECKPOINTTABLE GGS_OWNER.CHKPTAB
                   ADD REPLICAT rep3, EXTTRAIL /u01/oracle/ggs/dirdat2/rt


now Start the service :

        On Source :
                       ALTER EXTRACT ext1, TRANLOG, BEGIN 2016-01-25 17:12:41.000000
                        START ext1 ;

                        START DPUMP ; // No need to mention date/time .



        On Target :

                       start replicat REP3, aftercsn 10616719792607




Check Status :
==============

           
Skipping a transaction, or starting at or after a CSN, might cause Replicat to start more slowly
than normal, depending on how much data in the trail must be read before arriving at the
appropriate transaction record. To view the startup progress, use the SEND REPLICAT
command with the STATUS option. To omit the need for Replicat to read through transactions
that ultimately will be skipped, you can use the ATCSN or AFTERCSN option when starting Extract
and the data pumps, so that those transactions are omitted from the trail. See "START EXTRACT".


GGSCI (testpbl.pbl.com) 1> send rep3 status

Sending STATUS request to REPLICAT REP3 ...
  Current status: At EOF
                  Searching for START AFTERCSN 10616719792607
                                   Current CSN Unknown                        <<<<
  Sequence #: 0
  RBA: 0
  0 records in current transaction




After reinitiate:
=================

GGSCI (testpbl.pbl.com) 1> send rep3 status

Sending STATUS request to REPLICAT REP3 ...
  Current status: At EOF
  Sequence #: 0
  RBA: 5347
  0 records in current transaction