1. Oracle GoldenGate 23ai Microservices Architecture REST API Documentation
  2. Tasks
  3. Administration Service
  4. Commands

Execute Command

post

/services/{version}/commands/execute

Required Role: User

Execute a command. Reporting commands are accessible for users with the 'User' role. Other commands require the 'Operator' role.

Request

Supported Media Types
Path Parameters
Body ()
Root Schema : Oracle GoldenGate Task Manager Command
Title: Oracle GoldenGate Task Manager Command
Match One
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[0]
Type: object
Start an Extract or Replicat
Show Source
  • Allowed Values: [ "ogg:command" ]
  • after
    Directs Extract/Replicat to position its start point at the beginning of the first transaction after the one that has the specified CSN. Any transactions in the data source that have CSN values that are less than, or equal to, the specified one are skipped.
  • at
    Directs Extract/Replicat to position its start point at the transaction that has the specified CSN. Any transactions in the data source that have CSN values less than the specified one are skipped.
  • Default Value: true
    Causes Replicat to ignore transactions that it has already processed. Use when Extract was repositioned to a new start point (using the ATCSN or AFTERCSN) and you are confident that there are duplicate transactions in the trail that could cause Replicat to abend. This option requires the use of a checkpoint table. If the database is Oracle, this option is valid only for Replicat in nonintegrated mode. Integrated mode handles duplicate transactions transparently. The default is true.
  • Allowed Values: [ "start" ]
  • Minimum Length: 1
    Maximum Length: 8
    Pattern: ^[*A-Z_$][*A-Z0-9_$]*$
  • Default Value: ER
    Allowed Values: [ "extract", "replicat", "ER" ]
  • Default Value: false
    Reset Bounded Recovery and use normal recovery instead
  • Default Value: false
    Causes Replicat to skip the first transaction after its expected startup position in the trail. All operations from that first transaction are excluded.
  • threads
    Minimum Number of Items: 1
    Maximum Number of Items: 500
    Valid when used with 'skipTransaction', 'at', or 'after' with Replicat in coordinated mode. Starts the specified Replicat thread or threads at the specified location.
Match All
Start an Extract or Replicat
Start an Extract or Replicat
Start an Extract or Replicat
Start an Extract or Replicat
Start an Extract or Replicat
Start an Extract or Replicat
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[1]
Type: object
Stop an Extract or Replicat
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[2]
Type: object
Kill an Extract or Replicat
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[3]
Type: object
Execute an Extract or Replicat
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[4]
Type: object
Collect diagnostic data for an integrated Extract or Replicat for the Oracle database
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[5]
Type: object
Synchronize a Replicat
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[6]
Type: object
Report on Processes
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[7]
Type: object
Report on Process Lag
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[8]
Type: object
Report Operating System and database version information
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[9]
Type: object
Lists the schemas in the database with names that match the input specification
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[10]
Type: object
Lists the tables in the database with names that match the input specification
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[11]
Type: object
Lists the checkpoint tables in the database with names that match the input specification
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[12]
Type: object
Lists the containers in the database with names that match the input specification
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[13]
Type: object
Purge checkpoint history for ER processes
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[14]
Type: object
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[15]
Type: object
Purge trail files no longer needed
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[16]
Type: object
Update Heartbeat Table (PostgreSQL only)
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[17]
Type: object
Archive/restore trail sequences
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[18]
Type: object
Purge Extract or Replicat tasks
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[19]
Type: object
Purge files no longer needed
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[20]
Type: object
Purge change data - currently only implemented for SQL Server
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[21]
Type: object
Updates a database sequence so that initial redo records are available at the time that Extract starts capturing transaction data after the instantiation of the replication environment.
Show Source
Nested Schema : after
Directs Extract/Replicat to position its start point at the beginning of the first transaction after the one that has the specified CSN. Any transactions in the data source that have CSN values that are less than, or equal to, the specified one are skipped.
Match Any
Show Source
  • after-x-anyOf[0]
  • after-x-anyOf[1]
  • Minimum Length: 3
    Maximum Length: 41
    Pattern: ^([0-9]{1,20}[.][0-9]{1,20})$
    Log Record Identifer(LRI) pattern for DB2LUW Database.
    Example: 65423.12345
  • Minimum Length: 1
    Maximum Length: 25
    Pattern: ^([0][Xx][a-fA-F0-9]{1,20})|([0-9]{1,25})$
    Log Sequence Number (LSN) pattern for DB2ZOS Database.
    Example: 0xa123bcde
  • after-x-anyOf[4]
  • Minimum Length: 15
    Maximum Length: 56
    Pattern: ^([0][Xx]([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4})-([0-9a-fA-F]{1,8})-([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4}))$
    Commit Sequence Number pattern for MSSQL Database.
    Example: 0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445
  • Minimum Length: 3
    Maximum Length: 17
    Pattern: ^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$
    Commit Sequence Number pattern for PostgreSQL Database.
    Example: 9acd12/231bcf
  • Minimum Length: 7
    Maximum Length: 33
    Pattern: ^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$
    Commit Sequence Number pattern for Sybase Database.
    Example: 00000.0026487383.0000533650.00034
  • Commit Sequence Number for Teradata (Not Supported)
  • Minimum Length: 1
    Maximum Length: 100
    Pattern: ^([A-Za-z0-9_]{1,100})$
    Commit Sequence Number pattern for Generic Database.
    Example: 9acd12231bcf
