5 Replies Latest reply on Feb 23, 2012 3:24 PM by Boochi

    streams capture required checkpoint SCN not moving forward

      Oracle DB version:

      I setup the uni-directional streams replication of a schema. The streams is running fine and the start SCN and required checkpoint SCN were moving forward. I set capture retention to 3 days. But, the required checkpoint SCN, start SCN and fist SCN are not moving forward from past four days. The streams capture and apply running perfectly and it's applying all the latest records.

      But, if the streams is restarted for any case, the capture may look for the old archivelogs since the required checkpoint SCN is not moving forward. What is possible reason for it and how to resolve it?. Could someone explain please?.