1.2.1.2 Manage Extract

This topic describes the systematic instructions to manage an extract.

Once the extract is successfully created, the user will see the extract details in the UI along with operational buttons, including Start, Stop, Force Stop, Delete, and View Details.

The functions of the operational buttons are explained in detail below:

• Start : Furthermore, the extract can be started based on the user’s choice by selecting either Last Checkpoint(default) to start from Extract creation point or Now option to start immediately or specifying a CSN to begin from a particular commit point in the source database or specifying to start After CSN. Once the extract starts successfully, its status will be updated to Running. While running, the extract continuously writes captured transactions to trail files, which are then delivered to the target through GoldenGate.

  Figure 1-15 Start Extract with options

  
  

  
  Description of "Figure 1-15 Start Extract with options"

  
  

  After selecting the desired action, a Start Confirmation prompt will appear. Click Yes to proceed with starting the extract.

  Figure 1-16 Start Extract

  
  

  
  Description of "Figure 1-16 Start Extract"

  
  
• Delete : This action permanently removes the extract process configuration. It is irreversible and deletes the extract completely. The user cannot delete an extract when its status is Running. The extract must first be stopped before it can be deleted.

  Figure 1-17 Delete Extract

  
  

  
  Description of "Figure 1-17 Delete Extract"

  
  
• Stop : This action gracefully stops the extract process, allowing it to complete any ongoing operations before halting. Once the extract is successfully stopped, its status is updated to Stopped.

  The user can also use this action to pause replication temporarily without deleting the configuration — for example, during maintenance activities.

  Figure 1-18 Stop Extract

  
  

  
  Description of "Figure 1-18 Stop Extract"

  
  
• Force Stop Extract: This action immediately terminates the extract process without waiting for ongoing operations to complete. Once the extract is forcefully stopped, its status is updated to Abended.

  Figure 1-19 Force Stop Extract

  
  

  
  Description of "Figure 1-19 Force Stop Extract"

  
  
• View Details: This action displays detailed information about the extract, including the trail name, lag details, trail sequence and trail size.

  Figure 1-20 View Details

  
  

  
  Description of "Figure 1-20 View Details"