Oracle GoldenGate

Oracle GoldenGate Repair API

Repair out-of-sync data

GitHub OpenAPI

Operations 5

POST /services/repair/jobs/{runId} Oracle Goldengate Repair Out-of-sync Data #
POST /services/repair/jobs/{runId}/stop Oracle Goldengate Stop a Repair Job #
GET /services/monitoring/repair/jobs Oracle Goldengate Retrieve Repair Statistics #
GET /services/monitoring/repair/cps/{runId} Oracle Goldengate Retrieve Repaired Row Details #
GET /services/monitoring/repair/{runId}/reports Oracle Goldengate Retrieve Repair Report #

Documentation

📖
Documentation
https://docs.oracle.com/en/middleware/goldengate/core/21.3/oggra/index.html
📖
Authentication
https://docs.oracle.com/en/middleware/goldengate/core/21.3/oggra/authentication.html
📖
Documentation
https://docs.oracle.com/en/database/goldengate/core/26/oggra/index.html
📖
Authentication
https://docs.oracle.com/en/database/goldengate/core/26/oggra/authenticate.html
📖
GettingStarted
https://docs.oracle.com/en/database/goldengate/core/26/
📖
Documentation
https://docs.oracle.com/en/middleware/goldengate/big-data/21.3/gadbd/index.html
📖
GettingStarted
https://docs.oracle.com/en/middleware/goldengate/big-data/21.3/gadbd/getting-started.html
📖
Documentation
https://docs.oracle.com/en/middleware/goldengate/veridata/12.2.1.4/gvdug/index.html
📖
APIReference
https://docs.oracle.com/en/middleware/goldengate/veridata/12.2.1.4/gvdra/index.html
📖
Documentation
https://docs.oracle.com/en/database/goldengate/veridata/26/
📖
Documentation
https://docs.oracle.com/en-us/iaas/api/#/en/goldengate/latest/
📖
GettingStarted
https://docs.oracle.com/en/cloud/paas/goldengate-service/index.html
📖
Authentication
https://docs.oracle.com/en-us/iaas/Content/API/Concepts/apisigningkey.htm
📖
APIReference
https://docs.oracle.com/en-us/iaas/goldengate/doc/using-rest-api.html
📖
Documentation
https://docs.oracle.com/en/database/goldengate/stream-analytics/26/
📖
APIReference
https://docs.oracle.com/en/middleware/fusion-middleware/osa/19.1/ggsa-rest-api/quick-start.html
📖
GettingStarted
https://docs.oracle.com/en/database/goldengate/stream-analytics/26/
📖
Documentation
https://docs.oracle.com/en/database/goldengate/core/26/coredoc/distribute-datastream-rest-api.html

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/oracle-goldengate/refs/heads/main/openapi/oracle-goldengate-repair-api-openapi.yml

Other Resources

🔗
Tutorials
https://docs.oracle.com/en/database/goldengate/core/26/tutorials.html
🔗
ChangeLog
https://docs.oracle.com/en/database/goldengate/core/26/release-notes/
🔗
ChangeLog
https://docs.oracle.com/en/database/goldengate/veridata/26/gvdrn/index.html
🔗
SDKs
https://docs.oracle.com/en-us/iaas/Content/API/Concepts/sdks.htm
🔗
CLI
https://docs.oracle.com/en-us/iaas/Content/API/Concepts/cliconcepts.htm
🔗
Tutorials
https://docs.oracle.com/en/cloud/paas/goldengate-service/tutorials.html
🔗
ChangeLog
https://docs.oracle.com/en-us/iaas/releasenotes/services/goldengate/
🔗
SDKs
https://docs.oracle.com/en-us/iaas/tools/python/latest/api/golden_gate.html
🔗
ChangeLog
https://docs.oracle.com/en/database/goldengate/stream-analytics/26/release-notes/release-notes-goldengate-stream-analytics.pdf

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/oracle-goldengate-repair-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

oracle-goldengate-repair-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Oracle GoldenGate Veridata REST Repair API
  description: REST API for Oracle GoldenGate Veridata, a data comparison and repair solution that verifies data consistency between source and target databases. Provides operations for managing connections, compare groups, compare pairs, jobs, profiles, monitoring comparison results, and repairing out-of-sync data. Based on Oracle GoldenGate Veridata 23c REST API documentation.
  version: '1.0'
  contact:
    name: Oracle Support
    url: https://support.oracle.com
  license:
    name: Oracle Technology Network License
    url: https://www.oracle.com/legal/terms.html
  x-documentation:
  - url: https://docs.oracle.com/en/middleware/goldengate/veridata/23/ggvra/rest-endpoints.html
    description: Oracle GoldenGate Veridata REST API Reference
servers:
- url: https://{veridata-host}:{port}/veridata/v1
  description: Oracle GoldenGate Veridata server
  variables:
    veridata-host:
      default: localhost
      description: Veridata server host
    port:
      default: '8830'
      description: Veridata HTTPS port
security:
- basicAuth: []
tags:
- name: Repair
  description: Repair out-of-sync data
