Forum Stats

  • 3,769,802 Users
  • 2,253,023 Discussions
  • 7,875,210 Comments

Discussions

Reset CSN

User_CGD4F
User_CGD4F Member Posts: 34 Employee

I have 19.1 GG for Oracle replication. On the target side, can someone please tell me how to reset the CSN? For example: After the initial load, some records' got replicated on the target side, but if these replicated records get deleted on target (or if I truncated the target table and reperform the initial load again), the replicat continues replicating since last CSN until which it has already replicated the records. I want to reset the CSN at the target side in this case. Can someone guide how to do this?

Answers

  • User_CGD4F
    User_CGD4F Member Posts: 34 Employee

    Start using option ATSCN or AFTERCSN returns following message in the report


    2021-02-20 18:36:16 WARNING OGG-05508 The CSN value 1799004 given with the ATCSN or AFTERCSN option is less than the CSN value 1853129

    already committed by the previous instance of this process. Only transactions not yet committed will be processed.


    2021-02-20 18:36:16 WARNING OGG-05508 The CSN value 1799004 given with the ATCSN or AFTERCSN option is less than the CSN value 1853129

    already committed by the previous instance of this process. Only transactions not yet committed will be processed.


    2021-02-20 18:36:19 WARNING OGG-06439 No unique key is defined for table TESTTRG. All viable columns will be used to represent the key,

     but may not guarantee uniqueness. KEYCOLS may be used to define the key.


    2021-02-20 18:36:25 INFO  OGG-06505 MAP resolved (entry salmanpdb.salmansrc.testsrc): map "SALMANPDB"."SALMANSRC"."TESTSRC", target s

  • ORASCN
    ORASCN Member Posts: 1,825 Gold Trophy

    Hi,


    After altering the Replicat process, you will get a message like whether to use NOFILTERDUPTRANSACTION or not. You need to start the replicat process with this option so that it processes all the records.


    Regards,

    Veera