ルート・スキーマ: Oracle GoldenGate Extract
型: object
タイトル: Oracle GoldenGate Extract
ソースの表示
- $schema:
指定できる値: [ "ogg:extract" ]
- alias: object alias
- begin: begin
- config: array config
最小アイテム数: 0
最大アイテム数: 32767
- credentials: credentials
- critical: boolean
デフォルト値: false
Extractがデプロイメントにとってクリティカルであることを示します
- description: string
- encryptionProfile: encryptionProfile
- intent:
デフォルト値: Unidirectional
指定できる値: [ "High Availability", "Disaster Recovery", "Unidirectional", "N-Way", "Sharding" ]
データ取得ワークフローの目的
- managedProcessSettings: managedProcessSettings
Administration ServerでERプロセスが管理される方法を制御します
- miningCredentials: miningCredentials
ダウンストリーム・マイニング・データベースの資格証明
- passive: boolean
デフォルト値: false
ターゲット上で別名によって制御されるパッシブExtract
- registration: registration
- rollover:
指定できる値: [ true ]
Extractの再起動時に、次の順序のトレイル・ファイルに切り替えさせます。
- source: source
- status:
デフォルト値: stopped
指定できる値: [ "starting", "running", "stopped", "killed", "abended" ]
Oracle GoldenGateプロセスのステータス
- targets: array targets
最小アイテム数: 0
最大アイテム数: 1024
取得されるデータのターゲット
- type:
指定できる値: [ "Alias", "Classic", "Initial Load", "Integrated", "Passive", "Remote Task", "Source Extract" ]
OGG Extractプロセス・タイプ(読取り専用)
{
"title":"Oracle GoldenGate Extract",
"type":"object",
"properties":{
"begin":{
"description":"Starting point for data processing",
"default":"now",
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"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"
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atDbms"
]
},
"at":{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"System Change Number(Normal Format) for Oracle Database.",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000",
"example":"6488359"
},
{
"description":"System Change Number(Alternate Format) for Oracle Database.",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":"3",
"maxLength":"64",
"example":"6488359.3456712"
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
},
"required":[
"at"
],
"additionalProperties":false
}
]
},
"passive":{
"description":"Passive extract controlled by an alias on the target",
"type":"boolean",
"default":false
},
"config":{
"type":"array",
"items":{
"type":"string",
"minLength":"0",
"maxLength":"4095"
},
"minItems":"0",
"maxItems":"32767"
},
"encryptionProfile":{
"x-oneOf":[
{
"description":"Name of 'ogg:encryptionProfile' configuration value",
"type":"string",
"pattern":"^[A-Za-z0-9][A-Za-z0-9_:-]*$",
"minLength":"1",
"maxLength":"64"
},
{
"type":"null"
}
]
},
"$schema":{
"enum":[
"ogg:extract"
]
},
"status":{
"description":"Oracle GoldenGate Process Status",
"default":"stopped",
"enum":[
"starting",
"running",
"stopped",
"killed",
"abended"
]
},
"critical":{
"description":"Indicates the extract is critical to the deployment",
"type":"boolean",
"default":false
},
"rollover":{
"description":"Causes Extract to increment to the next file in the trail sequence when restarting.",
"enum":[
true
]
},
"targets":{
"description":"Targets for captured data",
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"spaceUsed":{
"description":"Bytes consumed by all trail sequences",
"type":"integer",
"minimum":"0",
"maximum":"18446744073709552000"
},
"sizeMB":{
"description":"The maximum size, in megabytes, of a file in the trail.",
"type":"integer",
"default":"500",
"minimum":"1",
"maximum":"2000"
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":"0",
"maximum":"2147483647"
},
"sequenceMaxInUse":{
"description":"Maximum trail sequence number in use",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":"1",
"maxLength":"4096"
},
"remote":{
"description":"Indicates if trail is local or remote",
"type":"boolean",
"default":false
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]$",
"minLength":"2",
"maxLength":"2"
},
"sequence":{
"description":"Trail beginning sequence number",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"$schema":{
"enum":[
"ogg:trail"
]
},
"sequenceMinInUse":{
"description":"Minimum trail sequence number in use",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"sequenceLength":{
"description":"Number of digits in sequence file name",
"enum":[
"6",
"9"
],
"default":"9"
},
"sequenceMin":{
"description":"Minimum trail sequence number that exists in the deployment",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"sequenceLengthFlip":{
"description":"Indicates sequence number length will change",
"type":"boolean",
"default":false
},
"sequenceMax":{
"description":"Maximum trail sequence number that exists in the deployment",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
}
},
"required":[
"name"
],
"additionalProperties":false
}
]
},
"minItems":"0",
"maxItems":"1024"
},
"managedProcessSettings":{
"description":"Control how the ER process is managed by the Administration Server",
"x-oneOf":[
{
"description":"Custom settings",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:managedProcessSettings"
]
},
"autoStart":{
"description":"Description of how the ER process starts with Administration Server",
"type":"object",
"properties":{
"enabled":{
"description":"If set, the process is started when Administration Server starts",
"type":"boolean",
"default":false
},
"delay":{
"description":"Time to wait in seconds before starting process",
"type":"integer",
"minimum":"0",
"default":"0",
"maximum":"3600"
}
},
"required":[
"enabled"
],
"additionalProperties":false
},
"autoRestart":{
"description":"Control how the ER process is restarted by the Administration Server if it terminates",
"default":{
"enabled":false,
"onSuccess":false,
"delay":"0",
"retries":"9",
"window":"60",
"disableOnFailure":true
},
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:taskRestart"
]
},
"enabled":{
"description":"If set, the task can be restarted if it terminates.",
"type":"boolean",
"default":false
},
"onSuccess":{
"description":"If false, the task is only restarted if it fails.",
"type":"boolean",
"default":false
},
"delay":{
"description":"The amount of time, in seconds, to pause between discovering that a process has terminated abnormally and restarting the process.",
"type":"integer",
"minimum":"0",
"default":"0",
"maximum":"3600"
},
"retries":{
"description":"The maximum number of times the task should be restarted before aborting retry efforts.",
"type":"integer",
"minimum":"0",
"default":"9",
"maximum":"3600"
},
"window":{
"description":"The window of time, in seconds, during which retries are counted.",
"type":"integer",
"minimum":"0",
"default":"60",
"maximum":"604800"
},
"disableOnFailure":{
"description":"If true, the task is disabled when it fails all execution attempts in an execution window.",
"type":"boolean",
"default":true
},
"failures":{
"description":"The number of times the task failed in the current window.",
"type":"integer",
"minimum":"0",
"maximum":"3600"
}
},
"required":[
"enabled"
],
"additionalProperties":false
}
},
"additionalProperties":false
},
{
"description":"Name of 'ogg:managedProcessSettings' configuration value",
"type":"string",
"pattern":"^[A-Za-z0-9][A-Za-z0-9_:-]*$",
"minLength":"1",
"maxLength":"64"
}
]
},
"intent":{
"description":"Intent for data capture workflow",
"enum":[
"High Availability",
"Disaster Recovery",
"Unidirectional",
"N-Way",
"Sharding"
],
"default":"Unidirectional"
},
"registration":{
"description":"Registration with the source database",
"default":"none",
"x-oneOf":[
{
"x-oneOf":[
{
"description":"Integrated extract registration options",
"type":"object",
"properties":{
"containers":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
}
]
},
"minItems":"0",
"maxItems":"256"
},
"csn":{
"x-oneOf":[
{
"description":"System Change Number(Normal Format) for Oracle Database.",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000",
"example":"6488359"
},
{
"description":"System Change Number(Alternate Format) for Oracle Database.",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":"3",
"maxLength":"64",
"example":"6488359.3456712"
}
]
},
"share":{
"description":"Describe how to share the LogMiner data dictionary",
"default":false,
"x-oneOf":[
{
"type":"boolean"
},
{
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":"1",
"maxLength":"8"
}
]
},
"optimized":{
"type":"boolean",
"default":false
},
"replace":{
"description":"If true, replace existing registration details from an extract with the same name",
"type":"boolean",
"default":false
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"containers"
]
},
{
"required":[
"csn"
]
},
{
"required":[
"share"
]
},
{
"required":[
"optimized"
]
}
]
}
]
},
{
"enum":[
"none",
"default"
]
}
]
},
"source":{
"description":"Source of data to process",
"x-oneOf":[
{
"description":"Use tables (initial load)",
"enum":[
"tables"
]
},
{
"description":"Use transaction logs with change data capture",
"enum":[
"tranlogs"
]
},
{
"description":"OGG 19c Syntax NO LONGER SUPPORTED",
"type":"object",
"properties":{
"tranlogs":{
"enum":[
"integrated",
"classic"
]
}
},
"required":[
"tranlogs"
],
"additionalProperties":false
}
]
},
"type":{
"description":"OGG Extract process type (read-only)",
"enum":[
"Alias",
"Classic",
"Initial Load",
"Integrated",
"Passive",
"Remote Task",
"Source Extract"
]
},
"miningCredentials":{
"description":"Credentials for downstream mining database",
"default":null,
"x-oneOf":[
{
"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
},
{
"type":"null"
}
]
},
"alias":{
"type":"object",
"properties":{
"name":{
"description":"Name of passive extract on the source",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":"1",
"maxLength":"8"
},
"manager":{
"description":"Manager server to use",
"type":"object",
"properties":{
"host":{
"description":"Host name or IP Address",
"x-oneOf":[
{
"description":"Network host name",
"type":"string",
"pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
"minLength":"1",
"maxLength":"4095"
},
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
]
},
"port":{
"description":"IP Port number",
"type":"integer",
"minimum":"1",
"maximum":"65535"
}
},
"required":[
"host",
"port"
],
"additionalProperties":false
},
"proxy":{
"type":"object",
"properties":{
"host":{
"description":"Proxy server host name or IP address",
"x-oneOf":[
{
"description":"Network host name",
"type":"string",
"pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
"minLength":"1",
"maxLength":"4095"
},
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
]
},
"port":{
"description":"Proxy server port number",
"type":"integer",
"minimum":"1",
"maximum":"65535"
},
"credentials":{
"description":"Proxy server credentials",
"default":null,
"x-oneOf":[
{
"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
},
{
"type":"null"
}
]
}
},
"required":[
"host",
"port"
],
"additionalProperties":false
}
},
"additionalProperties":false
},
"credentials":{
"description":"Credentials for source database",
"default":null,
"x-oneOf":[
{
"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
},
{
"type":"null"
}
]
},
"description":{
"description":"Description for the process",
"type":"string",
"minLength":"1",
"maxLength":"4095"
}
},
"additionalProperties":false
}
ネストされたスキーマ: alias
型: object
ソースの表示
{
"type":"object",
"properties":{
"name":{
"description":"Name of passive extract on the source",
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":"1",
"maxLength":"8"
},
"manager":{
"description":"Manager server to use",
"type":"object",
"properties":{
"host":{
"description":"Host name or IP Address",
"x-oneOf":[
{
"description":"Network host name",
"type":"string",
"pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
"minLength":"1",
"maxLength":"4095"
},
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
]
},
"port":{
"description":"IP Port number",
"type":"integer",
"minimum":"1",
"maximum":"65535"
}
},
"required":[
"host",
"port"
],
"additionalProperties":false
},
"proxy":{
"type":"object",
"properties":{
"host":{
"description":"Proxy server host name or IP address",
"x-oneOf":[
{
"description":"Network host name",
"type":"string",
"pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
"minLength":"1",
"maxLength":"4095"
},
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
]
},
"port":{
"description":"Proxy server port number",
"type":"integer",
"minimum":"1",
"maximum":"65535"
},
"credentials":{
"description":"Proxy server credentials",
"default":null,
"x-oneOf":[
{
"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
},
{
"type":"null"
}
]
}
},
"required":[
"host",
"port"
],
"additionalProperties":false
}
},
"additionalProperties":false
}
ネストされたスキーマ: begin
データ処理の開始位置
デフォルト値: now
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 begin-x-oneOf[2]
{
"description":"Starting point for data processing",
"default":"now",
"x-oneOf":[
{
"enum":[
"now"
]
},
{
"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"
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atDbms"
]
},
"at":{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"System Change Number(Normal Format) for Oracle Database.",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000",
"example":"6488359"
},
{
"description":"System Change Number(Alternate Format) for Oracle Database.",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":"3",
"maxLength":"64",
"example":"6488359.3456712"
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
},
"required":[
"at"
],
"additionalProperties":false
}
]
}
ネストされたスキーマ: config
型: array
最小アイテム数: 0
最大アイテム数: 32767
ソースの表示
{
"type":"array",
"items":{
"type":"string",
"minLength":"0",
"maxLength":"4095"
},
"minItems":"0",
"maxItems":"32767"
}
ネストされたスキーマ: credentials
ソース・データベースの資格証明
デフォルト値: oracle.doceng.json.BetterJsonNull@6d60899e
1つに一致
ソースの表示
{
"description":"Credentials for source database",
"default":null,
"x-oneOf":[
{
"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
},
{
"type":"null"
}
]
}
ネストされたスキーマ: encryptionProfile
1つに一致
ソースの表示
- string
最小長: 1
最大長: 64
パターン: ^[A-Za-z0-9][A-Za-z0-9_:-]*$
'ogg:encryptionProfile'構成値の名前
- null
{
"x-oneOf":[
{
"description":"Name of 'ogg:encryptionProfile' configuration value",
"type":"string",
"pattern":"^[A-Za-z0-9][A-Za-z0-9_:-]*$",
"minLength":"1",
"maxLength":"64"
},
{
"type":"null"
}
]
}
ネストされたスキーマ: managedProcessSettings
Administration ServerでERプロセスが管理される方法を制御します
1つに一致
ソースの表示
{
"description":"Control how the ER process is managed by the Administration Server",
"x-oneOf":[
{
"description":"Custom settings",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:managedProcessSettings"
]
},
"autoStart":{
"description":"Description of how the ER process starts with Administration Server",
"type":"object",
"properties":{
"enabled":{
"description":"If set, the process is started when Administration Server starts",
"type":"boolean",
"default":false
},
"delay":{
"description":"Time to wait in seconds before starting process",
"type":"integer",
"minimum":"0",
"default":"0",
"maximum":"3600"
}
},
"required":[
"enabled"
],
"additionalProperties":false
},
"autoRestart":{
"description":"Control how the ER process is restarted by the Administration Server if it terminates",
"default":{
"enabled":false,
"onSuccess":false,
"delay":"0",
"retries":"9",
"window":"60",
"disableOnFailure":true
},
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:taskRestart"
]
},
"enabled":{
"description":"If set, the task can be restarted if it terminates.",
"type":"boolean",
"default":false
},
"onSuccess":{
"description":"If false, the task is only restarted if it fails.",
"type":"boolean",
"default":false
},
"delay":{
"description":"The amount of time, in seconds, to pause between discovering that a process has terminated abnormally and restarting the process.",
"type":"integer",
"minimum":"0",
"default":"0",
"maximum":"3600"
},
"retries":{
"description":"The maximum number of times the task should be restarted before aborting retry efforts.",
"type":"integer",
"minimum":"0",
"default":"9",
"maximum":"3600"
},
"window":{
"description":"The window of time, in seconds, during which retries are counted.",
"type":"integer",
"minimum":"0",
"default":"60",
"maximum":"604800"
},
"disableOnFailure":{
"description":"If true, the task is disabled when it fails all execution attempts in an execution window.",
"type":"boolean",
"default":true
},
"failures":{
"description":"The number of times the task failed in the current window.",
"type":"integer",
"minimum":"0",
"maximum":"3600"
}
},
"required":[
"enabled"
],
"additionalProperties":false
}
},
"additionalProperties":false
},
{
"description":"Name of 'ogg:managedProcessSettings' configuration value",
"type":"string",
"pattern":"^[A-Za-z0-9][A-Za-z0-9_:-]*$",
"minLength":"1",
"maxLength":"64"
}
]
}
ネストされたスキーマ: miningCredentials
ダウンストリーム・マイニング・データベースの資格証明
デフォルト値: oracle.doceng.json.BetterJsonNull@107bfcb2
1つに一致
ソースの表示
{
"description":"Credentials for downstream mining database",
"default":null,
"x-oneOf":[
{
"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
},
{
"type":"null"
}
]
}
ネストされたスキーマ: registration
ソース・データベースへの登録
デフォルト値: none
1つに一致
ソースの表示
{
"description":"Registration with the source database",
"default":"none",
"x-oneOf":[
{
"x-oneOf":[
{
"description":"Integrated extract registration options",
"type":"object",
"properties":{
"containers":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
}
]
},
"minItems":"0",
"maxItems":"256"
},
"csn":{
"x-oneOf":[
{
"description":"System Change Number(Normal Format) for Oracle Database.",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000",
"example":"6488359"
},
{
"description":"System Change Number(Alternate Format) for Oracle Database.",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":"3",
"maxLength":"64",
"example":"6488359.3456712"
}
]
},
"share":{
"description":"Describe how to share the LogMiner data dictionary",
"default":false,
"x-oneOf":[
{
"type":"boolean"
},
{
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":"1",
"maxLength":"8"
}
]
},
"optimized":{
"type":"boolean",
"default":false
},
"replace":{
"description":"If true, replace existing registration details from an extract with the same name",
"type":"boolean",
"default":false
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"containers"
]
},
{
"required":[
"csn"
]
},
{
"required":[
"share"
]
},
{
"required":[
"optimized"
]
}
]
}
]
},
{
"enum":[
"none",
"default"
]
}
]
}
ネストされたスキーマ: source
処理するデータのソース
1つに一致
ソースの表示
{
"description":"Source of data to process",
"x-oneOf":[
{
"description":"Use tables (initial load)",
"enum":[
"tables"
]
},
{
"description":"Use transaction logs with change data capture",
"enum":[
"tranlogs"
]
},
{
"description":"OGG 19c Syntax NO LONGER SUPPORTED",
"type":"object",
"properties":{
"tranlogs":{
"enum":[
"integrated",
"classic"
]
}
},
"required":[
"tranlogs"
],
"additionalProperties":false
}
]
}
ネストされたスキーマ: targets
型: array
最小アイテム数: 0
最大アイテム数: 1024
取得されるデータのターゲット
ソースの表示
{
"description":"Targets for captured data",
"type":"array",
"items":{
"x-oneOf":[
{
"type":"object",
"properties":{
"spaceUsed":{
"description":"Bytes consumed by all trail sequences",
"type":"integer",
"minimum":"0",
"maximum":"18446744073709552000"
},
"sizeMB":{
"description":"The maximum size, in megabytes, of a file in the trail.",
"type":"integer",
"default":"500",
"minimum":"1",
"maximum":"2000"
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":"0",
"maximum":"2147483647"
},
"sequenceMaxInUse":{
"description":"Maximum trail sequence number in use",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":"1",
"maxLength":"4096"
},
"remote":{
"description":"Indicates if trail is local or remote",
"type":"boolean",
"default":false
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]$",
"minLength":"2",
"maxLength":"2"
},
"sequence":{
"description":"Trail beginning sequence number",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"$schema":{
"enum":[
"ogg:trail"
]
},
"sequenceMinInUse":{
"description":"Minimum trail sequence number in use",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"sequenceLength":{
"description":"Number of digits in sequence file name",
"enum":[
"6",
"9"
],
"default":"9"
},
"sequenceMin":{
"description":"Minimum trail sequence number that exists in the deployment",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"sequenceLengthFlip":{
"description":"Indicates sequence number length will change",
"type":"boolean",
"default":false
},
"sequenceMax":{
"description":"Maximum trail sequence number that exists in the deployment",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
}
},
"required":[
"name"
],
"additionalProperties":false
}
]
},
"minItems":"0",
"maxItems":"1024"
}
ネストされたスキーマ: manager
型: object
使用するマネージャ・サーバー
ソースの表示
{
"description":"Manager server to use",
"type":"object",
"properties":{
"host":{
"description":"Host name or IP Address",
"x-oneOf":[
{
"description":"Network host name",
"type":"string",
"pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
"minLength":"1",
"maxLength":"4095"
},
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
]
},
"port":{
"description":"IP Port number",
"type":"integer",
"minimum":"1",
"maximum":"65535"
}
},
"required":[
"host",
"port"
],
"additionalProperties":false
}
ネストされたスキーマ: proxy
型: object
ソースの表示
{
"type":"object",
"properties":{
"host":{
"description":"Proxy server host name or IP address",
"x-oneOf":[
{
"description":"Network host name",
"type":"string",
"pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
"minLength":"1",
"maxLength":"4095"
},
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
]
},
"port":{
"description":"Proxy server port number",
"type":"integer",
"minimum":"1",
"maximum":"65535"
},
"credentials":{
"description":"Proxy server credentials",
"default":null,
"x-oneOf":[
{
"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
},
{
"type":"null"
}
]
}
},
"required":[
"host",
"port"
],
"additionalProperties":false
}
ネストされたスキーマ: host
ホスト名またはIPアドレス
1つに一致
ソースの表示
- string
最小長: 1
最大長: 4095
パターン: ^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$
ネットワーク・ホスト名
- host-x-oneOf[1]
{
"description":"Host name or IP Address",
"x-oneOf":[
{
"description":"Network host name",
"type":"string",
"pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
"minLength":"1",
"maxLength":"4095"
},
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
]
}
ネストされたスキーマ: host-x-oneOf[1]
ネットワークIPアドレス
1つに一致
ソースの表示
- string
最小長: 7
最大長: 15
パターン: ^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$
ネットワークIPv4アドレス
- string
最小長: 1
最大長: 256
パターン: ^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$
ネットワークIPv6アドレス
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
ネストされたスキーマ: credentials
プロキシ・サーバーの資格証明
デフォルト値: oracle.doceng.json.BetterJsonNull@63d5874f
1つに一致
ソースの表示
{
"description":"Proxy server credentials",
"default":null,
"x-oneOf":[
{
"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
},
{
"type":"null"
}
]
}
ネストされたスキーマ: host
プロキシ・サーバーのホスト名またはIPアドレス
1つに一致
ソースの表示
- string
最小長: 1
最大長: 4095
パターン: ^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$
ネットワーク・ホスト名
- host-x-oneOf[1]
{
"description":"Proxy server host name or IP address",
"x-oneOf":[
{
"description":"Network host name",
"type":"string",
"pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
"minLength":"1",
"maxLength":"4095"
},
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
]
}
ネストされたスキーマ: credentials-x-oneOf[0]
型: object
ソースの表示
{
"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
}
ネストされたスキーマ: host-x-oneOf[1]
ネットワークIPアドレス
1つに一致
ソースの表示
- string
最小長: 7
最大長: 15
パターン: ^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$
ネットワークIPv4アドレス
- string
最小長: 1
最大長: 256
パターン: ^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$
ネットワークIPv6アドレス
{
"description":"Network IP address",
"x-oneOf":[
{
"description":"Network IPv4 address",
"type":"string",
"pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
"minLength":"7",
"maxLength":"15"
},
{
"description":"Network IPv6 address",
"type":"string",
"pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
"minLength":"1",
"maxLength":"256"
}
]
}
ネストされたスキーマ: begin-x-oneOf[2]
型: object
ソースの表示
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"type:position/atDbms"
]
},
"at":{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"System Change Number(Normal Format) for Oracle Database.",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000",
"example":"6488359"
},
{
"description":"System Change Number(Alternate Format) for Oracle Database.",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":"3",
"maxLength":"64",
"example":"6488359.3456712"
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
},
"required":[
"at"
],
"additionalProperties":false
}
ネストされたスキーマ: at
型: object
特定のSCNの位置(統合モード)
ソースの表示
{
"description":"Position at a specific SCN (integrated mode)",
"type":"object",
"properties":{
"csn":{
"x-oneOf":[
{
"description":"System Change Number(Normal Format) for Oracle Database.",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000",
"example":"6488359"
},
{
"description":"System Change Number(Alternate Format) for Oracle Database.",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":"3",
"maxLength":"64",
"example":"6488359.3456712"
}
]
}
},
"required":[
"csn"
],
"additionalProperties":false
}
ネストされたスキーマ: csn
1つに一致
ソースの表示
- integer
最小値: 0
最大値: 9223372036854776000
Oracle Databaseの場合のシステム変更番号(標準形式)。
例: 6488359
- string
最小長: 3
最大長: 64
パターン: [0-9]+[.][0-9]+
Oracle Databaseの場合のシステム変更番号(代替形式)。
例: 6488359.3456712
{
"x-oneOf":[
{
"description":"System Change Number(Normal Format) for Oracle Database.",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000",
"example":"6488359"
},
{
"description":"System Change Number(Alternate Format) for Oracle Database.",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":"3",
"maxLength":"64",
"example":"6488359.3456712"
}
]
}
ネストされたスキーマ: credentials-x-oneOf[0]
型: object
ソースの表示
{
"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
}
ネストされたスキーマ: managedProcessSettings-x-oneOf[0]
型: object
カスタム設定
ソースの表示
{
"description":"Custom settings",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:managedProcessSettings"
]
},
"autoStart":{
"description":"Description of how the ER process starts with Administration Server",
"type":"object",
"properties":{
"enabled":{
"description":"If set, the process is started when Administration Server starts",
"type":"boolean",
"default":false
},
"delay":{
"description":"Time to wait in seconds before starting process",
"type":"integer",
"minimum":"0",
"default":"0",
"maximum":"3600"
}
},
"required":[
"enabled"
],
"additionalProperties":false
},
"autoRestart":{
"description":"Control how the ER process is restarted by the Administration Server if it terminates",
"default":{
"enabled":false,
"onSuccess":false,
"delay":"0",
"retries":"9",
"window":"60",
"disableOnFailure":true
},
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:taskRestart"
]
},
"enabled":{
"description":"If set, the task can be restarted if it terminates.",
"type":"boolean",
"default":false
},
"onSuccess":{
"description":"If false, the task is only restarted if it fails.",
"type":"boolean",
"default":false
},
"delay":{
"description":"The amount of time, in seconds, to pause between discovering that a process has terminated abnormally and restarting the process.",
"type":"integer",
"minimum":"0",
"default":"0",
"maximum":"3600"
},
"retries":{
"description":"The maximum number of times the task should be restarted before aborting retry efforts.",
"type":"integer",
"minimum":"0",
"default":"9",
"maximum":"3600"
},
"window":{
"description":"The window of time, in seconds, during which retries are counted.",
"type":"integer",
"minimum":"0",
"default":"60",
"maximum":"604800"
},
"disableOnFailure":{
"description":"If true, the task is disabled when it fails all execution attempts in an execution window.",
"type":"boolean",
"default":true
},
"failures":{
"description":"The number of times the task failed in the current window.",
"type":"integer",
"minimum":"0",
"maximum":"3600"
}
},
"required":[
"enabled"
],
"additionalProperties":false
}
},
"additionalProperties":false
}
ネストされたスキーマ: autoRestart
型: object
ERプロセスが終了した場合に、Administration Serverによって再起動される方法を制御します
デフォルト値: { "enabled":false, "onSuccess":false, "delay":"0", "retries":"9", "window":"60", "disableOnFailure":true }
ソースの表示
{
"description":"Control how the ER process is restarted by the Administration Server if it terminates",
"default":{
"enabled":false,
"onSuccess":false,
"delay":"0",
"retries":"9",
"window":"60",
"disableOnFailure":true
},
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:taskRestart"
]
},
"enabled":{
"description":"If set, the task can be restarted if it terminates.",
"type":"boolean",
"default":false
},
"onSuccess":{
"description":"If false, the task is only restarted if it fails.",
"type":"boolean",
"default":false
},
"delay":{
"description":"The amount of time, in seconds, to pause between discovering that a process has terminated abnormally and restarting the process.",
"type":"integer",
"minimum":"0",
"default":"0",
"maximum":"3600"
},
"retries":{
"description":"The maximum number of times the task should be restarted before aborting retry efforts.",
"type":"integer",
"minimum":"0",
"default":"9",
"maximum":"3600"
},
"window":{
"description":"The window of time, in seconds, during which retries are counted.",
"type":"integer",
"minimum":"0",
"default":"60",
"maximum":"604800"
},
"disableOnFailure":{
"description":"If true, the task is disabled when it fails all execution attempts in an execution window.",
"type":"boolean",
"default":true
},
"failures":{
"description":"The number of times the task failed in the current window.",
"type":"integer",
"minimum":"0",
"maximum":"3600"
}
},
"required":[
"enabled"
],
"additionalProperties":false
}
ネストされたスキーマ: autoStart
型: object
ERプロセスがAdministration Serverで起動される方法の説明
ソースの表示
{
"description":"Description of how the ER process starts with Administration Server",
"type":"object",
"properties":{
"enabled":{
"description":"If set, the process is started when Administration Server starts",
"type":"boolean",
"default":false
},
"delay":{
"description":"Time to wait in seconds before starting process",
"type":"integer",
"minimum":"0",
"default":"0",
"maximum":"3600"
}
},
"required":[
"enabled"
],
"additionalProperties":false
}
ネストされたスキーマ: miningCredentials-x-oneOf[0]
型: object
ソースの表示
{
"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
}
ネストされたスキーマ: registration-x-oneOf[0]
1つに一致
ソースの表示
{
"x-oneOf":[
{
"description":"Integrated extract registration options",
"type":"object",
"properties":{
"containers":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
}
]
},
"minItems":"0",
"maxItems":"256"
},
"csn":{
"x-oneOf":[
{
"description":"System Change Number(Normal Format) for Oracle Database.",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000",
"example":"6488359"
},
{
"description":"System Change Number(Alternate Format) for Oracle Database.",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":"3",
"maxLength":"64",
"example":"6488359.3456712"
}
]
},
"share":{
"description":"Describe how to share the LogMiner data dictionary",
"default":false,
"x-oneOf":[
{
"type":"boolean"
},
{
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":"1",
"maxLength":"8"
}
]
},
"optimized":{
"type":"boolean",
"default":false
},
"replace":{
"description":"If true, replace existing registration details from an extract with the same name",
"type":"boolean",
"default":false
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"containers"
]
},
{
"required":[
"csn"
]
},
{
"required":[
"share"
]
},
{
"required":[
"optimized"
]
}
]
}
]
}
ネストされたスキーマ: registration-x-oneOf[0]-x-oneOf[0]
型: object
統合Extractの登録オプション
ソースの表示
{
"description":"Integrated extract registration options",
"type":"object",
"properties":{
"containers":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
}
]
},
"minItems":"0",
"maxItems":"256"
},
"csn":{
"x-oneOf":[
{
"description":"System Change Number(Normal Format) for Oracle Database.",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000",
"example":"6488359"
},
{
"description":"System Change Number(Alternate Format) for Oracle Database.",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":"3",
"maxLength":"64",
"example":"6488359.3456712"
}
]
},
"share":{
"description":"Describe how to share the LogMiner data dictionary",
"default":false,
"x-oneOf":[
{
"type":"boolean"
},
{
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":"1",
"maxLength":"8"
}
]
},
"optimized":{
"type":"boolean",
"default":false
},
"replace":{
"description":"If true, replace existing registration details from an extract with the same name",
"type":"boolean",
"default":false
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"containers"
]
},
{
"required":[
"csn"
]
},
{
"required":[
"share"
]
},
{
"required":[
"optimized"
]
}
]
}
いずれかに一致
ソースの表示
{
"description":"Integrated extract registration options",
"type":"object",
"properties":{
"containers":{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
}
]
},
"minItems":"0",
"maxItems":"256"
},
"csn":{
"x-oneOf":[
{
"description":"System Change Number(Normal Format) for Oracle Database.",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000",
"example":"6488359"
},
{
"description":"System Change Number(Alternate Format) for Oracle Database.",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":"3",
"maxLength":"64",
"example":"6488359.3456712"
}
]
},
"share":{
"description":"Describe how to share the LogMiner data dictionary",
"default":false,
"x-oneOf":[
{
"type":"boolean"
},
{
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":"1",
"maxLength":"8"
}
]
},
"optimized":{
"type":"boolean",
"default":false
},
"replace":{
"description":"If true, replace existing registration details from an extract with the same name",
"type":"boolean",
"default":false
}
},
"additionalProperties":false,
"x-anyOf":[
{
"required":[
"containers"
]
},
{
"required":[
"csn"
]
},
{
"required":[
"share"
]
},
{
"required":[
"optimized"
]
}
]
}
ネストされたスキーマ: containers
型: array
最小アイテム数: 0
最大アイテム数: 256
ソースの表示
{
"type":"array",
"items":{
"x-oneOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
}
]
},
"minItems":"0",
"maxItems":"256"
}
ネストされたスキーマ: csn
1つに一致
ソースの表示
- integer
最小値: 0
最大値: 9223372036854776000
Oracle Databaseの場合のシステム変更番号(標準形式)。
例: 6488359
- string
最小長: 3
最大長: 64
パターン: [0-9]+[.][0-9]+
Oracle Databaseの場合のシステム変更番号(代替形式)。
例: 6488359.3456712
{
"x-oneOf":[
{
"description":"System Change Number(Normal Format) for Oracle Database.",
"type":"integer",
"minimum":"0",
"maximum":"9223372036854776000",
"example":"6488359"
},
{
"description":"System Change Number(Alternate Format) for Oracle Database.",
"type":"string",
"pattern":"[0-9]+[.][0-9]+",
"minLength":"3",
"maxLength":"64",
"example":"6488359.3456712"
}
]
}
ネストされたスキーマ: share
LogMinerデータ・ディクショナリを共有する方法を示します
デフォルト値: false
1つに一致
ソースの表示
{
"description":"Describe how to share the LogMiner data dictionary",
"default":false,
"x-oneOf":[
{
"type":"boolean"
},
{
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":"1",
"maxLength":"8"
}
]
}
ネストされたスキーマ: items
1つに一致
ソースの表示
- string
最小長: 1
最大長: 130
パターン: ^([^.*?"]{1,128}|["].{1,128}["])$
{
"x-oneOf":[
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":"1",
"maxLength":"130"
}
]
}
ネストされたスキーマ: source-x-oneOf[2]
型: object
サポートされていないOGG 19c構文
ソースの表示
{
"description":"OGG 19c Syntax NO LONGER SUPPORTED",
"type":"object",
"properties":{
"tranlogs":{
"enum":[
"integrated",
"classic"
]
}
},
"required":[
"tranlogs"
],
"additionalProperties":false
}
ネストされたスキーマ: items
1つに一致
ソースの表示
{
"x-oneOf":[
{
"type":"object",
"properties":{
"spaceUsed":{
"description":"Bytes consumed by all trail sequences",
"type":"integer",
"minimum":"0",
"maximum":"18446744073709552000"
},
"sizeMB":{
"description":"The maximum size, in megabytes, of a file in the trail.",
"type":"integer",
"default":"500",
"minimum":"1",
"maximum":"2000"
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":"0",
"maximum":"2147483647"
},
"sequenceMaxInUse":{
"description":"Maximum trail sequence number in use",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":"1",
"maxLength":"4096"
},
"remote":{
"description":"Indicates if trail is local or remote",
"type":"boolean",
"default":false
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]$",
"minLength":"2",
"maxLength":"2"
},
"sequence":{
"description":"Trail beginning sequence number",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"$schema":{
"enum":[
"ogg:trail"
]
},
"sequenceMinInUse":{
"description":"Minimum trail sequence number in use",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"sequenceLength":{
"description":"Number of digits in sequence file name",
"enum":[
"6",
"9"
],
"default":"9"
},
"sequenceMin":{
"description":"Minimum trail sequence number that exists in the deployment",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"sequenceLengthFlip":{
"description":"Indicates sequence number length will change",
"type":"boolean",
"default":false
},
"sequenceMax":{
"description":"Maximum trail sequence number that exists in the deployment",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
}
},
"required":[
"name"
],
"additionalProperties":false
}
]
}
ネストされたスキーマ: items-x-oneOf[0]
型: object
ソースの表示
{
"type":"object",
"properties":{
"spaceUsed":{
"description":"Bytes consumed by all trail sequences",
"type":"integer",
"minimum":"0",
"maximum":"18446744073709552000"
},
"sizeMB":{
"description":"The maximum size, in megabytes, of a file in the trail.",
"type":"integer",
"default":"500",
"minimum":"1",
"maximum":"2000"
},
"offset":{
"description":"Offset in trail sequence file",
"type":"integer",
"minimum":"0",
"maximum":"2147483647"
},
"sequenceMaxInUse":{
"description":"Maximum trail sequence number in use",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"path":{
"description":"The path where trail data is stored",
"type":"string",
"minLength":"1",
"maxLength":"4096"
},
"remote":{
"description":"Indicates if trail is local or remote",
"type":"boolean",
"default":false
},
"name":{
"description":"The name of the trail",
"type":"string",
"pattern":"^[A-Za-z][A-Za-z0-9]$",
"minLength":"2",
"maxLength":"2"
},
"sequence":{
"description":"Trail beginning sequence number",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"$schema":{
"enum":[
"ogg:trail"
]
},
"sequenceMinInUse":{
"description":"Minimum trail sequence number in use",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"sequenceLength":{
"description":"Number of digits in sequence file name",
"enum":[
"6",
"9"
],
"default":"9"
},
"sequenceMin":{
"description":"Minimum trail sequence number that exists in the deployment",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
},
"sequenceLengthFlip":{
"description":"Indicates sequence number length will change",
"type":"boolean",
"default":false
},
"sequenceMax":{
"description":"Maximum trail sequence number that exists in the deployment",
"type":"integer",
"minimum":"0",
"maximum":"999999999",
"default":"0"
}
},
"required":[
"name"
],
"additionalProperties":false
}