paths:
  /services/repair/jobs/{runId}:
    post:
      operationId: repairJob
      summary: Oracle Goldengate Repair Out-of-sync Data
      description: Initiates a repair operation to synchronize out-of-sync rows found during a comparison.
      tags:
      - Repair
      parameters:
      - $ref: '#/components/parameters/runIdParam'
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/RepairJobRequest'
            examples:
              RepairjobRequestExample:
                summary: Default repairJob request
                x-microcks-default: true
                value:
                  repairMode: insert
      responses:
        '200':
          description: Repair initiated
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/RepairExecution'
              examples:
                Repairjob200Example:
                  summary: Default repairJob 200 response
                  x-microcks-default: true
                  value:
                    runId: '500123'
                    status: running
                    startTime: '2026-01-15T10:30:00Z'
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          $ref: '#/components/responses/NotFound'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /services/repair/jobs/{runId}/stop:
    post:
      operationId: stopRepairJob
      summary: Oracle Goldengate Stop a Repair Job
      description: Stops a currently running repair operation.
      tags:
      - Repair
      parameters:
      - $ref: '#/components/parameters/runIdParam'
      responses:
        '200':
          description: Repair stopped
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          $ref: '#/components/responses/NotFound'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /services/monitoring/repair/jobs:
    get:
      operationId: getRepairStatistics
      summary: Oracle Goldengate Retrieve Repair Statistics
      description: Returns statistics for repair operations.
      tags:
      - Repair
      responses:
        '200':
          description: Repair statistics retrieved
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/RepairStatisticsList'
              examples:
                Getrepairstatistics200Example:
                  summary: Default getRepairStatistics 200 response
                  x-microcks-default: true
                  value:
                    statistics:
                    - runId: '500123'
                      status: example_value
                      rowsRepaired: 10
                      rowsFailed: 10
        '401':
          $ref: '#/components/responses/Unauthorized'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /services/monitoring/repair/cps/{runId}:
    get:
      operationId: getRepairedRowDetails
      summary: Oracle Goldengate Retrieve Repaired Row Details
      description: Returns detailed information about rows that were repaired during a repair operation.
      tags:
      - Repair
      parameters:
      - $ref: '#/components/parameters/runIdParam'
      responses:
        '200':
          description: Repair details retrieved
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/RepairedRowDetails'
              examples:
                Getrepairedrowdetails200Example:
                  summary: Default getRepairedRowDetails 200 response
                  x-microcks-default: true
                  value:
                    runId: '500123'
                    rows:
                    - table: example_value
                      repairType: example_value
                      status: example_value
                      keyValues: example_value
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          $ref: '#/components/responses/NotFound'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
  /services/monitoring/repair/{runId}/reports:
    get:
      operationId: getRepairReport
      summary: Oracle Goldengate Retrieve Repair Report
      description: Returns a detailed repair report for a specific repair run.
      tags:
      - Repair
      parameters:
      - $ref: '#/components/parameters/runIdParam'
      responses:
        '200':
          description: Repair report retrieved
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/RepairReport'
              examples:
                Getrepairreport200Example:
                  summary: Default getRepairReport 200 response
                  x-microcks-default: true
                  value:
                    runId: '500123'
                    startTime: '2026-01-15T10:30:00Z'
                    endTime: '2026-01-15T10:30:00Z'
                    totalRows: 10
                    repairedRows: 10
                    failedRows: 10
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          $ref: '#/components/responses/NotFound'
      x-microcks-operation:
        delay: 0
        dispatcher: FALLBACK
components:
  schemas:
    RepairStatisticsList:
      type: object
      properties:
        statistics:
          type: array
          items:
            type: object
            properties:
              runId:
                type: integer
                format: int64
              status:
                type: string
              rowsRepaired:
                type: integer
                format: int64
              rowsFailed:
                type: integer
                format: int64
          example: []
    RepairJobRequest:
      type: object
      properties:
        repairMode:
          type: string
          enum:
          - insert
          - update
          - delete
          - all
          example: insert
    RepairedRowDetails:
      type: object
      properties:
        runId:
          type: integer
          format: int64
          example: '500123'
        rows:
          type: array
          items:
            type: object
            properties:
              table:
                type: string
              repairType:
                type: string
              status:
                type: string
              keyValues:
                type: object
                additionalProperties: true
          example: []
    ErrorResponse:
      type: object
      properties:
        code:
          type: integer
          example: 10
        message:
          type: string
          example: example_value
    RepairReport:
      type: object
      properties:
        runId:
          type: integer
          format: int64
          example: '500123'
        startTime:
          type: string
          format: date-time
          example: '2026-01-15T10:30:00Z'
        endTime:
          type: string
          format: date-time
          example: '2026-01-15T10:30:00Z'
        totalRows:
          type: integer
          format: int64
          example: 10
        repairedRows:
          type: integer
          format: int64
          example: 10
        failedRows:
          type: integer
          format: int64
          example: 10
    RepairExecution:
      type: object
      properties:
        runId:
          type: integer
          format: int64
          example: '500123'
        status:
          type: string
          enum:
          - running
          - completed
          - stopped
          - failed
          example: running
        startTime:
          type: string
          format: date-time
          example: '2026-01-15T10:30:00Z'
  responses:
    NotFound:
      description: Resource not found
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
    Unauthorized:
      description: Authentication required
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/ErrorResponse'
  parameters:
    runIdParam:
      name: runId
      in: path
      required: true
      description: Job or repair run identifier
      schema:
        type: integer
        format: int64
  securitySchemes:
    basicAuth:
      type: http
      scheme: basic
      description: HTTP Basic authentication with Veridata credentials