1.2.1.3 CSN Based Extract Creation

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 below the registration Options to view available SCNs
   • Select an SCN and create a new Extract

     Figure 1-21 Status

     
     

     
     Description of "Figure 1-21 Status"

     
     
   • Register the SCN in Registration Options and Select Begin as Now from the UI

     Figure 1-22 Register SCN

     
     

     
     Description of "Figure 1-22 Register SCN"

     
     
   • Start the Extract with Last Checkpoint(default) option and verify the Extract by checking the Reports in the Extract View.
   • Wait for the extract to position to the current timestamp as below, then Stop the Extract.

     Figure 1-23 Current Timestamp

     
     

     
     Description of "Figure 1-23 Current Timestamp"

     
     
   • Now click the Edit Extract option in top right corner the UI to reposition the Extract to the chosen SCN.

     Figure 1-24 Edit Extract option

     
     

     
     Description of "Figure 1-24 Edit Extract option"

     
     

     Figure 1-25 Alter Extract

     
     

     
     Description of "Figure 1-25 Alter Extract"

     
     
   • Restart the Extract with CSN option by providing CSN Value and confirm repositioning via Reports and Checkpoint lag.

     Figure 1-26 Select Start Type

     
     

     
     Description of "Figure 1-26 Select Start Type"

     
     

     Figure 1-27 Select Start Type

     
     

     
     Description of "Figure 1-27 Select Start Type"

     
     
   • 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