1.2.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, View Parameters, Report Files,Checkpoint,Statistics, Target-Initiated Path 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 the Now option to start immediately or specifying a CSN to begin from a particular commit point in the source database. 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-11 Start Extract with CSN from CSN List


    Description of Figure 1-11 follows
    Description of "Figure 1-11 Start Extract with CSN from CSN List"

    Figure 1-12 Start Extract with Now


    Description of Figure 1-12 follows
    Description of "Figure 1-12 Start Extract with Now"

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

    Figure 1-13 Start Extract


    Description of Figure 1-13 follows
    Description of "Figure 1-13 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-14 Delete Extract


    Description of Figure 1-14 follows
    Description of "Figure 1-14 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-15 Stop Extract


    Description of Figure 1-15 follows
    Description of "Figure 1-15 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-16 Force Stop Extract


    Description of Figure 1-16 follows
    Description of "Figure 1-16 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-17 View Details


    Description of Figure 1-17 follows
    Description of "Figure 1-17 View Details"

  • View/ Edit Parameters: The Extract Parameter View page in Oracle GoldenGate displays all the configuration parameters for a specific extract process. It allows users to review and verify settings. Additionally, the user can click the edit icon in the top-right corner to modify the extract parameter file as needed and click Submit.

    Figure 1-18 View/ Edit Parameter


    Description of Figure 1-18 follows
    Description of "Figure 1-18 View/ Edit Parameter"

  • Report Files: The Report option provides a detailed view of the extract’s operational metrics and configuration. The user can view real-time process details and logs for the extract by clicking on the .rpt or .dsc file on the page. This provides a live view of extract operations, including transaction capture, trail file generation, and any warnings or errors.

    Figure 1-19 Report Files


    Description of Figure 1-19 follows
    Description of "Figure 1-19 Report Files"

  • Check Point: The Checkpoint option on the Extract Detail page in Oracle GoldenGate allows the user to view and manage the extract’s current replication position, Recovery position, Trail Positionand Checkpoint Updates.

    Figure 1-20 Check Point


    Description of Figure 1-20 follows
    Description of "Figure 1-20 Check Point"

  • Statistics: The Statistics option on the Extract Detail page in Oracle GoldenGate provides quantitative metrics about the extract’s performance and activity. It displays the number of table operations, including inserts, updates, and deletes, captured by the extract.

    Figure 1-21 Statistics


    Description of Figure 1-21 follows
    Description of "Figure 1-21 Statistics"

  • Target-Initiated Path: This function allows users to map or view target path information without logging into the target GoldenGate deployment. It includes two main actions:
    • Mapping the Target Path - Associates the target path with the extract for viewing the path information and Stats.

      Figure 1-22 Mapping the Target Path


      Description of Figure 1-22 follows
      Description of "Figure 1-22 Mapping the Target Path"

    • Viewing Path Statistics and Information Post-Mapping – Provides details on replication status, trail files, and performance metrics after the mapping is established.

      Figure 1-23 Viewing Path Statistics and Information Post-Mapping


      Description of Figure 1-23 follows
      Description of "Figure 1-23 Viewing Path Statistics and Information Post-Mapping"

      Note:

      This option requires that the PaaS-side Target Path be created and configured before it can be used. This mapping can also be Reset if there is any change in the Path Configuration in the PaaS.

Parent topic: Integrated Extract