Nested Schema : at
Directs Extract/Replicat to position its start point at the transaction that has the specified CSN. Any transactions in the data source that have CSN values less than the specified one are skipped.
Match Any
Show Source
  • at-x-anyOf[0]
  • at-x-anyOf[1]
  • Minimum Length: 3
    Maximum Length: 41
    Pattern: ^([0-9]{1,20}[.][0-9]{1,20})$
    Log Record Identifer(LRI) pattern for DB2LUW Database.
    Example: 65423.12345
  • Minimum Length: 1
    Maximum Length: 25
    Pattern: ^([0][Xx][a-fA-F0-9]{1,20})|([0-9]{1,25})$
    Log Sequence Number (LSN) pattern for DB2ZOS Database.
    Example: 0xa123bcde
  • at-x-anyOf[4]
  • Minimum Length: 15
    Maximum Length: 56
    Pattern: ^([0][Xx]([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4})-([0-9a-fA-F]{1,8})-([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,8}):([0-9a-fA-F]{1,4}))$
    Commit Sequence Number pattern for MSSQL Database.
    Example: 0X00000d7e:0000036b:01bd, 0000003454:0000000875:00445, 0Xd7e:36b:1bd, 3454:875:445,3454000000087500445
  • Minimum Length: 3
    Maximum Length: 17
    Pattern: ^(([0-9a-fA-F]{1,8})/([0-9a-fA-F]{1,8}))$
    Commit Sequence Number pattern for PostgreSQL Database.
    Example: 9acd12/231bcf
  • Minimum Length: 7
    Maximum Length: 33
    Pattern: ^([0-9]{1-5}[.][0-9]{1-10}[.][0-9]{1-10}[.][0-9]{1-5})$
    Commit Sequence Number pattern for Sybase Database.
    Example: 00000.0026487383.0000533650.00034
  • Commit Sequence Number for Teradata (Not Supported)
  • Minimum Length: 1
    Maximum Length: 100
    Pattern: ^([A-Za-z0-9_]{1,100})$
    Commit Sequence Number pattern for Generic Database.
    Example: 9acd12231bcf
Nested Schema : threads
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 500
Valid when used with 'skipTransaction', 'at', or 'after' with Replicat in coordinated mode. Starts the specified Replicat thread or threads at the specified location.
Show Source
Nested Schema : Oracle GoldenGate Task Manager Command-x-oneOf[0]-allOf[5]
Match Any
Show Source
Nested Schema : after-x-anyOf[0]
Match One
Show Source
  • Minimum Value: 0
    Maximum Value: 9223372036854776000
    System Change Number(Normal Format) for Oracle Database.
    Example: 6488359
  • Minimum Length: 3
    Maximum Length: 64
    Pattern: [0-9]+[.][0-9]+
    System Change Number(Alternate Format) for Oracle Database.
    Example: 6488359.3456712
