This topic describes the systematic instructions to create CSN Based Extract Creation.

When creating an extract in Oracle GoldenGate, the CSN (Commit Sequence Number) option allows the user to start capturing transactions from a specific point in the source database. This Ensures the replication begins from a well-defined commit point, which is useful for resuming replication after maintenance, downtime, or for selectively capturing a subset of transactions.

To use the CSN option for an existing SaaS database, follow the steps below:

1. In PaaS OCI Goldengate Console:
   • Customer stops the existing Target-Initiated Distribution Path and records Source Sequence Number and RBA Offset.
2. In OBCS SaaS Self-Service UI:
   • Delete the existing Extract
   • Use the SCN List button to view valid SCNs
   • Select an SCN and create a new Extract

     Figure 1-24 Status

     
     

     
     Description of "Figure 1-24 Status"

     
     

     Figure 1-25 Edit Extract

     
     

     
     Description of "Figure 1-25 Edit Extract"

     
     
   • Register the SCN in Registration Options and Select Begin as Now
   • Start and verify the Extract by checking the Reports in the Extract View.
   • Wait for the extract to position to the current timestamp, then Stop the Extract.
   • Use the Edit Extract option in top right corner the UI to reposition the Extract to the chosen SCN.
   • Restart the Extract with CSN option by providing CSN Value and confirm repositioning via Reports and Checkpoint lag.
   • As the lag decreases, the Statistics keeps updating with the historical data capture metrics
3. In PaaS OCI Goldengate Console:
   • Create a new Target-Initiated Distribution Path using the Source Sequence Number and RBA Offset captured earlier.
   • Start and validate historical data capture in Statistics
   • Delete the previous stopped distribution path