Root Schema : Describes the results from an ER process executing a command
Type: object
Title: Describes the results from an ER process executing a command
Show Source
{
"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":0,
"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":0,
"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":0,
"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":0,
"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":2,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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",
"sequence",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":4096
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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
},
"activeAppliers":{
"description":"Number of current active Appliers for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"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":2,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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",
"sequence",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":4096
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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":0,
"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":2,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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",
"sequence",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":4096
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
}
}
]
}
}
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:containersResult"
]
},
"containers":{
"description":"List of containers registered with the specified extract group.",
"type":"array",
"items":{
"x-oneOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
}
]
},
"minItems":1,
"maxItems":4000
}
},
"required":[
"containers"
]
},
{
"type":"object"
}
]
}
}
}
Nested Schema : reply
Match One
Show Source
{
"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
{
"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":0,
"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":0,
"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":0,
"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":0,
"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":2,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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",
"sequence",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":4096
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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
},
"activeAppliers":{
"description":"Number of current active Appliers for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"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":2,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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",
"sequence",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":4096
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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":0,
"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":2,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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",
"sequence",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":4096
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
}
}
]
}
}
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:containersResult"
]
},
"containers":{
"description":"List of containers registered with the specified extract group.",
"type":"array",
"items":{
"x-oneOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
}
]
},
"minItems":1,
"maxItems":4000
}
},
"required":[
"containers"
]
},
{
"type":"object"
}
]
}
Nested Schema : reply-x-oneOf[1]
Type: array
Minimum Number of Items: 0
Maximum Number of Items: 32767
Show Source
{
"type":"array",
"items":{
"type":"string",
"minLength":0,
"maxLength":4095
},
"minItems":0,
"maxItems":32767
}
Nested Schema : replyData-x-anyOf[0]
Type: object
Show Source
{
"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":0,
"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":0,
"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":0,
"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":0,
"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: object
Show 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: object
Show Source
{
"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":2,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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",
"sequence",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":4096
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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
},
"activeAppliers":{
"description":"Number of current active Appliers for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"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":2,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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",
"sequence",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":4096
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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":0,
"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":2,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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",
"sequence",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":4096
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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
Show Source
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:containersResult"
]
},
"containers":{
"description":"List of containers registered with the specified extract group.",
"type":"array",
"items":{
"x-oneOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
}
]
},
"minItems":1,
"maxItems":4000
}
},
"required":[
"containers"
]
}
Nested Schema : replyData-x-anyOf[4]
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":0,
"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":0,
"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":0,
"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":0,
"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: object
Show Source
{
"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":0,
"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":0,
"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":0,
"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":0,
"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: object
Show Source
{
"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
{
"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":0,
"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":0,
"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
{
"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":0,
"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":0,
"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: 500
Show Source
{
"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
{
"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
{
"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":0,
"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":0,
"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: 100
Show Source
{
"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":0,
"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
{
"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":0,
"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":0,
"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: 0
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":0,
"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
{
"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: 0
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":0,
"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
{
"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
{
"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":0,
"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":0,
"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: 100
Show Source
{
"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":0,
"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
{
"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":0,
"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":0,
"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: 0
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":0,
"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
{
"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: 0
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":0,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
Nested Schema : items
Type: object
Show Source
{
"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":2,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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",
"sequence",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":4096
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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
},
"activeAppliers":{
"description":"Number of current active Appliers for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"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":2,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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",
"sequence",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":4096
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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":0,
"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":2,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"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",
"sequence",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":4096
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":4096
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
}
}
]
}
Nested Schema : containers
Type: array
Minimum Number of Items: 1
Maximum Number of Items: 4000
List of containers registered with the specified extract group.
Show Source
{
"description":"List of containers registered with the specified extract group.",
"type":"array",
"items":{
"x-oneOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
}
]
},
"minItems":1,
"maxItems":4000
}
Nested Schema : items
Match One
Show Source
-
string
Minimum Length: 1
Maximum Length: 130
Pattern: ^([^.*?"]{1,128}|["].{1,128}["])$
{
"x-oneOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
}
]
}