- Oracle GoldenGate
- Tasks
- Administrative Server
- Replicats
post
/services/{version}/replicats/{replicat}/command
Execute a Replicat process command
Request
Supported Media Types
- application/json
Path Parameters
-
replicat: string
Minimum Length:
1
Maximum Length:8
Pattern:^[A-Z_$][A-Z0-9_$]*$
The name of the replicat. Replicat names are upper case, begin with an alphabetic character followed by up to seven alpha-numeric characters.
-
version: string
Oracle GoldenGate Service API version.
Allowed Values:[ "v2" ]
Body ()
Root Schema : Describes a command for an ER process to execute
Title:
Describes a command for an ER process to execute
Match One
Show Source
-
object Describes a command for an ER process to execute-x-oneOf[0]
-
object Describes a command for an ER process to execute-x-oneOf[1]
-
object Describes a command for an ER process to execute-x-oneOf[2]
-
object Describes a command for an ER process to execute-x-oneOf[3]
{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:command"
]
},
"command":{
"enum":[
"FORCESTOP",
"GETLAG",
"GETTCPSTATS",
"LOGEND",
"LOGSTATS",
"REPORT",
"RESETTCPSTATS",
"RESUME",
"ROLLOVER",
"STATUS",
"STOP"
]
}
},
"required":[
"command"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:command"
]
},
"command":{
"enum":[
"BR",
"CACHEMGR",
"DEPINFO",
"DEPENDENCYINFO",
"FORCETRANS",
"GETPARAMINFO",
"HANDLECOLLISIONS",
"NOHANDLECOLLISIONS",
"PROBE",
"RTC",
"SHOWTRANS",
"SKIPTRANS",
"STATS",
"TRACE",
"TRACE2",
"TRACEINIT",
"TRANLOGOPTIONS"
]
},
"arguments":{
"type":"string",
"minLength":1,
"maxLength":4095
}
},
"required":[
"command"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:command"
]
},
"command":{
"type":"string",
"pattern":"^(INTEGRATEDPARAMS)[ ]*[(].*[)]$",
"minLength":1,
"maxLength":4095
}
},
"required":[
"command"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:command"
]
},
"command":{
"enum":[
"INFO"
]
},
"arguments":{
"type":"string",
"minLength":1,
"maxLength":4095
},
"credentials":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:credentialsRef"
]
},
"domain":{
"type":"string",
"pattern":"^[a-zA-Z][a-zA-Z0-9_#$]*$",
"minLength":1,
"maxLength":30,
"default":"OracleGoldenGate"
},
"alias":{
"type":"string",
"pattern":"^[a-zA-Z][a-zA-Z0-9_#$]*$",
"minLength":1,
"maxLength":30
}
},
"required":[
"alias"
],
"additionalProperties":false
}
},
"required":[
"command"
],
"additionalProperties":false
}
],
"title":"Describes a command for an ER process to execute"
}
Nested Schema : Describes a command for an ER process to execute-x-oneOf[0]
Type:
Show Source
object
-
$schema:
Allowed Values:
[ "er:command" ]
-
command:
Allowed Values:
[ "FORCESTOP", "GETLAG", "GETTCPSTATS", "LOGEND", "LOGSTATS", "REPORT", "RESETTCPSTATS", "RESUME", "ROLLOVER", "STATUS", "STOP" ]
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:command"
]
},
"command":{
"enum":[
"FORCESTOP",
"GETLAG",
"GETTCPSTATS",
"LOGEND",
"LOGSTATS",
"REPORT",
"RESETTCPSTATS",
"RESUME",
"ROLLOVER",
"STATUS",
"STOP"
]
}
},
"required":[
"command"
],
"additionalProperties":false
}
Nested Schema : Describes a command for an ER process to execute-x-oneOf[1]
Type:
Show Source
object
-
$schema:
Allowed Values:
[ "er:command" ]
-
arguments:
string
Minimum Length:
1
Maximum Length:4095
-
command:
Allowed Values:
[ "BR", "CACHEMGR", "DEPINFO", "DEPENDENCYINFO", "FORCETRANS", "GETPARAMINFO", "HANDLECOLLISIONS", "NOHANDLECOLLISIONS", "PROBE", "RTC", "SHOWTRANS", "SKIPTRANS", "STATS", "TRACE", "TRACE2", "TRACEINIT", "TRANLOGOPTIONS" ]
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:command"
]
},
"command":{
"enum":[
"BR",
"CACHEMGR",
"DEPINFO",
"DEPENDENCYINFO",
"FORCETRANS",
"GETPARAMINFO",
"HANDLECOLLISIONS",
"NOHANDLECOLLISIONS",
"PROBE",
"RTC",
"SHOWTRANS",
"SKIPTRANS",
"STATS",
"TRACE",
"TRACE2",
"TRACEINIT",
"TRANLOGOPTIONS"
]
},
"arguments":{
"type":"string",
"minLength":1,
"maxLength":4095
}
},
"required":[
"command"
],
"additionalProperties":false
}
Nested Schema : Describes a command for an ER process to execute-x-oneOf[2]
Type:
Show Source
object
-
$schema:
Allowed Values:
[ "er:command" ]
-
command:
string
Minimum Length:
1
Maximum Length:4095
Pattern:^(INTEGRATEDPARAMS)[ ]*[(].*[)]$
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:command"
]
},
"command":{
"type":"string",
"pattern":"^(INTEGRATEDPARAMS)[ ]*[(].*[)]$",
"minLength":1,
"maxLength":4095
}
},
"required":[
"command"
],
"additionalProperties":false
}
Nested Schema : Describes a command for an ER process to execute-x-oneOf[3]
Type:
Show Source
object
-
$schema:
Allowed Values:
[ "er:command" ]
-
arguments:
string
Minimum Length:
1
Maximum Length:4095
-
command:
Allowed Values:
[ "INFO" ]
-
credentials:
object credentials
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:command"
]
},
"command":{
"enum":[
"INFO"
]
},
"arguments":{
"type":"string",
"minLength":1,
"maxLength":4095
},
"credentials":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:credentialsRef"
]
},
"domain":{
"type":"string",
"pattern":"^[a-zA-Z][a-zA-Z0-9_#$]*$",
"minLength":1,
"maxLength":30,
"default":"OracleGoldenGate"
},
"alias":{
"type":"string",
"pattern":"^[a-zA-Z][a-zA-Z0-9_#$]*$",
"minLength":1,
"maxLength":30
}
},
"required":[
"alias"
],
"additionalProperties":false
}
},
"required":[
"command"
],
"additionalProperties":false
}
Nested Schema : credentials
Type:
Show Source
object
-
$schema:
Allowed Values:
[ "ogg:credentialsRef" ]
-
alias:
string
Minimum Length:
1
Maximum Length:30
Pattern:^[a-zA-Z][a-zA-Z0-9_#$]*$
-
domain:
string
Minimum Length:
1
Maximum Length:30
Default Value:OracleGoldenGate
Pattern:^[a-zA-Z][a-zA-Z0-9_#$]*$
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:credentialsRef"
]
},
"domain":{
"type":"string",
"pattern":"^[a-zA-Z][a-zA-Z0-9_#$]*$",
"minLength":1,
"maxLength":30,
"default":"OracleGoldenGate"
},
"alias":{
"type":"string",
"pattern":"^[a-zA-Z][a-zA-Z0-9_#$]*$",
"minLength":1,
"maxLength":30
}
},
"required":[
"alias"
],
"additionalProperties":false
}
Example Request (application/json)
{
"command":"STATS",
"arguments":"HOURLY"
}
Response
Supported Media Types
- application/json
200 Response
Command executed successfully.
Body ()
Root Schema : Describes the results from an ER process executing a command
Type:
object
Title:
Show Source
Describes the results from an ER process executing a command
-
$schema:
Allowed Values:
[ "er:commandResult" ]
-
reply:
reply
-
replyData:
replyData
{
"title":"Describes the results from an ER process executing a command",
"required":[
"reply"
],
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:commandResult"
]
},
"reply":{
"x-oneOf":[
{
"type":"string",
"minLength":0,
"maxLength":29996
},
{
"type":"array",
"items":{
"type":"string",
"minLength":0,
"maxLength":4095
},
"minItems":0,
"maxItems":32767
}
]
},
"replyData":{
"x-anyOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:getLagResult"
]
},
"lagResult":{
"x-oneOf":[
{
"type":"object",
"properties":{
"lastRecordLag":{
"description":"Last record lag in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"lowWatermarkLag":{
"description":"Low watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"highWatermarkLag":{
"description":"High watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"eof":{
"description":"Whether the process is at EOF",
"type":"boolean"
},
"redoxportlag":{
"type":"array",
"items":{
"type":"object",
"properties":{
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18
},
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
}
}
},
"minItems":1,
"maxItems":500
},
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"deferApplyDelay":{
"description":"Defer apply delay in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"lowWatermarkPosition":{
"description":"Low watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
},
"extdetail":{
"type":"object",
"properties":{
"downstream":{
"description":"Indicates if downstream is configured",
"type":"boolean"
},
"conntosrcdb":{
"description":"Indicates if conn to src db exists",
"type":"boolean"
},
"orlcount":{
"description":"Number of ORLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"maxorlsize":{
"description":"Maximum size of ORL",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"srlcount":{
"description":"Number of SRLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"minsrlsize":{
"description":"Minimum size of SRL",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
}
},
"highWatermarkPosition":{
"description":"High watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
}
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
},
{
"threads":{
"type":"array",
"items":{
"type":"object",
"properties":{
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"minItems":1,
"maxItems":500
},
"minLag":{
"description":"Minimum thread lag value information",
"type":"object",
"properties":{
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"maxLag":{
"description":"Maximum thread lag value information",
"type":"object",
"properties":{
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"avgLag":{
"description":"Average lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
}
]
}
},
"required":[
"lagResult"
]
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:logEndResult"
]
},
"allRecordsProcessed":{
"description":"Whether or not Extract has processed all of the records in the data source.",
"type":"boolean"
}
},
"required":[
"allRecordsProcessed"
]
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:statusResult"
]
},
"status":{
"x-oneOf":[
{
"numThreadsWaiting":{
"description":"Number of threads in waiting status",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"processId":{
"description":"OS process id",
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"groupName":{
"description":"Process group name",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"replicatReadingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
},
"processType":{
"enum":[
"replicat"
]
},
"currentApplyParallelism":{
"description":"Current Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"numRecords":{
"description":"Total number of records",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"status":{
"description":"OGG status of the process",
"type":"string",
"minLength":1,
"maxLength":1024
},
"maxApplyParallelism":{
"description":"Maximum Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"mapParallelism":{
"description":"Map Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"logicalEof":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atTrailRBA"
]
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"sequence"
],
"additionalProperties":false
},
"numSkippedRecords":{
"description":"Number of skipped records",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"physicalEof":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atTrailRBA"
]
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"sequence"
],
"additionalProperties":false
},
"minApplyParallelism":{
"description":"Minimum Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
}
},
{
"processType":{
"enum":[
"extract"
]
},
"groupName":{
"description":"Process group name",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"processId":{
"description":"OS process id",
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"status":{
"description":"OGG status of the process",
"type":"string",
"minLength":1,
"maxLength":1024
},
"extractReadingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"dbms:positionInfo"
]
},
"position":{
"x-oneOf":[
{
"type":"object",
"properties":{
"redoThread":{
"type":"integer",
"minimum":1,
"maximum":1024
},
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
"timestamp":{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
"seqno":{
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"redoThread",
"csn",
"timestamp",
"seqno",
"rba"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"table":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":3,
"maxLength":261
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":5,
"maxLength":392
}
]
}
]
},
"recordNumber":{
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"timestamp":{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
}
},
"required":[
"table",
"recordNumber",
"timestamp"
],
"additionalProperties":false
}
]
}
}
}
]
},
"minItems":1,
"maxItems":32767
},
"extractWritingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
}
}
]
}
}
},
{
"type":"object"
}
]
}
}
}
Nested Schema : reply
Match One
Show Source
-
string
Minimum Length:
0
Maximum Length:29996
-
array reply-x-oneOf[1]
Minimum Number of Items:
0
Maximum Number of Items:32767
{
"x-oneOf":[
{
"type":"string",
"minLength":0,
"maxLength":29996
},
{
"type":"array",
"items":{
"type":"string",
"minLength":0,
"maxLength":4095
},
"minItems":0,
"maxItems":32767
}
]
}
Nested Schema : replyData
Match Any
Show Source
-
object replyData-x-anyOf[0]
-
object replyData-x-anyOf[1]
-
object replyData-x-anyOf[2]
-
object replyData-x-anyOf[3]
{
"x-anyOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:getLagResult"
]
},
"lagResult":{
"x-oneOf":[
{
"type":"object",
"properties":{
"lastRecordLag":{
"description":"Last record lag in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"lowWatermarkLag":{
"description":"Low watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"highWatermarkLag":{
"description":"High watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"eof":{
"description":"Whether the process is at EOF",
"type":"boolean"
},
"redoxportlag":{
"type":"array",
"items":{
"type":"object",
"properties":{
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18
},
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
}
}
},
"minItems":1,
"maxItems":500
},
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"deferApplyDelay":{
"description":"Defer apply delay in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"lowWatermarkPosition":{
"description":"Low watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
},
"extdetail":{
"type":"object",
"properties":{
"downstream":{
"description":"Indicates if downstream is configured",
"type":"boolean"
},
"conntosrcdb":{
"description":"Indicates if conn to src db exists",
"type":"boolean"
},
"orlcount":{
"description":"Number of ORLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"maxorlsize":{
"description":"Maximum size of ORL",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"srlcount":{
"description":"Number of SRLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"minsrlsize":{
"description":"Minimum size of SRL",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
}
},
"highWatermarkPosition":{
"description":"High watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
}
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
},
{
"threads":{
"type":"array",
"items":{
"type":"object",
"properties":{
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"minItems":1,
"maxItems":500
},
"minLag":{
"description":"Minimum thread lag value information",
"type":"object",
"properties":{
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"maxLag":{
"description":"Maximum thread lag value information",
"type":"object",
"properties":{
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"avgLag":{
"description":"Average lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
}
]
}
},
"required":[
"lagResult"
]
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:logEndResult"
]
},
"allRecordsProcessed":{
"description":"Whether or not Extract has processed all of the records in the data source.",
"type":"boolean"
}
},
"required":[
"allRecordsProcessed"
]
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:statusResult"
]
},
"status":{
"x-oneOf":[
{
"numThreadsWaiting":{
"description":"Number of threads in waiting status",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"processId":{
"description":"OS process id",
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"groupName":{
"description":"Process group name",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"replicatReadingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
},
"processType":{
"enum":[
"replicat"
]
},
"currentApplyParallelism":{
"description":"Current Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"numRecords":{
"description":"Total number of records",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"status":{
"description":"OGG status of the process",
"type":"string",
"minLength":1,
"maxLength":1024
},
"maxApplyParallelism":{
"description":"Maximum Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"mapParallelism":{
"description":"Map Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"logicalEof":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atTrailRBA"
]
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"sequence"
],
"additionalProperties":false
},
"numSkippedRecords":{
"description":"Number of skipped records",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"physicalEof":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atTrailRBA"
]
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"sequence"
],
"additionalProperties":false
},
"minApplyParallelism":{
"description":"Minimum Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
}
},
{
"processType":{
"enum":[
"extract"
]
},
"groupName":{
"description":"Process group name",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"processId":{
"description":"OS process id",
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"status":{
"description":"OGG status of the process",
"type":"string",
"minLength":1,
"maxLength":1024
},
"extractReadingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"dbms:positionInfo"
]
},
"position":{
"x-oneOf":[
{
"type":"object",
"properties":{
"redoThread":{
"type":"integer",
"minimum":1,
"maximum":1024
},
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
"timestamp":{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
"seqno":{
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"redoThread",
"csn",
"timestamp",
"seqno",
"rba"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"table":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":3,
"maxLength":261
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":5,
"maxLength":392
}
]
}
]
},
"recordNumber":{
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"timestamp":{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
}
},
"required":[
"table",
"recordNumber",
"timestamp"
],
"additionalProperties":false
}
]
}
}
}
]
},
"minItems":1,
"maxItems":32767
},
"extractWritingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
}
}
]
}
}
},
{
"type":"object"
}
]
}
Nested Schema : reply-x-oneOf[1]
Type:
array
Minimum Number of Items:
0
Maximum Number of Items:
Show Source
32767
-
[0]:
string
Minimum Length:
0
Maximum Length:4095
{
"type":"array",
"items":{
"type":"string",
"minLength":0,
"maxLength":4095
},
"minItems":0,
"maxItems":32767
}
Nested Schema : replyData-x-anyOf[0]
Type:
Show Source
object
-
$schema:
Allowed Values:
[ "er:getLagResult" ]
-
lagResult:
lagResult
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:getLagResult"
]
},
"lagResult":{
"x-oneOf":[
{
"type":"object",
"properties":{
"lastRecordLag":{
"description":"Last record lag in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"lowWatermarkLag":{
"description":"Low watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"highWatermarkLag":{
"description":"High watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"eof":{
"description":"Whether the process is at EOF",
"type":"boolean"
},
"redoxportlag":{
"type":"array",
"items":{
"type":"object",
"properties":{
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18
},
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
}
}
},
"minItems":1,
"maxItems":500
},
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"deferApplyDelay":{
"description":"Defer apply delay in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"lowWatermarkPosition":{
"description":"Low watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
},
"extdetail":{
"type":"object",
"properties":{
"downstream":{
"description":"Indicates if downstream is configured",
"type":"boolean"
},
"conntosrcdb":{
"description":"Indicates if conn to src db exists",
"type":"boolean"
},
"orlcount":{
"description":"Number of ORLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"maxorlsize":{
"description":"Maximum size of ORL",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"srlcount":{
"description":"Number of SRLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"minsrlsize":{
"description":"Minimum size of SRL",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
}
},
"highWatermarkPosition":{
"description":"High watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
}
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
},
{
"threads":{
"type":"array",
"items":{
"type":"object",
"properties":{
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"minItems":1,
"maxItems":500
},
"minLag":{
"description":"Minimum thread lag value information",
"type":"object",
"properties":{
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"maxLag":{
"description":"Maximum thread lag value information",
"type":"object",
"properties":{
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"avgLag":{
"description":"Average lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
}
]
}
},
"required":[
"lagResult"
]
}
Nested Schema : replyData-x-anyOf[1]
Type:
Show Source
object
-
$schema:
Allowed Values:
[ "er:logEndResult" ]
-
allRecordsProcessed:
boolean
Whether or not Extract has processed all of the records in the data source.
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:logEndResult"
]
},
"allRecordsProcessed":{
"description":"Whether or not Extract has processed all of the records in the data source.",
"type":"boolean"
}
},
"required":[
"allRecordsProcessed"
]
}
Nested Schema : replyData-x-anyOf[2]
Type:
Show Source
object
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:statusResult"
]
},
"status":{
"x-oneOf":[
{
"numThreadsWaiting":{
"description":"Number of threads in waiting status",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"processId":{
"description":"OS process id",
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"groupName":{
"description":"Process group name",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"replicatReadingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
},
"processType":{
"enum":[
"replicat"
]
},
"currentApplyParallelism":{
"description":"Current Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"numRecords":{
"description":"Total number of records",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"status":{
"description":"OGG status of the process",
"type":"string",
"minLength":1,
"maxLength":1024
},
"maxApplyParallelism":{
"description":"Maximum Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"mapParallelism":{
"description":"Map Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"logicalEof":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atTrailRBA"
]
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"sequence"
],
"additionalProperties":false
},
"numSkippedRecords":{
"description":"Number of skipped records",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"physicalEof":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atTrailRBA"
]
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"sequence"
],
"additionalProperties":false
},
"minApplyParallelism":{
"description":"Minimum Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
}
},
{
"processType":{
"enum":[
"extract"
]
},
"groupName":{
"description":"Process group name",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"processId":{
"description":"OS process id",
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"status":{
"description":"OGG status of the process",
"type":"string",
"minLength":1,
"maxLength":1024
},
"extractReadingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"dbms:positionInfo"
]
},
"position":{
"x-oneOf":[
{
"type":"object",
"properties":{
"redoThread":{
"type":"integer",
"minimum":1,
"maximum":1024
},
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
"timestamp":{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
"seqno":{
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"redoThread",
"csn",
"timestamp",
"seqno",
"rba"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"table":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":3,
"maxLength":261
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":5,
"maxLength":392
}
]
}
]
},
"recordNumber":{
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"timestamp":{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
}
},
"required":[
"table",
"recordNumber",
"timestamp"
],
"additionalProperties":false
}
]
}
}
}
]
},
"minItems":1,
"maxItems":32767
},
"extractWritingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
}
}
]
}
}
}
Nested Schema : replyData-x-anyOf[3]
Type:
object
Nested Schema : lagResult
Match One
Show Source
{
"x-oneOf":[
{
"type":"object",
"properties":{
"lastRecordLag":{
"description":"Last record lag in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"lowWatermarkLag":{
"description":"Low watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"highWatermarkLag":{
"description":"High watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"eof":{
"description":"Whether the process is at EOF",
"type":"boolean"
},
"redoxportlag":{
"type":"array",
"items":{
"type":"object",
"properties":{
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18
},
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
}
}
},
"minItems":1,
"maxItems":500
},
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"deferApplyDelay":{
"description":"Defer apply delay in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"lowWatermarkPosition":{
"description":"Low watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
},
"extdetail":{
"type":"object",
"properties":{
"downstream":{
"description":"Indicates if downstream is configured",
"type":"boolean"
},
"conntosrcdb":{
"description":"Indicates if conn to src db exists",
"type":"boolean"
},
"orlcount":{
"description":"Number of ORLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"maxorlsize":{
"description":"Maximum size of ORL",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"srlcount":{
"description":"Number of SRLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"minsrlsize":{
"description":"Minimum size of SRL",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
}
},
"highWatermarkPosition":{
"description":"High watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
}
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
},
{
"threads":{
"type":"array",
"items":{
"type":"object",
"properties":{
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"minItems":1,
"maxItems":500
},
"minLag":{
"description":"Minimum thread lag value information",
"type":"object",
"properties":{
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"maxLag":{
"description":"Maximum thread lag value information",
"type":"object",
"properties":{
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"avgLag":{
"description":"Average lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
}
]
}
Nested Schema : lagResult-x-oneOf[0]
Type:
Show Source
object
-
deferApplyDelay:
integer
Minimum Value:
1
Maximum Value:2147483647
Defer apply delay in seconds -
eof:
boolean
Whether the process is at EOF
-
extdetail:
object extdetail
-
highWatermarkLag:
integer
Minimum Value:
1
Maximum Value:2147483647
High watermark lag in seconds -
highWatermarkPosition:
highWatermarkPosition
High watermark position
-
lastRecordLag:
integer
Minimum Value:
1
Maximum Value:9.223372036854776E18
Last record lag in seconds -
lowWatermarkLag:
integer
Minimum Value:
1
Maximum Value:2147483647
Low watermark lag in seconds -
lowWatermarkPosition:
lowWatermarkPosition
Low watermark position
-
recordsProcessed:
boolean
Whether there are any records processed yet
-
redoxportlag:
array redoxportlag
Minimum Number of Items:
1
Maximum Number of Items:500
{
"type":"object",
"properties":{
"lastRecordLag":{
"description":"Last record lag in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"lowWatermarkLag":{
"description":"Low watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"highWatermarkLag":{
"description":"High watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"eof":{
"description":"Whether the process is at EOF",
"type":"boolean"
},
"redoxportlag":{
"type":"array",
"items":{
"type":"object",
"properties":{
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18
},
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
}
}
},
"minItems":1,
"maxItems":500
},
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"deferApplyDelay":{
"description":"Defer apply delay in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"lowWatermarkPosition":{
"description":"Low watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
},
"extdetail":{
"type":"object",
"properties":{
"downstream":{
"description":"Indicates if downstream is configured",
"type":"boolean"
},
"conntosrcdb":{
"description":"Indicates if conn to src db exists",
"type":"boolean"
},
"orlcount":{
"description":"Number of ORLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"maxorlsize":{
"description":"Maximum size of ORL",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"srlcount":{
"description":"Number of SRLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"minsrlsize":{
"description":"Minimum size of SRL",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
}
},
"highWatermarkPosition":{
"description":"High watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
}
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
}
Nested Schema : extdetail
Type:
Show Source
object
-
conntosrcdb:
boolean
Indicates if conn to src db exists
-
downstream:
boolean
Indicates if downstream is configured
-
maxorlsize:
integer
Minimum Value:
0
Maximum Value:2147483647
Maximum size of ORL -
minsrlsize:
integer
Minimum Value:
0
Maximum Value:2147483647
Minimum size of SRL -
orlcount:
integer
Minimum Value:
0
Maximum Value:2147483647
Number of ORLs -
srlcount:
integer
Minimum Value:
0
Maximum Value:2147483647
Number of SRLs
{
"type":"object",
"properties":{
"downstream":{
"description":"Indicates if downstream is configured",
"type":"boolean"
},
"conntosrcdb":{
"description":"Indicates if conn to src db exists",
"type":"boolean"
},
"orlcount":{
"description":"Number of ORLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"maxorlsize":{
"description":"Maximum size of ORL",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"srlcount":{
"description":"Number of SRLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"minsrlsize":{
"description":"Minimum size of SRL",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
}
}
Nested Schema : highWatermarkPosition
High watermark position
Match One
Show Source
-
object highWatermarkPosition-x-oneOf[0]
Position in archive logs (classic mode, non-threaded)
-
object highWatermarkPosition-x-oneOf[1]
Position in archive logs (classic mode, threaded)
-
object highWatermarkPosition-x-oneOf[2]
Position at a specific SCN (integrated mode)
{
"description":"High watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
}
Nested Schema : lowWatermarkPosition
Low watermark position
Match One
Show Source
-
object lowWatermarkPosition-x-oneOf[0]
Position in archive logs (classic mode, non-threaded)
-
object lowWatermarkPosition-x-oneOf[1]
Position in archive logs (classic mode, threaded)
-
object lowWatermarkPosition-x-oneOf[2]
Position at a specific SCN (integrated mode)
{
"description":"Low watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
}
Nested Schema : redoxportlag
Type:
array
Minimum Number of Items:
1
Maximum Number of Items:
Show Source
500
{
"type":"array",
"items":{
"type":"object",
"properties":{
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18
},
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
}
}
},
"minItems":1,
"maxItems":500
}
Nested Schema : highWatermarkPosition-x-oneOf[0]
Type:
object
Position in archive logs (classic mode, non-threaded)
Show Source
-
rba:
integer
Minimum Value:
0
Maximum Value:2147483647
Default Value:0
-
seqno:
integer
Minimum Value:
1
Maximum Value:4.294967295E9
Default Value:1
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
Match Any
Show Source
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
Nested Schema : highWatermarkPosition-x-oneOf[1]
Type:
object
Position in archive logs (classic mode, threaded)
Show Source
-
positions:
array positions
Minimum Number of Items:
1
Maximum Number of Items:100
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
}
Nested Schema : highWatermarkPosition-x-oneOf[2]
Type:
object
Position at a specific SCN (integrated mode)
Show Source
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
Nested Schema : positions
Type:
array
Minimum Number of Items:
1
Maximum Number of Items:
Show Source
100
-
[0]:
object items
Position in archive logs for one thread in a classic extract
{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
Nested Schema : items
Type:
object
Position in archive logs for one thread in a classic extract
Show Source
-
position:
position
-
thread:
integer
Minimum Value:
1
Maximum Value:100
{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
}
Nested Schema : position
Match One
Show Source
-
Allowed Values:
[ "now" ]
-
position-x-oneOf[1]
-
string
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])$
-
object position-x-oneOf[3]
Position in archive logs (classic mode, non-threaded)
{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
Nested Schema : position-x-oneOf[1]
Match One
Show Source
-
integer
Minimum Value:
1
Maximum Value:9.223372036854776E18
Normal format -
string
Minimum Length:
3
Maximum Length:64
Pattern:[0-9]+[.][0-9]+
Alternate format
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
Nested Schema : position-x-oneOf[3]
Type:
object
Position in archive logs (classic mode, non-threaded)
Show Source
-
rba:
integer
Minimum Value:
0
Maximum Value:2147483647
Default Value:0
-
seqno:
integer
Minimum Value:
1
Maximum Value:4.294967295E9
Default Value:1
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
Match Any
Show Source
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
Nested Schema : csn
Match One
Show Source
-
integer
Minimum Value:
1
Maximum Value:9.223372036854776E18
Normal format -
string
Minimum Length:
3
Maximum Length:64
Pattern:[0-9]+[.][0-9]+
Alternate format
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
Nested Schema : lowWatermarkPosition-x-oneOf[0]
Type:
object
Position in archive logs (classic mode, non-threaded)
Show Source
-
rba:
integer
Minimum Value:
0
Maximum Value:2147483647
Default Value:0
-
seqno:
integer
Minimum Value:
1
Maximum Value:4.294967295E9
Default Value:1
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
Match Any
Show Source
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
Nested Schema : lowWatermarkPosition-x-oneOf[1]
Type:
object
Position in archive logs (classic mode, threaded)
Show Source
-
positions:
array positions
Minimum Number of Items:
1
Maximum Number of Items:100
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
}
Nested Schema : lowWatermarkPosition-x-oneOf[2]
Type:
object
Position at a specific SCN (integrated mode)
Show Source
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
Nested Schema : positions
Type:
array
Minimum Number of Items:
1
Maximum Number of Items:
Show Source
100
-
[0]:
object items
Position in archive logs for one thread in a classic extract
{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
Nested Schema : items
Type:
object
Position in archive logs for one thread in a classic extract
Show Source
-
position:
position
-
thread:
integer
Minimum Value:
1
Maximum Value:100
{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
}
Nested Schema : position
Match One
Show Source
-
Allowed Values:
[ "now" ]
-
position-x-oneOf[1]
-
string
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])$
-
object position-x-oneOf[3]
Position in archive logs (classic mode, non-threaded)
{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
Nested Schema : position-x-oneOf[1]
Match One
Show Source
-
integer
Minimum Value:
1
Maximum Value:9.223372036854776E18
Normal format -
string
Minimum Length:
3
Maximum Length:64
Pattern:[0-9]+[.][0-9]+
Alternate format
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
Nested Schema : position-x-oneOf[3]
Type:
object
Position in archive logs (classic mode, non-threaded)
Show Source
-
rba:
integer
Minimum Value:
0
Maximum Value:2147483647
Default Value:0
-
seqno:
integer
Minimum Value:
1
Maximum Value:4.294967295E9
Default Value:1
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
Match Any
Show Source
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
Nested Schema : csn
Match One
Show Source
-
integer
Minimum Value:
1
Maximum Value:9.223372036854776E18
Normal format -
string
Minimum Length:
3
Maximum Length:64
Pattern:[0-9]+[.][0-9]+
Alternate format
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
Nested Schema : items
Type:
Show Source
object
-
lag:
integer
Minimum Value:
0
Maximum Value:9.223372036854776E18
Lag value in seconds -
threadId:
integer
Minimum Value:
0
Maximum Value:500
ID of the thread
{
"type":"object",
"properties":{
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18
},
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
}
}
}
Nested Schema : status
Match One
Show Source
{
"x-oneOf":[
{
"numThreadsWaiting":{
"description":"Number of threads in waiting status",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"processId":{
"description":"OS process id",
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"groupName":{
"description":"Process group name",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"replicatReadingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
},
"processType":{
"enum":[
"replicat"
]
},
"currentApplyParallelism":{
"description":"Current Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"numRecords":{
"description":"Total number of records",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"status":{
"description":"OGG status of the process",
"type":"string",
"minLength":1,
"maxLength":1024
},
"maxApplyParallelism":{
"description":"Maximum Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"mapParallelism":{
"description":"Map Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"logicalEof":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atTrailRBA"
]
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"sequence"
],
"additionalProperties":false
},
"numSkippedRecords":{
"description":"Number of skipped records",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"physicalEof":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atTrailRBA"
]
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"sequence"
],
"additionalProperties":false
},
"minApplyParallelism":{
"description":"Minimum Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
}
},
{
"processType":{
"enum":[
"extract"
]
},
"groupName":{
"description":"Process group name",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"processId":{
"description":"OS process id",
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"status":{
"description":"OGG status of the process",
"type":"string",
"minLength":1,
"maxLength":1024
},
"extractReadingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"dbms:positionInfo"
]
},
"position":{
"x-oneOf":[
{
"type":"object",
"properties":{
"redoThread":{
"type":"integer",
"minimum":1,
"maximum":1024
},
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
"timestamp":{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
},
"seqno":{
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"redoThread",
"csn",
"timestamp",
"seqno",
"rba"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"table":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":3,
"maxLength":261
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":5,
"maxLength":392
}
]
}
]
},
"recordNumber":{
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"timestamp":{
"type":"string",
"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])$",
"minLength":20,
"maxLength":32
}
},
"required":[
"table",
"recordNumber",
"timestamp"
],
"additionalProperties":false
}
]
}
}
}
]
},
"minItems":1,
"maxItems":32767
},
"extractWritingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
}
}
]
}
Example Response (application/json)
{
"$schema":"api:standardResponse",
"links":[
{
"href":"http://localhost:11001/services/v2/replicats/REP2/command",
"mediaType":"application/json",
"rel":"canonical"
},
{
"href":"http://localhost:11001/services/v2/replicats/REP2/command",
"mediaType":"application/json",
"rel":"self"
}
],
"messages":[
],
"response":{
"$schema":"er:commandResult",
"reply":"OKNODOT\t\nStart of Statistics at 2017-12-14 12:44:44.\n\nReplicating from OGGADMIN.GG_HEARTBEAT_SEED to OGGADMIN.GG_HEARTBEAT:\n\n*** Hourly statistics since 2017-12-14 12:44:01 ***\n\tTotal inserts \t 0.00\n\tTotal updates \t 1.00\n\tTotal deletes \t 0.00\n\tTotal discards \t 0.00\n\tTotal operations \t 1.00\n\nReplicating from OGGADMIN.GG_HEARTBEAT_SEED to OGGADMIN.GG_HEARTBEAT_HISTORY:\n\n*** Hourly statistics since 2017-12-14 12:44:01 ***\n\tTotal inserts \t 0.00\n\tTotal updates \t 1.00\n\tTotal deletes \t 0.00\n\tTotal discards \t 0.00\n\tTotal operations \t 1.00\n\nEnd of Statistics.",
"replyData":{
"$schema":"ogg:stats",
"stats":[
{
"operations":[
{
"count":0,
"operation":"insert"
},
{
"count":1,
"operation":"update"
},
{
"count":0,
"operation":"delete"
},
{
"count":0,
"operation":"discard"
},
{
"count":1,
"operation":"operations"
}
],
"since":"2017-12-14T12:44:01.394Z",
"sourceTable":"OGGADMIN.GG_HEARTBEAT_SEED",
"targetTable":"OGGADMIN.GG_HEARTBEAT"
},
{
"operations":[
{
"count":0,
"operation":"insert"
},
{
"count":1,
"operation":"update"
},
{
"count":0,
"operation":"delete"
},
{
"count":0,
"operation":"discard"
},
{
"count":1,
"operation":"operations"
}
],
"since":"2017-12-14T12:44:01.394Z",
"sourceTable":"OGGADMIN.GG_HEARTBEAT_SEED",
"targetTable":"OGGADMIN.GG_HEARTBEAT_HISTORY"
}
]
}
}
}