- Oracle GoldenGate
- タスク
- Administrative Server
- Extracts
post
/services/{version}/extracts/{extract}/command
Extractプロセス・コマンドを実行します
リクエスト
サポートされるメディア・タイプ
- application/json
パス・パラメータ
- extract: string
最小長:
1最大長:8パターン:^[A-Z_$][A-Z0-9_$]*$Extractの名前。Extract名は大文字で、先頭が英字、その後に英数字が最大で7文字続きます。
- version: string
Oracle GoldenGateサービスのAPIバージョン。
指定できる値:[ "v2" ]
本文()
ルート・スキーマ: Describes a command for an ER process to execute
タイトル:
Describes a command for an ER process to execute1つに一致
ソースの表示
- object Describes a command for an ER process to execute-x-oneOf[0]
- object Describes a command for an ER process to execute-x-oneOf[1]
- object Describes a command for an ER process to execute-x-oneOf[2]
- object Describes a command for an ER process to execute-x-oneOf[3]
{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:command"
]
},
"command":{
"enum":[
"FORCESTOP",
"GETLAG",
"GETTCPSTATS",
"LOGEND",
"LOGSTATS",
"REPORT",
"RESETTCPSTATS",
"RESUME",
"ROLLOVER",
"STATUS",
"STOP"
]
}
},
"required":[
"command"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:command"
]
},
"command":{
"enum":[
"BR",
"CACHEMGR",
"DEPINFO",
"DEPENDENCYINFO",
"FORCETRANS",
"GETPARAMINFO",
"HANDLECOLLISIONS",
"NOHANDLECOLLISIONS",
"PROBE",
"RTC",
"SHOWTRANS",
"SKIPTRANS",
"STATS",
"TRACE",
"TRACE2",
"TRACEINIT",
"TRANLOGOPTIONS"
]
},
"arguments":{
"type":"string",
"minLength":1,
"maxLength":4095
}
},
"required":[
"command"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:command"
]
},
"command":{
"type":"string",
"pattern":"^(INTEGRATEDPARAMS)[ ]*[(].*[)]$",
"minLength":1,
"maxLength":4095
}
},
"required":[
"command"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:command"
]
},
"command":{
"enum":[
"INFO"
]
},
"arguments":{
"type":"string",
"minLength":1,
"maxLength":4095
},
"credentials":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:credentialsRef"
]
},
"domain":{
"type":"string",
"pattern":"^[a-zA-Z][a-zA-Z0-9_#$]*$",
"minLength":1,
"maxLength":30,
"default":"OracleGoldenGate"
},
"alias":{
"type":"string",
"pattern":"^[a-zA-Z][a-zA-Z0-9_#$]*$",
"minLength":1,
"maxLength":30
}
},
"required":[
"alias"
],
"additionalProperties":false
}
},
"required":[
"command"
],
"additionalProperties":false
}
],
"title":"Describes a command for an ER process to execute"
}ネストされたスキーマ: Describes a command for an ER process to execute-x-oneOf[0]
型:
ソースの表示
object- $schema:
指定できる値:
[ "er:command" ] - command:
指定できる値:
[ "FORCESTOP", "GETLAG", "GETTCPSTATS", "LOGEND", "LOGSTATS", "REPORT", "RESETTCPSTATS", "RESUME", "ROLLOVER", "STATUS", "STOP" ]
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:command"
]
},
"command":{
"enum":[
"FORCESTOP",
"GETLAG",
"GETTCPSTATS",
"LOGEND",
"LOGSTATS",
"REPORT",
"RESETTCPSTATS",
"RESUME",
"ROLLOVER",
"STATUS",
"STOP"
]
}
},
"required":[
"command"
],
"additionalProperties":false
}ネストされたスキーマ: Describes a command for an ER process to execute-x-oneOf[1]
型:
ソースの表示
object- $schema:
指定できる値:
[ "er:command" ] - arguments: string
最小長:
1最大長:4095 - command:
指定できる値:
[ "BR", "CACHEMGR", "DEPINFO", "DEPENDENCYINFO", "FORCETRANS", "GETPARAMINFO", "HANDLECOLLISIONS", "NOHANDLECOLLISIONS", "PROBE", "RTC", "SHOWTRANS", "SKIPTRANS", "STATS", "TRACE", "TRACE2", "TRACEINIT", "TRANLOGOPTIONS" ]
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:command"
]
},
"command":{
"enum":[
"BR",
"CACHEMGR",
"DEPINFO",
"DEPENDENCYINFO",
"FORCETRANS",
"GETPARAMINFO",
"HANDLECOLLISIONS",
"NOHANDLECOLLISIONS",
"PROBE",
"RTC",
"SHOWTRANS",
"SKIPTRANS",
"STATS",
"TRACE",
"TRACE2",
"TRACEINIT",
"TRANLOGOPTIONS"
]
},
"arguments":{
"type":"string",
"minLength":1,
"maxLength":4095
}
},
"required":[
"command"
],
"additionalProperties":false
}ネストされたスキーマ: Describes a command for an ER process to execute-x-oneOf[2]
型:
ソースの表示
object- $schema:
指定できる値:
[ "er:command" ] - command: string
最小長:
1最大長:4095パターン:^(INTEGRATEDPARAMS)[ ]*[(].*[)]$
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:command"
]
},
"command":{
"type":"string",
"pattern":"^(INTEGRATEDPARAMS)[ ]*[(].*[)]$",
"minLength":1,
"maxLength":4095
}
},
"required":[
"command"
],
"additionalProperties":false
}ネストされたスキーマ: Describes a command for an ER process to execute-x-oneOf[3]
型:
ソースの表示
object- $schema:
指定できる値:
[ "er:command" ] - arguments: string
最小長:
1最大長:4095 - command:
指定できる値:
[ "INFO" ] - credentials: object credentials
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:command"
]
},
"command":{
"enum":[
"INFO"
]
},
"arguments":{
"type":"string",
"minLength":1,
"maxLength":4095
},
"credentials":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:credentialsRef"
]
},
"domain":{
"type":"string",
"pattern":"^[a-zA-Z][a-zA-Z0-9_#$]*$",
"minLength":1,
"maxLength":30,
"default":"OracleGoldenGate"
},
"alias":{
"type":"string",
"pattern":"^[a-zA-Z][a-zA-Z0-9_#$]*$",
"minLength":1,
"maxLength":30
}
},
"required":[
"alias"
],
"additionalProperties":false
}
},
"required":[
"command"
],
"additionalProperties":false
}ネストされたスキーマ: credentials
型:
ソースの表示
object- $schema:
指定できる値:
[ "ogg:credentialsRef" ] - alias: string
最小長:
1最大長:30パターン:^[a-zA-Z][a-zA-Z0-9_#$]*$ - domain: string
最小長:
1最大長:30デフォルト値:OracleGoldenGateパターン:^[a-zA-Z][a-zA-Z0-9_#$]*$
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:credentialsRef"
]
},
"domain":{
"type":"string",
"pattern":"^[a-zA-Z][a-zA-Z0-9_#$]*$",
"minLength":1,
"maxLength":30,
"default":"OracleGoldenGate"
},
"alias":{
"type":"string",
"pattern":"^[a-zA-Z][a-zA-Z0-9_#$]*$",
"minLength":1,
"maxLength":30
}
},
"required":[
"alias"
],
"additionalProperties":false
}リクエストの例(application/json)
{
"command":"STATS",
"arguments":"HOURLY"
}レスポンス
サポートされるメディア・タイプ
- application/json
200レスポンス
コマンドが正常に実行されました。
本文()
ルート・スキーマ: Describes the results from an ER process executing a command
型:
objectタイトル:
ソースの表示
Describes the results from an ER process executing a command- $schema:
指定できる値:
[ "er:commandResult" ] - reply: reply
- replyData: replyData
{
"title":"Describes the results from an ER process executing a command",
"required":[
"reply"
],
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:commandResult"
]
},
"reply":{
"x-oneOf":[
{
"type":"string",
"minLength":0,
"maxLength":29996
},
{
"type":"array",
"items":{
"type":"string",
"minLength":0,
"maxLength":4095
},
"minItems":0,
"maxItems":32767
}
]
},
"replyData":{
"x-anyOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:getLagResult"
]
},
"lagResult":{
"x-oneOf":[
{
"type":"object",
"properties":{
"lastRecordLag":{
"description":"Last record lag in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"lowWatermarkLag":{
"description":"Low watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"highWatermarkLag":{
"description":"High watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"eof":{
"description":"Whether the process is at EOF",
"type":"boolean"
},
"redoxportlag":{
"type":"array",
"items":{
"type":"object",
"properties":{
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18
},
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
}
}
},
"minItems":1,
"maxItems":500
},
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"deferApplyDelay":{
"description":"Defer apply delay in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"lowWatermarkPosition":{
"description":"Low watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
},
"extdetail":{
"type":"object",
"properties":{
"downstream":{
"description":"Indicates if downstream is configured",
"type":"boolean"
},
"conntosrcdb":{
"description":"Indicates if conn to src db exists",
"type":"boolean"
},
"orlcount":{
"description":"Number of ORLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"maxorlsize":{
"description":"Maximum size of ORL",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"srlcount":{
"description":"Number of SRLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"minsrlsize":{
"description":"Minimum size of SRL",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
}
},
"highWatermarkPosition":{
"description":"High watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
}
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
},
{
"threads":{
"type":"array",
"items":{
"type":"object",
"properties":{
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"minItems":1,
"maxItems":500
},
"minLag":{
"description":"Minimum thread lag value information",
"type":"object",
"properties":{
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"maxLag":{
"description":"Maximum thread lag value information",
"type":"object",
"properties":{
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"avgLag":{
"description":"Average lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
}
]
}
},
"required":[
"lagResult"
]
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:logEndResult"
]
},
"allRecordsProcessed":{
"description":"Whether or not Extract has processed all of the records in the data source.",
"type":"boolean"
}
},
"required":[
"allRecordsProcessed"
]
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:statusResult"
]
},
"status":{
"x-oneOf":[
{
"numThreadsWaiting":{
"description":"Number of threads in waiting status",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"processId":{
"description":"OS process id",
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"groupName":{
"description":"Process group name",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"replicatReadingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
},
"processType":{
"enum":[
"replicat"
]
},
"currentApplyParallelism":{
"description":"Current Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"numRecords":{
"description":"Total number of records",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"status":{
"description":"OGG status of the process",
"type":"string",
"minLength":1,
"maxLength":1024
},
"maxApplyParallelism":{
"description":"Maximum Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"mapParallelism":{
"description":"Map Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"logicalEof":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atTrailRBA"
]
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"sequence"
],
"additionalProperties":false
},
"numSkippedRecords":{
"description":"Number of skipped records",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"physicalEof":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atTrailRBA"
]
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"sequence"
],
"additionalProperties":false
},
"minApplyParallelism":{
"description":"Minimum Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
}
},
{
"processType":{
"enum":[
"extract"
]
},
"groupName":{
"description":"Process group name",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"processId":{
"description":"OS process id",
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"status":{
"description":"OGG status of the process",
"type":"string",
"minLength":1,
"maxLength":1024
},
"extractReadingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"dbms:positionInfo"
]
},
"position":{
"x-oneOf":[
{
"type":"object",
"properties":{
"redoThread":{
"type":"integer",
"minimum":1,
"maximum":1024
},
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
"timestamp":{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
"seqno":{
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"redoThread",
"csn",
"timestamp",
"seqno",
"rba"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"table":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":3,
"maxLength":261
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":5,
"maxLength":392
}
]
}
]
},
"recordNumber":{
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"timestamp":{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
}
},
"required":[
"table",
"recordNumber",
"timestamp"
],
"additionalProperties":false
}
]
}
}
}
]
},
"minItems":1,
"maxItems":32767
},
"extractWritingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
}
}
]
}
}
},
{
"type":"object"
}
]
}
}
}ネストされたスキーマ: reply
1つに一致
ソースの表示
- string
最小長:
0最大長:29996 - array reply-x-oneOf[1]
最小アイテム数:
0最大アイテム数:32767
{
"x-oneOf":[
{
"type":"string",
"minLength":0,
"maxLength":29996
},
{
"type":"array",
"items":{
"type":"string",
"minLength":0,
"maxLength":4095
},
"minItems":0,
"maxItems":32767
}
]
}ネストされたスキーマ: replyData
いずれかに一致
ソースの表示
- object replyData-x-anyOf[0]
- object replyData-x-anyOf[1]
- object replyData-x-anyOf[2]
- object replyData-x-anyOf[3]
{
"x-anyOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:getLagResult"
]
},
"lagResult":{
"x-oneOf":[
{
"type":"object",
"properties":{
"lastRecordLag":{
"description":"Last record lag in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"lowWatermarkLag":{
"description":"Low watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"highWatermarkLag":{
"description":"High watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"eof":{
"description":"Whether the process is at EOF",
"type":"boolean"
},
"redoxportlag":{
"type":"array",
"items":{
"type":"object",
"properties":{
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18
},
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
}
}
},
"minItems":1,
"maxItems":500
},
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"deferApplyDelay":{
"description":"Defer apply delay in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"lowWatermarkPosition":{
"description":"Low watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
},
"extdetail":{
"type":"object",
"properties":{
"downstream":{
"description":"Indicates if downstream is configured",
"type":"boolean"
},
"conntosrcdb":{
"description":"Indicates if conn to src db exists",
"type":"boolean"
},
"orlcount":{
"description":"Number of ORLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"maxorlsize":{
"description":"Maximum size of ORL",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"srlcount":{
"description":"Number of SRLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"minsrlsize":{
"description":"Minimum size of SRL",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
}
},
"highWatermarkPosition":{
"description":"High watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
}
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
},
{
"threads":{
"type":"array",
"items":{
"type":"object",
"properties":{
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"minItems":1,
"maxItems":500
},
"minLag":{
"description":"Minimum thread lag value information",
"type":"object",
"properties":{
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"maxLag":{
"description":"Maximum thread lag value information",
"type":"object",
"properties":{
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"avgLag":{
"description":"Average lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
}
]
}
},
"required":[
"lagResult"
]
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:logEndResult"
]
},
"allRecordsProcessed":{
"description":"Whether or not Extract has processed all of the records in the data source.",
"type":"boolean"
}
},
"required":[
"allRecordsProcessed"
]
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:statusResult"
]
},
"status":{
"x-oneOf":[
{
"numThreadsWaiting":{
"description":"Number of threads in waiting status",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"processId":{
"description":"OS process id",
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"groupName":{
"description":"Process group name",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"replicatReadingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
},
"processType":{
"enum":[
"replicat"
]
},
"currentApplyParallelism":{
"description":"Current Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"numRecords":{
"description":"Total number of records",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"status":{
"description":"OGG status of the process",
"type":"string",
"minLength":1,
"maxLength":1024
},
"maxApplyParallelism":{
"description":"Maximum Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"mapParallelism":{
"description":"Map Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"logicalEof":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atTrailRBA"
]
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"sequence"
],
"additionalProperties":false
},
"numSkippedRecords":{
"description":"Number of skipped records",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"physicalEof":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atTrailRBA"
]
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"sequence"
],
"additionalProperties":false
},
"minApplyParallelism":{
"description":"Minimum Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
}
},
{
"processType":{
"enum":[
"extract"
]
},
"groupName":{
"description":"Process group name",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"processId":{
"description":"OS process id",
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"status":{
"description":"OGG status of the process",
"type":"string",
"minLength":1,
"maxLength":1024
},
"extractReadingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"dbms:positionInfo"
]
},
"position":{
"x-oneOf":[
{
"type":"object",
"properties":{
"redoThread":{
"type":"integer",
"minimum":1,
"maximum":1024
},
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
"timestamp":{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
"seqno":{
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"redoThread",
"csn",
"timestamp",
"seqno",
"rba"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"table":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":3,
"maxLength":261
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":5,
"maxLength":392
}
]
}
]
},
"recordNumber":{
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"timestamp":{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
}
},
"required":[
"table",
"recordNumber",
"timestamp"
],
"additionalProperties":false
}
]
}
}
}
]
},
"minItems":1,
"maxItems":32767
},
"extractWritingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
}
}
]
}
}
},
{
"type":"object"
}
]
}ネストされたスキーマ: reply-x-oneOf[1]
型:
array最小アイテム数:
0最大アイテム数:
ソースの表示
32767- [0]: string
最小長:
0最大長:4095
{
"type":"array",
"items":{
"type":"string",
"minLength":0,
"maxLength":4095
},
"minItems":0,
"maxItems":32767
}ネストされたスキーマ: replyData-x-anyOf[0]
型:
ソースの表示
object- $schema:
指定できる値:
[ "er:getLagResult" ] - lagResult: lagResult
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:getLagResult"
]
},
"lagResult":{
"x-oneOf":[
{
"type":"object",
"properties":{
"lastRecordLag":{
"description":"Last record lag in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"lowWatermarkLag":{
"description":"Low watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"highWatermarkLag":{
"description":"High watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"eof":{
"description":"Whether the process is at EOF",
"type":"boolean"
},
"redoxportlag":{
"type":"array",
"items":{
"type":"object",
"properties":{
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18
},
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
}
}
},
"minItems":1,
"maxItems":500
},
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"deferApplyDelay":{
"description":"Defer apply delay in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"lowWatermarkPosition":{
"description":"Low watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
},
"extdetail":{
"type":"object",
"properties":{
"downstream":{
"description":"Indicates if downstream is configured",
"type":"boolean"
},
"conntosrcdb":{
"description":"Indicates if conn to src db exists",
"type":"boolean"
},
"orlcount":{
"description":"Number of ORLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"maxorlsize":{
"description":"Maximum size of ORL",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"srlcount":{
"description":"Number of SRLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"minsrlsize":{
"description":"Minimum size of SRL",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
}
},
"highWatermarkPosition":{
"description":"High watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
}
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
},
{
"threads":{
"type":"array",
"items":{
"type":"object",
"properties":{
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"minItems":1,
"maxItems":500
},
"minLag":{
"description":"Minimum thread lag value information",
"type":"object",
"properties":{
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"maxLag":{
"description":"Maximum thread lag value information",
"type":"object",
"properties":{
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"avgLag":{
"description":"Average lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
}
]
}
},
"required":[
"lagResult"
]
}ネストされたスキーマ: replyData-x-anyOf[1]
型:
ソースの表示
object- $schema:
指定できる値:
[ "er:logEndResult" ] - allRecordsProcessed: boolean
Extractがデータ・ソース内のすべてのレコードを処理したかどうか。
{
"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"
]
}ネストされたスキーマ: replyData-x-anyOf[2]
型:
ソースの表示
object{
"type":"object",
"properties":{
"$schema":{
"enum":[
"er:statusResult"
]
},
"status":{
"x-oneOf":[
{
"numThreadsWaiting":{
"description":"Number of threads in waiting status",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"processId":{
"description":"OS process id",
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"groupName":{
"description":"Process group name",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"replicatReadingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
},
"processType":{
"enum":[
"replicat"
]
},
"currentApplyParallelism":{
"description":"Current Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"numRecords":{
"description":"Total number of records",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"status":{
"description":"OGG status of the process",
"type":"string",
"minLength":1,
"maxLength":1024
},
"maxApplyParallelism":{
"description":"Maximum Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"mapParallelism":{
"description":"Map Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"logicalEof":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atTrailRBA"
]
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"sequence"
],
"additionalProperties":false
},
"numSkippedRecords":{
"description":"Number of skipped records",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"physicalEof":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atTrailRBA"
]
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"sequence"
],
"additionalProperties":false
},
"minApplyParallelism":{
"description":"Minimum Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
}
},
{
"processType":{
"enum":[
"extract"
]
},
"groupName":{
"description":"Process group name",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"processId":{
"description":"OS process id",
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"status":{
"description":"OGG status of the process",
"type":"string",
"minLength":1,
"maxLength":1024
},
"extractReadingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"dbms:positionInfo"
]
},
"position":{
"x-oneOf":[
{
"type":"object",
"properties":{
"redoThread":{
"type":"integer",
"minimum":1,
"maximum":1024
},
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
"timestamp":{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
"seqno":{
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"redoThread",
"csn",
"timestamp",
"seqno",
"rba"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"table":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":3,
"maxLength":261
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":5,
"maxLength":392
}
]
}
]
},
"recordNumber":{
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"timestamp":{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
}
},
"required":[
"table",
"recordNumber",
"timestamp"
],
"additionalProperties":false
}
]
}
}
}
]
},
"minItems":1,
"maxItems":32767
},
"extractWritingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
}
}
]
}
}
}ネストされたスキーマ: replyData-x-anyOf[3]
型:
objectネストされたスキーマ: lagResult
1つに一致
ソースの表示
{
"x-oneOf":[
{
"type":"object",
"properties":{
"lastRecordLag":{
"description":"Last record lag in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"lowWatermarkLag":{
"description":"Low watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"highWatermarkLag":{
"description":"High watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"eof":{
"description":"Whether the process is at EOF",
"type":"boolean"
},
"redoxportlag":{
"type":"array",
"items":{
"type":"object",
"properties":{
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18
},
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
}
}
},
"minItems":1,
"maxItems":500
},
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"deferApplyDelay":{
"description":"Defer apply delay in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"lowWatermarkPosition":{
"description":"Low watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
},
"extdetail":{
"type":"object",
"properties":{
"downstream":{
"description":"Indicates if downstream is configured",
"type":"boolean"
},
"conntosrcdb":{
"description":"Indicates if conn to src db exists",
"type":"boolean"
},
"orlcount":{
"description":"Number of ORLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"maxorlsize":{
"description":"Maximum size of ORL",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"srlcount":{
"description":"Number of SRLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"minsrlsize":{
"description":"Minimum size of SRL",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
}
},
"highWatermarkPosition":{
"description":"High watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
}
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
},
{
"threads":{
"type":"array",
"items":{
"type":"object",
"properties":{
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"minItems":1,
"maxItems":500
},
"minLag":{
"description":"Minimum thread lag value information",
"type":"object",
"properties":{
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"maxLag":{
"description":"Maximum thread lag value information",
"type":"object",
"properties":{
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
},
"threadName":{
"description":"Name of the thread",
"type":"string",
"minLength":1,
"maxLength":128
},
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
}
}
},
"avgLag":{
"description":"Average lag value in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
}
]
}ネストされたスキーマ: lagResult-x-oneOf[0]
型:
ソースの表示
object- deferApplyDelay: integer
最小値:
1最大値:2147483647遅延適用の延長(秒) - eof: boolean
プロセスがEOFに到達しているかどうか
- extdetail: object extdetail
- highWatermarkLag: integer
最小値:
1最大値:2147483647高水位標ラグ(秒) - highWatermarkPosition: highWatermarkPosition
高水位標位置
- lastRecordLag: integer
最小値:
1最大値:9.223372036854776E18最終レコード・ラグ(秒) - lowWatermarkLag: integer
最小値:
1最大値:2147483647低水位標ラグ(秒) - lowWatermarkPosition: lowWatermarkPosition
低水位標位置
- recordsProcessed: boolean
まだ処理されていないレコードがあるかどうか
- redoxportlag: array redoxportlag
最小アイテム数:
1最大アイテム数:500
{
"type":"object",
"properties":{
"lastRecordLag":{
"description":"Last record lag in seconds",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"lowWatermarkLag":{
"description":"Low watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"highWatermarkLag":{
"description":"High watermark lag in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"eof":{
"description":"Whether the process is at EOF",
"type":"boolean"
},
"redoxportlag":{
"type":"array",
"items":{
"type":"object",
"properties":{
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18
},
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
}
}
},
"minItems":1,
"maxItems":500
},
"recordsProcessed":{
"description":"Whether there are any records processed yet",
"type":"boolean"
},
"deferApplyDelay":{
"description":"Defer apply delay in seconds",
"type":"integer",
"minimum":1,
"maximum":2147483647
},
"lowWatermarkPosition":{
"description":"Low watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
},
"extdetail":{
"type":"object",
"properties":{
"downstream":{
"description":"Indicates if downstream is configured",
"type":"boolean"
},
"conntosrcdb":{
"description":"Indicates if conn to src db exists",
"type":"boolean"
},
"orlcount":{
"description":"Number of ORLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"maxorlsize":{
"description":"Maximum size of ORL",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"srlcount":{
"description":"Number of SRLs",
"type":"integer",
"minimum":0,
"maximum":2147483647
},
"minsrlsize":{
"description":"Minimum size of SRL",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
}
},
"highWatermarkPosition":{
"description":"High watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
}
},
"required":[
"recordsProcessed"
],
"allowAdditionalProperties":false
}ネストされたスキーマ: extdetail
型:
ソースの表示
object- conntosrcdb: boolean
ソース・データベースへの接続が存在するかどうかを示します
- downstream: boolean
ダウンストリームが構成されているかどうかを示します
- maxorlsize: integer
最小値:
0最大値:2147483647ORLの最大サイズ - minsrlsize: integer
最小値:
0最大値:2147483647SRLの最小サイズ - orlcount: integer
最小値:
0最大値:2147483647ORL数 - srlcount: integer
最小値:
0最大値:2147483647SRL数
{
"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
高水位標位置
1つに一致
ソースの表示
- object highWatermarkPosition-x-oneOf[0]
アーカイブ・ログでの位置(クラシック・モード、非スレッド)
- object highWatermarkPosition-x-oneOf[1]
アーカイブ・ログでの位置(クラシック・モード、スレッド)
- object highWatermarkPosition-x-oneOf[2]
特定のSCNの位置(統合モード)
{
"description":"High watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
}ネストされたスキーマ: lowWatermarkPosition
低水位標位置
1つに一致
ソースの表示
- object lowWatermarkPosition-x-oneOf[0]
アーカイブ・ログでの位置(クラシック・モード、非スレッド)
- object lowWatermarkPosition-x-oneOf[1]
アーカイブ・ログでの位置(クラシック・モード、スレッド)
- object lowWatermarkPosition-x-oneOf[2]
特定のSCNの位置(統合モード)
{
"description":"Low watermark position",
"x-oneOf":[
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
},
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
},
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
]
}ネストされたスキーマ: redoxportlag
型:
array最小アイテム数:
1最大アイテム数:
ソースの表示
500{
"type":"array",
"items":{
"type":"object",
"properties":{
"lag":{
"description":"Lag value in seconds",
"type":"integer",
"minimum":0,
"maximum":9.223372036854776E18
},
"threadId":{
"description":"ID of the thread",
"type":"integer",
"minimum":0,
"maximum":500
}
}
},
"minItems":1,
"maxItems":500
}ネストされたスキーマ: highWatermarkPosition-x-oneOf[0]
型:
objectアーカイブ・ログでの位置(クラシック・モード、非スレッド)
ソースの表示
- rba: integer
最小値:
0最大値:2147483647デフォルト値:0 - seqno: integer
最小値:
1最大値:4.294967295E9デフォルト値:1
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}いずれかに一致
ソースの表示
{
"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"
]
}
]
}ネストされたスキーマ: highWatermarkPosition-x-oneOf[1]
型:
objectアーカイブ・ログでの位置(クラシック・モード、スレッド)
ソースの表示
- positions: array positions
最小アイテム数:
1最大アイテム数:100
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
}ネストされたスキーマ: highWatermarkPosition-x-oneOf[2]
型:
object特定のSCNの位置(統合モード)
ソースの表示
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}ネストされたスキーマ: positions
型:
array最小アイテム数:
1最大アイテム数:
ソースの表示
100- [0]: object items
アーカイブ・ログでの位置(クラシックExtractの1スレッド)
{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}ネストされたスキーマ: items
型:
objectアーカイブ・ログでの位置(クラシックExtractの1スレッド)
ソースの表示
- position: position
- thread: integer
最小値:
1最大値:100
{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
}ネストされたスキーマ: position
1つに一致
ソースの表示
-
指定できる値:
[ "now" ] - position-x-oneOf[1]
- string
最小長:
20最大長:32パターン:^[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]
アーカイブ・ログでの位置(クラシック・モード、非スレッド)
{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}ネストされたスキーマ: position-x-oneOf[1]
1つに一致
ソースの表示
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}ネストされたスキーマ: position-x-oneOf[3]
型:
objectアーカイブ・ログでの位置(クラシック・モード、非スレッド)
ソースの表示
- rba: integer
最小値:
0最大値:2147483647デフォルト値:0 - seqno: integer
最小値:
1最大値:4.294967295E9デフォルト値:1
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}いずれかに一致
ソースの表示
{
"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"
]
}
]
}ネストされたスキーマ: csn
1つに一致
ソースの表示
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}ネストされたスキーマ: lowWatermarkPosition-x-oneOf[0]
型:
objectアーカイブ・ログでの位置(クラシック・モード、非スレッド)
ソースの表示
- rba: integer
最小値:
0最大値:2147483647デフォルト値:0 - seqno: integer
最小値:
1最大値:4.294967295E9デフォルト値:1
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}いずれかに一致
ソースの表示
{
"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"
]
}
]
}ネストされたスキーマ: lowWatermarkPosition-x-oneOf[1]
型:
objectアーカイブ・ログでの位置(クラシック・モード、スレッド)
ソースの表示
- positions: array positions
最小アイテム数:
1最大アイテム数:100
{
"description":"Position in archive logs (classic mode, threaded)",
"type":"object",
"properties":{
"positions":{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}
},
"required":[
"positions"
],
"additionalProperties":false
}ネストされたスキーマ: lowWatermarkPosition-x-oneOf[2]
型:
object特定のSCNの位置(統合モード)
ソースの表示
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}ネストされたスキーマ: positions
型:
array最小アイテム数:
1最大アイテム数:
ソースの表示
100- [0]: object items
アーカイブ・ログでの位置(クラシックExtractの1スレッド)
{
"type":"array",
"items":{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":100
}ネストされたスキーマ: items
型:
objectアーカイブ・ログでの位置(クラシックExtractの1スレッド)
ソースの表示
- position: position
- thread: integer
最小値:
1最大値:100
{
"description":"Position in archive logs for one thread in a classic extract",
"type":"object",
"properties":{
"thread":{
"type":"integer",
"minimum":1,
"maximum":100
},
"position":{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}
},
"required":[
"thread",
"position"
],
"additionalProperties":false
}ネストされたスキーマ: position
1つに一致
ソースの表示
-
指定できる値:
[ "now" ] - position-x-oneOf[1]
- string
最小長:
20最大長:32パターン:^[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]
アーカイブ・ログでの位置(クラシック・モード、非スレッド)
{
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}
]
}ネストされたスキーマ: position-x-oneOf[1]
1つに一致
ソースの表示
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}ネストされたスキーマ: position-x-oneOf[3]
型:
objectアーカイブ・ログでの位置(クラシック・モード、非スレッド)
ソースの表示
- rba: integer
最小値:
0最大値:2147483647デフォルト値:0 - seqno: integer
最小値:
1最大値:4.294967295E9デフォルト値:1
{
"description":"Position in archive logs (classic mode, non-threaded)",
"type":"object",
"properties":{
"seqno":{
"type":"integer",
"default":1,
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"default":0,
"minimum":0,
"maximum":2147483647
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"seqno"
]
},
{
"required":[
"rba"
]
}
]
}いずれかに一致
ソースの表示
{
"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"
]
}
]
}ネストされたスキーマ: csn
1つに一致
ソースの表示
{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
}ネストされたスキーマ: items
型:
ソースの表示
object- lag: integer
最小値:
0最大値:9.223372036854776E18ラグ値(秒) - threadId: integer
最小値:
0最大値:500スレッドのID
{
"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
}
}
}ネストされたスキーマ: status
1つに一致
ソースの表示
{
"x-oneOf":[
{
"numThreadsWaiting":{
"description":"Number of threads in waiting status",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"processId":{
"description":"OS process id",
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"groupName":{
"description":"Process group name",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"replicatReadingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
},
"processType":{
"enum":[
"replicat"
]
},
"currentApplyParallelism":{
"description":"Current Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"numRecords":{
"description":"Total number of records",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"status":{
"description":"OGG status of the process",
"type":"string",
"minLength":1,
"maxLength":1024
},
"maxApplyParallelism":{
"description":"Maximum Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"mapParallelism":{
"description":"Map Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
},
"logicalEof":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atTrailRBA"
]
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"sequence"
],
"additionalProperties":false
},
"numSkippedRecords":{
"description":"Number of skipped records",
"type":"integer",
"minimum":0,
"maximum":4.294967295E9
},
"physicalEof":{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atTrailRBA"
]
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"sequence"
],
"additionalProperties":false
},
"minApplyParallelism":{
"description":"Minimum Apply Parallelism for a Parallel Replicat",
"type":"integer",
"minimum":1,
"maximum":100
}
},
{
"processType":{
"enum":[
"extract"
]
},
"groupName":{
"description":"Process group name",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"processId":{
"description":"OS process id",
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"status":{
"description":"OGG status of the process",
"type":"string",
"minLength":1,
"maxLength":1024
},
"extractReadingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"dbms:positionInfo"
]
},
"position":{
"x-oneOf":[
{
"type":"object",
"properties":{
"redoThread":{
"type":"integer",
"minimum":1,
"maximum":1024
},
"csn":{
"x-oneOf":[
{
"description":"Normal format",
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
{
"description":"Alternate format",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":3,
"maxLength":64
}
]
},
"timestamp":{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
},
"seqno":{
"type":"integer",
"minimum":1,
"maximum":4.294967295E9
},
"rba":{
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"redoThread",
"csn",
"timestamp",
"seqno",
"rba"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"table":{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
},
{
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":3,
"maxLength":261
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":5,
"maxLength":392
}
]
}
]
},
"recordNumber":{
"type":"integer",
"minimum":1,
"maximum":9.223372036854776E18
},
"timestamp":{
"type":"string",
"pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
"minLength":20,
"maxLength":32
}
},
"required":[
"table",
"recordNumber",
"timestamp"
],
"additionalProperties":false
}
]
}
}
}
]
},
"minItems":1,
"maxItems":32767
},
"extractWritingPosition":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:trailPosition"
]
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]?$",
"minLength":1,
"maxLength":2
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"sequence":{
"description":"Trail file sequence number",
"type":"integer",
"minimum":0,
"maximum":999999999,
"default":0
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":0,
"default":0,
"maximum":2147483647
}
},
"required":[
"name"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:filePosition"
]
},
"name":{
"description":"The name of the file",
"type":"string",
"minLength":1,
"maxLength":255
},
"path":{
"description":"The path where file data is stored",
"type":"string",
"minLength":1,
"maxLength":255
},
"offset":{
"description":"Offset in file",
"type":"integer",
"minimum":0,
"maximum":2147483647
}
},
"required":[
"name",
"path",
"offset"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":32767
}
}
]
}レスポンスの例(application/json)
{
"$schema":"api:standardResponse",
"links":[
{
"href":"http://localhost:11001/services/v2/extracts/EXT2/command",
"mediaType":"application/json",
"rel":"canonical"
},
{
"href":"http://localhost:11001/services/v2/extracts/EXT2/command",
"mediaType":"application/json",
"rel":"self"
}
],
"messages":[
],
"response":{
"$schema":"er:commandResult",
"reply":"OKNODOT\t\nStart of Statistics at 2017-12-14 12:43:48.\n\nOutput to X2:\n\nExtracting from OGGADMIN.GG_HEARTBEAT_SEED to OGGADMIN.GG_HEARTBEAT_SEED:\n\n*** Hourly statistics since 2017-12-14 12:43:10 ***\n\tTotal inserts \t 0.00\n\tTotal updates \t 1.00\n\tTotal deletes \t 0.00\n\tTotal discards \t 0.00\n\tTotal operations \t 1.00\n\nEnd of Statistics.",
"replyData":{
"$schema":"ogg:stats",
"stats":[
{
"operations":[
{
"count":0,
"operation":"insert"
},
{
"count":1,
"operation":"update"
},
{
"count":0,
"operation":"delete"
},
{
"count":0,
"operation":"discard"
},
{
"count":1,
"operation":"operations"
}
],
"since":"2017-12-14T12:43:10.000Z",
"sourceTable":"OGGADMIN.GG_HEARTBEAT_SEED",
"targetTable":"OGGADMIN.GG_HEARTBEAT_SEED"
}
]
}
}
}