Nested Schema : after-x-anyOf[1]
Match One
Show Source
  • Minimum Length: 3
    Maximum Length: 37
    Pattern: ^([0-9]+[:][0-9]+)$
    Commit Sequence Number pattern(Legacy) for MySQL Database.
    Example: 6488359:564781
  • Minimum Length: 77
    Maximum Length: 77
    Pattern: ^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$
    CSN pattern(GTID format) for MySQL Database.
    Example: 00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654
Nested Schema : after-x-anyOf[4]
Match One
Show Source
  • Minimum Value: 1
    Maximum Value: 18446744073709552000
    Commit Sequence Number pattern (Legacy) for DB2400 Database.
    Example: 78654321
  • Minimum Length: 32
    Maximum Length: 32
    Pattern: ^([a-fA-F0-9]{32})$
    Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.
    Example: F0B4993FD22315E5F0B4993FD22315E5
Nested Schema : at-x-anyOf[0]
Match One
Show Source
  • Minimum Value: 0
    Maximum Value: 9223372036854776000
    System Change Number(Normal Format) for Oracle Database.
    Example: 6488359
  • Minimum Length: 3
    Maximum Length: 64
    Pattern: [0-9]+[.][0-9]+
    System Change Number(Alternate Format) for Oracle Database.
    Example: 6488359.3456712
Nested Schema : at-x-anyOf[1]
Match One
Show Source
  • Minimum Length: 3
    Maximum Length: 37
    Pattern: ^([0-9]+[:][0-9]+)$
    Commit Sequence Number pattern(Legacy) for MySQL Database.
    Example: 6488359:564781
  • Minimum Length: 77
    Maximum Length: 77
    Pattern: ^[0-9]{20}[:][0-9a-fA-F]{8}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{4}[-][0-9a-fA-F]{12}[:][0-9]{19}$
    CSN pattern(GTID format) for MySQL Database.
    Example: 00000000000000000001:f77024f9-f4e3-11eb-a052-0021f6e03f10:0000000000000010654
Nested Schema : at-x-anyOf[4]
Match One
Show Source
  • Minimum Value: 1
    Maximum Value: 18446744073709552000
    Commit Sequence Number pattern (Legacy) for DB2400 Database.
    Example: 78654321
  • Minimum Length: 32
    Maximum Length: 32
    Pattern: ^([a-fA-F0-9]{32})$
    Commit Sequence Number pattern (Receiver timestamp and sequence number) for DB2400 Database.
    Example: F0B4993FD22315E5F0B4993FD22315E5
Nested Schema : thresholds
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 2
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : units
Match One
Show Source
  • Allowed Values: [ "seconds" ]
  • Allowed Values: [ "minutes" ]
  • Allowed Values: [ "hours" ]
Nested Schema : credentials
Credentials for database
Default Value: oracle.doceng.json.BetterJsonNull@10a0d93a
Match One
Show Source
Nested Schema : credentials-x-oneOf[0]
Type: object
Show Source
  • Allowed Values: [ "ogg:credentialsRef" ]
  • Minimum Length: 1
    Maximum Length: 30
    Pattern: ^[a-zA-Z][a-zA-Z0-9_#$]*$
  • Minimum Length: 1
    Maximum Length: 30
    Default Value: OracleGoldenGate
    Pattern: ^[a-zA-Z][a-zA-Z0-9_#$]*$
Nested Schema : credentials
Type: object
Credentials for database
Show Source
  • Allowed Values: [ "ogg:credentialsRef" ]
  • Minimum Length: 1
    Maximum Length: 30
    Pattern: ^[a-zA-Z][a-zA-Z0-9_#$]*$
  • Minimum Length: 1
    Maximum Length: 30
    Default Value: OracleGoldenGate
    Pattern: ^[a-zA-Z][a-zA-Z0-9_#$]*$
Nested Schema : specification
The name of a schema which can include wildcard characters
Match Any
Show Source
  • Minimum Length: 1
    Maximum Length: 130
    Pattern: ^([^."]{1,128}|["].{1,128}["])$
  • Minimum Length: 3
    Maximum Length: 261
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
Nested Schema : credentials
Type: object
Credentials for database
Show Source
  • Allowed Values: [ "ogg:credentialsRef" ]
  • Minimum Length: 1
    Maximum Length: 30
    Pattern: ^[a-zA-Z][a-zA-Z0-9_#$]*$
  • Minimum Length: 1
    Maximum Length: 30
    Default Value: OracleGoldenGate
    Pattern: ^[a-zA-Z][a-zA-Z0-9_#$]*$
Nested Schema : specification
The name of a table or a group of tables which can include wildcard characters
Match Any
Show Source
  • Minimum Length: 3
    Maximum Length: 261
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
  • Minimum Length: 5
    Maximum Length: 392
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
Nested Schema : credentials
Type: object
Credentials for database
Show Source
  • Allowed Values: [ "ogg:credentialsRef" ]
  • Minimum Length: 1
    Maximum Length: 30
    Pattern: ^[a-zA-Z][a-zA-Z0-9_#$]*$
  • Minimum Length: 1
    Maximum Length: 30
    Default Value: OracleGoldenGate
    Pattern: ^[a-zA-Z][a-zA-Z0-9_#$]*$
Nested Schema : specification
The name of a checkpoint table or a group of checkpoint tables which can include wildcard characters
Match Any
Show Source
  • Minimum Length: 3
    Maximum Length: 261
    Pattern: ^([^."]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
  • Minimum Length: 5
    Maximum Length: 392
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
Nested Schema : credentials
Type: object
Credentials for database
Show Source
  • Allowed Values: [ "ogg:credentialsRef" ]
  • Minimum Length: 1
    Maximum Length: 30
    Pattern: ^[a-zA-Z][a-zA-Z0-9_#$]*$
  • Minimum Length: 1
    Maximum Length: 30
    Default Value: OracleGoldenGate
    Pattern: ^[a-zA-Z][a-zA-Z0-9_#$]*$
Nested Schema : keep
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 1
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : units
Match One
Show Source
  • Allowed Values: [ "checkpoints" ]
Nested Schema : credentials
Type: object
Credentials for database
Show Source
  • Allowed Values: [ "ogg:credentialsRef" ]
  • Minimum Length: 1
    Maximum Length: 30
    Pattern: ^[a-zA-Z][a-zA-Z0-9_#$]*$
  • Minimum Length: 1
    Maximum Length: 30
    Default Value: OracleGoldenGate
    Pattern: ^[a-zA-Z][a-zA-Z0-9_#$]*$
Nested Schema : keep
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 2
Show Source
Nested Schema : items
Match One
Show Source
Nested Schema : items-x-oneOf[0]
Type: object
Minimum number of hours
Show Source
Nested Schema : items-x-oneOf[1]
Type: object
Maximum number of hours
Show Source
Nested Schema : items-x-oneOf[2]
Type: object
Minimum number of days
Show Source
Nested Schema : items-x-oneOf[3]
Type: object
Maximum number of days
Show Source
Nested Schema : keep
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 1
Show Source
Nested Schema : trails
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 1024
Trails to purge
Show Source
Nested Schema : items
Match One
Show Source
Nested Schema : items-x-oneOf[0]
Type: object
Minimum number of hours
Show Source
Nested Schema : items-x-oneOf[1]
Type: object
Minimum number of days
Show Source
Nested Schema : items-x-oneOf[2]
Type: object
Minimum number of files
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : name
Match One
Show Source
  • Minimum Length: 1
    Maximum Length: 2
    Pattern: ^[A-Za-z*][A-Za-z0-9*]?$
    The name of the trail, wildcards allowed
  • Allowed Values: [ "*/*" ]
    All trails, including subdirectories
Nested Schema : archiveTarget
Match One
Show Source
Nested Schema : sequences
Type: object
Optional range of trail sequences to process. If not present, all sequences in a trail are processed.
Show Source
Nested Schema : trails
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 1024
Trails to process
Show Source
Nested Schema : archiveTarget-x-oneOf[1]
Type: object
OCI Object Storage Bucket
Show Source
Nested Schema : archiveTarget-x-oneOf[2]
Type: object
S3-compatible object storage bucket
Show Source
Nested Schema : authentication
Match One
Show Source
Nested Schema : authentication-x-oneOf[0]
Type: object
Authentication using a named profile from the default profile configuration file
Show Source
Nested Schema : authentication-x-oneOf[1]
Type: object
Authentication for OCI using an instance principal
Show Source
Nested Schema : authentication-x-oneOf[2]
Type: object
Authentication for OCI using an API signing key for a user
Show Source
Nested Schema : authentication
Match One
Show Source
Nested Schema : authentication-x-oneOf[0]
Type: object
Authentication using a named profile from the default profile configuration file
Show Source
Nested Schema : authentication-x-oneOf[1]
Type: object
S3 Authentication using secrets
Show Source
Nested Schema : items
Type: object
Show Source
  • Minimum Length: 1
    Maximum Length: 2
    Pattern: ^[A-Za-z*][A-Za-z0-9*]?$
    The name of the trail, wildcards allowed
  • Minimum Length: 1
    Maximum Length: 4096
    The path where trail data is stored
Nested Schema : keep
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 1
Show Source
Nested Schema : items
Match One
Show Source
Nested Schema : items-x-oneOf[0]
Type: object
Minimum number of hours
Show Source
Nested Schema : items-x-oneOf[1]
Type: object
Minimum number of days
Show Source
Nested Schema : keep
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 1
Show Source
Nested Schema : items
Match One
Show Source
Nested Schema : items-x-oneOf[0]
Type: object
Minimum number of hours
Show Source
Nested Schema : items-x-oneOf[1]
Type: object
Minimum number of days
Show Source
Nested Schema : credentials
Type: object
Credentials for database
Show Source
  • Allowed Values: [ "ogg:credentialsRef" ]
  • Minimum Length: 1
    Maximum Length: 30
    Pattern: ^[a-zA-Z][a-zA-Z0-9_#$]*$
  • Minimum Length: 1
    Maximum Length: 30
    Default Value: OracleGoldenGate
    Pattern: ^[a-zA-Z][a-zA-Z0-9_#$]*$
Nested Schema : keep
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 1
Show Source
Nested Schema : items
Match One
Show Source
Nested Schema : items-x-oneOf[0]
Type: object
Maximum number of hours
Show Source
Nested Schema : items-x-oneOf[1]
Type: object
Maximum number of days
Show Source
Nested Schema : credentials
Type: object
Credentials for database
Show Source
  • Allowed Values: [ "ogg:credentialsRef" ]
  • Minimum Length: 1
    Maximum Length: 30
    Pattern: ^[a-zA-Z][a-zA-Z0-9_#$]*$
  • Minimum Length: 1
    Maximum Length: 30
    Default Value: OracleGoldenGate
    Pattern: ^[a-zA-Z][a-zA-Z0-9_#$]*$
Nested Schema : sequence
The owner and name of a database sequence. The schema name cannot be null. You can use wildcard characters for the sequence name but not for the owner name.
Match Any
Show Source
  • Minimum Length: 1
    Maximum Length: 130
    Pattern: ^([^."]{1,128}|["].{1,128}["])$
  • Minimum Length: 3
    Maximum Length: 261
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
  • Minimum Length: 5
    Maximum Length: 392
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
Example Request (application/json)
{
    "name":"report",
    "reportType":"lag",
    "thresholds":[
        {
            "type":"info",
            "units":"seconds",
            "value":"0"
        },
        {
            "type":"critical",
            "units":"seconds",
            "value":"5"
        }
    ]
}
Back to Top

Response

Supported Media Types

200 Response

Command successfully executed.

Body ()
Root Schema : Oracle GoldenGate Task Manager Command Result
Type: object
Title: Oracle GoldenGate Task Manager Command Result
Show Source
Nested Schema : containers
Type: array
Minimum Number of Items: 0
Maximum Number of Items: 32767
Show Source
Nested Schema : items
Type: array
Minimum Number of Items: 0
Maximum Number of Items: 1024
Show Source
Nested Schema : messages
Type: array
Minimum Number of Items: 0
Maximum Number of Items: 1024
Show Source
Nested Schema : schemas
Type: array
Minimum Number of Items: 0
Maximum Number of Items: 32767
Show Source
Nested Schema : tables
Type: array
Minimum Number of Items: 0
Maximum Number of Items: 32767
Show Source
Nested Schema : versions
Type: object
Show Source
Nested Schema : items
Match One
Show Source
  • Minimum Length: 1
    Maximum Length: 130
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])$
Nested Schema : items
Match One
Show Source
Nested Schema : items-x-oneOf[0]
Type: object
Show Source
Nested Schema : items-x-oneOf[1]
Type: object
Show Source
Nested Schema : result
Match One
Show Source
Nested Schema : result-x-oneOf[1]
Type: object
Report on Process Lag
Show Source
Nested Schema : items
Type: object
Show Source
  • Allowed Values: [ "ogg:message" ]
  • Minimum Length: 9
    Maximum Length: 9
    Pattern: ^OGG[-][0-9]{5}$
    The Oracle GoldenGate message code
  • Minimum Length: 20
    Maximum Length: 32
    Pattern: ^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$
    The date and time that the message was issued
  • Allowed Values: [ "INFO", "WARNING", "ERROR" ]
    The severity of the message
  • Minimum Length: 1
    Maximum Length: 4095
    A human-readable description that provides information and detail specific to this occurence of the information, warning or error.
  • Minimum Length: 2
    Maximum Length: 4095
    Pattern: ^[a-zA-Z][a-zA-Z0-9+-.]*:[^ \t]*$
    An absolute URI [RFC3986] to a page that describes the info, warning or error type.
Nested Schema : items
Match Any
Show Source
  • Minimum Length: 1
    Maximum Length: 130
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])$
  • Minimum Length: 3
    Maximum Length: 261
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
Nested Schema : items
Match Any
Show Source
  • Minimum Length: 3
    Maximum Length: 261
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
  • Minimum Length: 5
    Maximum Length: 392
    Pattern: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])$
Nested Schema : build
Type: object
Oracle GoldenGate build information
Show Source
Nested Schema : database
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 100
Database version information
Show Source
Nested Schema : operatingSystem
Operating System version information
Match One
Show Source
Nested Schema : operatingSystem-x-oneOf[0]
Type: object
Show Source
Nested Schema : operatingSystem-x-oneOf[1]
Type: object
Show Source
Example Response (application/json)
{
    "$schema":"api:standardResponse",
    "links":[
        {
            "href":"http://localhost:9012/services/v2/commands/execute",
            "mediaType":"application/json",
            "rel":"canonical"
        },
        {
            "href":"http://localhost:9012/services/v2/commands/execute",
            "mediaType":"application/json",
            "rel":"self"
        }
    ],
    "messages":[
        {
            "$schema":"ogg:message",
            "code":"OGG-02950",
            "issued":"2024-04-03T22:36:16Z",
            "severity":"INFO",
            "title":"Lag for Extract group EXTN is 0:00:03.965 (checkpoint updated 0:00:52.638 ago).",
            "type":"https://docs.oracle.com/en/middleware/goldengate/core/23.4/error-messages/"
        },
        {
            "$schema":"ogg:message",
            "code":"OGG-02953",
            "issued":"2024-04-03T22:36:16Z",
            "severity":"INFO",
            "title":"Lag for Replicat group REPS is 0:00:00.000 (checkpoint updated 0:00:00.290 ago).",
            "type":"https://docs.oracle.com/en/middleware/goldengate/core/23.4/error-messages/"
        }
    ],
    "response":{
        "$schema":"ogg:commandResult",
        "items":[
            {
                "processName":"EXTN",
                "processType":"extract",
                "result":{
                    "lag":"0:00:03.965",
                    "lagSeconds":"3.965",
                    "lastCheckpoint":"0:00:52.638",
                    "lastCheckpointSeconds":"52.638"
                },
                "severity":"info"
            },
            {
                "processName":"REPS",
                "processType":"replicat",
                "result":{
                    "lag":"0:00:00.000",
                    "lagSeconds":"0",
                    "lastCheckpoint":"0:00:00.290",
                    "lastCheckpointSeconds":"0.29"
                },
                "severity":"info"
            }
        ]
    }
}
Back to Top