ルート・スキーマ: Oracle GoldenGate Task
型: object
タイトル: Oracle GoldenGate Task
ソースの表示
{
"title":"Oracle GoldenGate Task",
"type":"object",
"properties":{
"maxHistory":{
"description":"Number of task executions to maintain history for",
"type":"integer",
"minimum":1,
"default":10,
"maximum":1024
},
"command":{
"x-oneOf":[
{
"description":"Start an Extract or Replicat",
"type":"object",
"properties":{
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"after":{
"description":"Directs Extract/Replicat to position its start point at the beginning of the first transaction after the one that has the specified CSN. Any transactions in the data source that have CSN values that are less than, or equal to, the specified one are skipped.",
"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
}
]
},
"threads":{
"description":"Valid when used with 'skipTransaction', 'at', or 'after' with Replicat in coordinated mode. Starts the specified Replicat thread or threads at the specified location.",
"type":"array",
"items":{
"type":"integer",
"minimum":1,
"maximum":500
},
"minItems":1,
"maxItems":500
},
"name":{
"enum":[
"start"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"$schema":{
"enum":[
"ogg:command"
]
},
"skipTransaction":{
"description":"Causes Replicat to skip the first transaction after its expected startup position in the trail. All operations from that first transaction are excluded.",
"type":"boolean",
"default":false
},
"filterDuplicates":{
"description":"Causes Replicat to ignore transactions that it has already processed. Use when Extract was repositioned to a new start point (using the ATCSN or AFTERCSN) and you are confident that there are duplicate transactions in the trail that could cause Replicat to abend. This option requires the use of a checkpoint table. If the database is Oracle, this option is valid only for Replicat in nonintegrated mode. Integrated mode handles duplicate transactions transparently. The default is true.",
"type":"boolean",
"default":true
},
"at":{
"description":"Directs Extract/Replicat to position its start point at the transaction that has the specified CSN. Any transactions in the data source that have CSN values less than the specified one are skipped.",
"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
}
]
}
},
"additionalProperties":false,
"allOf":[
{
"required":[
"name",
"processName"
]
},
{
"not":{
"required":[
"at",
"after"
]
}
},
{
"not":{
"required":[
"at",
"skipTransaction"
]
}
},
{
"not":{
"required":[
"after",
"skipTransaction"
]
}
},
{
"dependencies":{
"filterDuplicates":{
"properties":{
"processType":{
"enum":[
"replicat",
"ER"
]
}
}
},
"threads":{
"properties":{
"processType":{
"enum":[
"replicat",
"ER"
]
}
}
}
}
},
{
"x-anyOf":[
{
"dependencies":{
"threads":[
"at"
]
}
},
{
"dependencies":{
"threads":[
"after"
]
}
},
{
"dependencies":{
"threads":[
"skipTransaction"
]
}
}
]
}
]
},
{
"description":"Stop an Extract or Replicat",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"stop"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"force":{
"type":"boolean",
"default":false
}
},
"required":[
"name",
"processName"
],
"additionalProperties":false
},
{
"description":"Kill an Extract or Replicat",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"kill"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
}
},
"required":[
"name",
"processName"
],
"additionalProperties":false
},
{
"description":"Execute an Extract or Replicat",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"execute"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"processName":{
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
}
},
"required":[
"name",
"processName"
],
"additionalProperties":false
},
{
"description":"Synchronize a Replicat",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"synchronize"
]
},
"processType":{
"enum":[
"replicat"
]
},
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
}
},
"required":[
"name",
"processName"
],
"additionalProperties":false
},
{
"description":"Execute the Monitor Agent",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"execute"
]
},
"processName":{
"enum":[
"Monitor Agent"
]
}
},
"required":[
"name",
"processName"
],
"additionalProperties":false
},
{
"description":"Report on Processes",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"up",
"down"
]
}
},
"required":[
"name",
"reportType"
],
"additionalProperties":false
},
{
"description":"Report on Process Lag",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"lag"
]
},
"thresholds":{
"type":"array",
"items":{
"type":"object",
"properties":{
"type":{
"enum":[
"info",
"critical"
]
},
"units":{
"x-oneOf":[
{
"enum":[
"seconds"
]
},
{
"enum":[
"minutes"
]
},
{
"enum":[
"hours"
]
}
]
},
"value":{
"type":"integer",
"minimum":0,
"maximum":65535
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":2
}
},
"required":[
"name",
"reportType",
"thresholds"
],
"additionalProperties":false
},
{
"description":"Report Operating System and database version information",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"versions"
]
},
"credentials":{
"description":"Credentials for 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"
}
]
}
},
"required":[
"name",
"reportType"
],
"additionalProperties":false
},
{
"description":"Lists the schemas in the database with names that match the input specification",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"schemas"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"specification":{
"description":"The name of a schema which can include wildcard characters",
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":3,
"maxLength":261
}
]
}
},
"required":[
"name",
"reportType",
"credentials",
"specification"
],
"additionalProperties":false
},
{
"description":"Lists the tables in the database with names that match the input specification",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"tables"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"specification":{
"description":"The name of a table or a group of tables which can include wildcard characters",
"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
}
]
}
},
"required":[
"name",
"reportType",
"credentials",
"specification"
],
"additionalProperties":false
},
{
"description":"Lists the checkpoint tables in the database with names that match the input specification",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"checkpointTables"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"specification":{
"description":"The name of a checkpoint table or a group of checkpoint tables which can include wildcard characters",
"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
}
]
}
},
"required":[
"name",
"reportType",
"credentials",
"specification"
],
"additionalProperties":false
},
{
"description":"Lists the containers in the database with names that match the input specification",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"containers"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"specification":{
"description":"The name of a container or a group of containers which can include wildcard characters",
"type":"string",
"pattern":"^([^.\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
}
},
"required":[
"name",
"reportType",
"credentials",
"specification"
],
"additionalProperties":false
},
{
"description":"Purge checkpoint history for ER processes",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"purge"
]
},
"purgeType":{
"enum":[
"checkpoints"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"keep":{
"type":"array",
"items":{
"type":"object",
"properties":{
"type":{
"enum":[
"max"
]
},
"units":{
"x-oneOf":[
{
"enum":[
"checkpoints"
]
}
]
},
"value":{
"type":"integer",
"minimum":1,
"maximum":500
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":1
}
},
"required":[
"name",
"purgeType",
"processName",
"keep"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"purge"
]
},
"purgeType":{
"enum":[
"ddlHistory",
"ddlHistoryAlt",
"markerHistory"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"keep":{
"type":"array",
"items":{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Maximum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"max"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Maximum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"max"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":2
}
},
"required":[
"name",
"purgeType",
"credentials",
"keep"
],
"additionalProperties":false
},
{
"description":"Purge trail files no longer needed",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"purge"
]
},
"purgeType":{
"enum":[
"trails"
]
},
"trails":{
"description":"Trails to purge",
"type":"array",
"items":{
"type":"object",
"properties":{
"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
}
},
"required":[
"name"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":1024
},
"useCheckpoints":{
"type":"boolean",
"default":true
},
"keep":{
"type":"array",
"items":{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of files",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"files"
]
},
"value":{
"type":"integer",
"minimum":0,
"maximum":100
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":1
}
},
"required":[
"name",
"purgeType",
"trails",
"keep"
],
"additionalProperties":false
},
{
"description":"Purge Extract or Replicat tasks",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"purge"
]
},
"purgeType":{
"enum":[
"tasks"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"useStatus":{
"type":"boolean",
"default":false
},
"keep":{
"type":"array",
"items":{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":1
}
},
"required":[
"name",
"purgeType",
"processName",
"keep"
],
"additionalProperties":false
},
{
"description":"Purge files no longer needed",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"purge"
]
},
"purgeType":{
"enum":[
"files"
]
},
"dumpFiles":{
"description":"Purge dump files (*.dmp) which are generated when an application abnormally terminates",
"type":"boolean",
"default":false
},
"keep":{
"type":"array",
"items":{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":1
}
},
"required":[
"name",
"purgeType",
"keep"
],
"additionalProperties":false
},
{
"description":"Updates a database sequence so that initial redo records are available at the time that Extract starts capturing transaction data after the instantiation of the replication environment.",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"flushSequence"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"sequence":{
"description":"The owner and name of a database sequence. The schema name cannot be null. You can use wildcard characters for the sequence name but not for the owner name.",
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
},
{
"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
}
]
},
"trace":{
"description":"Whether to call the sql procedure to update the sequence with tracing mode on",
"type":"boolean",
"default":false
}
},
"required":[
"name",
"credentials",
"sequence"
],
"additionalProperties":false
}
]
},
"enabled":{
"description":"Indicates if the task is enabled for execution",
"type":"boolean",
"default":true
},
"schedule":{
"x-oneOf":[
{
"description":"Task is not scheduled",
"enum":[
"none"
]
},
{
"description":"Task is run on a time-based schedule",
"type":"object",
"properties":{
"days":{
"description":"Days of the week to run the task",
"x-oneOf":[
{
"enum":[
"every"
]
},
{
"enum":[
"Sunday",
"Monday",
"Tuesday",
"Wednesday",
"Thursday",
"Friday",
"Saturday"
]
},
{
"type":"array",
"items":{
"enum":[
"Sunday",
"Monday",
"Tuesday",
"Wednesday",
"Thursday",
"Friday",
"Saturday"
]
},
"minItems":1,
"maxItems":7
}
]
},
"times":{
"description":"Array of times to run task in 24 hour format HH:MM",
"type":"array",
"items":{
"type":"string",
"pattern":"([01][0-9]|2[0-3]):[0-5][0-9]",
"minLength":5,
"maxLength":5
},
"minItems":1,
"maxItems":1440
}
},
"required":[
"days",
"times"
],
"additionalProperties":false
},
{
"description":"Task is run on an interval",
"type":"object",
"properties":{
"every":{
"type":"object",
"properties":{
"units":{
"x-oneOf":[
{
"enum":[
"minutes"
]
},
{
"enum":[
"hours"
]
},
{
"enum":[
"days"
]
},
{
"enum":[
"weeks"
]
}
]
},
"value":{
"type":"integer",
"minimum":0,
"maximum":1024
}
},
"required":[
"units",
"value"
],
"additionalProperties":false
}
},
"required":[
"every"
],
"additionalProperties":false
},
{
"description":"Task is run when the Admin Server starts",
"type":"object",
"properties":{
"autoStart":{
"description":"Indicates task starts with Admin Server",
"enum":[
true
]
},
"delay":{
"description":"Time to wait in seconds before starting task",
"type":"integer",
"minimum":0,
"default":0,
"maximum":3600
}
},
"required":[
"autoStart"
],
"additionalProperties":false
}
]
},
"$schema":{
"enum":[
"ogg:task"
]
},
"status":{
"description":"Task Status",
"default":"stopped",
"enum":[
"starting",
"running",
"stopped",
"killed",
"abended"
]
},
"timeout":{
"description":"Amount of time in seconds before a running task is cancelled",
"type":"integer",
"minimum":1,
"maximum":65535
},
"critical":{
"description":"Indicates the task is critical to the deployment",
"type":"boolean",
"default":false
},
"restart":{
"description":"Control how the task is restarted if it terminates",
"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":120,
"maximum":3600
},
"retries":{
"description":"The maximum number of times the task should be restarted before aborting retry efforts.",
"type":"integer",
"minimum":0,
"default":2,
"maximum":3600
},
"window":{
"description":"The window of time, in seconds, during which retries are counted. The default is 7200 seconds (2 hours).",
"type":"integer",
"minimum":0,
"default":7200,
"maximum":604800
},
"disableOnFailure":{
"description":"If true, the task is disabled when it fails all execution attempts in an execution window.",
"type":"boolean",
"default":false
},
"failures":{
"description":"The number of times the task failed in the current window.",
"type":"integer",
"minimum":0,
"maximum":3600
}
},
"additionalProperties":false
},
"description":{
"description":"A description of the task",
"type":"string",
"minLength":1,
"maxLength":4095
}
},
"additionalProperties":false
}
ネストされたスキーマ: command
1つに一致
ソースの表示
{
"x-oneOf":[
{
"description":"Start an Extract or Replicat",
"type":"object",
"properties":{
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"after":{
"description":"Directs Extract/Replicat to position its start point at the beginning of the first transaction after the one that has the specified CSN. Any transactions in the data source that have CSN values that are less than, or equal to, the specified one are skipped.",
"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
}
]
},
"threads":{
"description":"Valid when used with 'skipTransaction', 'at', or 'after' with Replicat in coordinated mode. Starts the specified Replicat thread or threads at the specified location.",
"type":"array",
"items":{
"type":"integer",
"minimum":1,
"maximum":500
},
"minItems":1,
"maxItems":500
},
"name":{
"enum":[
"start"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"$schema":{
"enum":[
"ogg:command"
]
},
"skipTransaction":{
"description":"Causes Replicat to skip the first transaction after its expected startup position in the trail. All operations from that first transaction are excluded.",
"type":"boolean",
"default":false
},
"filterDuplicates":{
"description":"Causes Replicat to ignore transactions that it has already processed. Use when Extract was repositioned to a new start point (using the ATCSN or AFTERCSN) and you are confident that there are duplicate transactions in the trail that could cause Replicat to abend. This option requires the use of a checkpoint table. If the database is Oracle, this option is valid only for Replicat in nonintegrated mode. Integrated mode handles duplicate transactions transparently. The default is true.",
"type":"boolean",
"default":true
},
"at":{
"description":"Directs Extract/Replicat to position its start point at the transaction that has the specified CSN. Any transactions in the data source that have CSN values less than the specified one are skipped.",
"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
}
]
}
},
"additionalProperties":false,
"allOf":[
{
"required":[
"name",
"processName"
]
},
{
"not":{
"required":[
"at",
"after"
]
}
},
{
"not":{
"required":[
"at",
"skipTransaction"
]
}
},
{
"not":{
"required":[
"after",
"skipTransaction"
]
}
},
{
"dependencies":{
"filterDuplicates":{
"properties":{
"processType":{
"enum":[
"replicat",
"ER"
]
}
}
},
"threads":{
"properties":{
"processType":{
"enum":[
"replicat",
"ER"
]
}
}
}
}
},
{
"x-anyOf":[
{
"dependencies":{
"threads":[
"at"
]
}
},
{
"dependencies":{
"threads":[
"after"
]
}
},
{
"dependencies":{
"threads":[
"skipTransaction"
]
}
}
]
}
]
},
{
"description":"Stop an Extract or Replicat",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"stop"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"force":{
"type":"boolean",
"default":false
}
},
"required":[
"name",
"processName"
],
"additionalProperties":false
},
{
"description":"Kill an Extract or Replicat",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"kill"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
}
},
"required":[
"name",
"processName"
],
"additionalProperties":false
},
{
"description":"Execute an Extract or Replicat",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"execute"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"processName":{
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
}
},
"required":[
"name",
"processName"
],
"additionalProperties":false
},
{
"description":"Synchronize a Replicat",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"synchronize"
]
},
"processType":{
"enum":[
"replicat"
]
},
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
}
},
"required":[
"name",
"processName"
],
"additionalProperties":false
},
{
"description":"Execute the Monitor Agent",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"execute"
]
},
"processName":{
"enum":[
"Monitor Agent"
]
}
},
"required":[
"name",
"processName"
],
"additionalProperties":false
},
{
"description":"Report on Processes",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"up",
"down"
]
}
},
"required":[
"name",
"reportType"
],
"additionalProperties":false
},
{
"description":"Report on Process Lag",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"lag"
]
},
"thresholds":{
"type":"array",
"items":{
"type":"object",
"properties":{
"type":{
"enum":[
"info",
"critical"
]
},
"units":{
"x-oneOf":[
{
"enum":[
"seconds"
]
},
{
"enum":[
"minutes"
]
},
{
"enum":[
"hours"
]
}
]
},
"value":{
"type":"integer",
"minimum":0,
"maximum":65535
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":2
}
},
"required":[
"name",
"reportType",
"thresholds"
],
"additionalProperties":false
},
{
"description":"Report Operating System and database version information",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"versions"
]
},
"credentials":{
"description":"Credentials for 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"
}
]
}
},
"required":[
"name",
"reportType"
],
"additionalProperties":false
},
{
"description":"Lists the schemas in the database with names that match the input specification",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"schemas"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"specification":{
"description":"The name of a schema which can include wildcard characters",
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":3,
"maxLength":261
}
]
}
},
"required":[
"name",
"reportType",
"credentials",
"specification"
],
"additionalProperties":false
},
{
"description":"Lists the tables in the database with names that match the input specification",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"tables"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"specification":{
"description":"The name of a table or a group of tables which can include wildcard characters",
"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
}
]
}
},
"required":[
"name",
"reportType",
"credentials",
"specification"
],
"additionalProperties":false
},
{
"description":"Lists the checkpoint tables in the database with names that match the input specification",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"checkpointTables"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"specification":{
"description":"The name of a checkpoint table or a group of checkpoint tables which can include wildcard characters",
"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
}
]
}
},
"required":[
"name",
"reportType",
"credentials",
"specification"
],
"additionalProperties":false
},
{
"description":"Lists the containers in the database with names that match the input specification",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"containers"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"specification":{
"description":"The name of a container or a group of containers which can include wildcard characters",
"type":"string",
"pattern":"^([^.\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
}
},
"required":[
"name",
"reportType",
"credentials",
"specification"
],
"additionalProperties":false
},
{
"description":"Purge checkpoint history for ER processes",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"purge"
]
},
"purgeType":{
"enum":[
"checkpoints"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"keep":{
"type":"array",
"items":{
"type":"object",
"properties":{
"type":{
"enum":[
"max"
]
},
"units":{
"x-oneOf":[
{
"enum":[
"checkpoints"
]
}
]
},
"value":{
"type":"integer",
"minimum":1,
"maximum":500
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":1
}
},
"required":[
"name",
"purgeType",
"processName",
"keep"
],
"additionalProperties":false
},
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"purge"
]
},
"purgeType":{
"enum":[
"ddlHistory",
"ddlHistoryAlt",
"markerHistory"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"keep":{
"type":"array",
"items":{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Maximum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"max"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Maximum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"max"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":2
}
},
"required":[
"name",
"purgeType",
"credentials",
"keep"
],
"additionalProperties":false
},
{
"description":"Purge trail files no longer needed",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"purge"
]
},
"purgeType":{
"enum":[
"trails"
]
},
"trails":{
"description":"Trails to purge",
"type":"array",
"items":{
"type":"object",
"properties":{
"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
}
},
"required":[
"name"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":1024
},
"useCheckpoints":{
"type":"boolean",
"default":true
},
"keep":{
"type":"array",
"items":{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of files",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"files"
]
},
"value":{
"type":"integer",
"minimum":0,
"maximum":100
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":1
}
},
"required":[
"name",
"purgeType",
"trails",
"keep"
],
"additionalProperties":false
},
{
"description":"Purge Extract or Replicat tasks",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"purge"
]
},
"purgeType":{
"enum":[
"tasks"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"useStatus":{
"type":"boolean",
"default":false
},
"keep":{
"type":"array",
"items":{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":1
}
},
"required":[
"name",
"purgeType",
"processName",
"keep"
],
"additionalProperties":false
},
{
"description":"Purge files no longer needed",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"purge"
]
},
"purgeType":{
"enum":[
"files"
]
},
"dumpFiles":{
"description":"Purge dump files (*.dmp) which are generated when an application abnormally terminates",
"type":"boolean",
"default":false
},
"keep":{
"type":"array",
"items":{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":1
}
},
"required":[
"name",
"purgeType",
"keep"
],
"additionalProperties":false
},
{
"description":"Updates a database sequence so that initial redo records are available at the time that Extract starts capturing transaction data after the instantiation of the replication environment.",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"flushSequence"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"sequence":{
"description":"The owner and name of a database sequence. The schema name cannot be null. You can use wildcard characters for the sequence name but not for the owner name.",
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
},
{
"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
}
]
},
"trace":{
"description":"Whether to call the sql procedure to update the sequence with tracing mode on",
"type":"boolean",
"default":false
}
},
"required":[
"name",
"credentials",
"sequence"
],
"additionalProperties":false
}
]
}
ネストされたスキーマ: restart
型: object
タスクが終了した場合に再起動方法を制御します
ソースの表示
{
"description":"Control how the task is restarted if it terminates",
"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":120,
"maximum":3600
},
"retries":{
"description":"The maximum number of times the task should be restarted before aborting retry efforts.",
"type":"integer",
"minimum":0,
"default":2,
"maximum":3600
},
"window":{
"description":"The window of time, in seconds, during which retries are counted. The default is 7200 seconds (2 hours).",
"type":"integer",
"minimum":0,
"default":7200,
"maximum":604800
},
"disableOnFailure":{
"description":"If true, the task is disabled when it fails all execution attempts in an execution window.",
"type":"boolean",
"default":false
},
"failures":{
"description":"The number of times the task failed in the current window.",
"type":"integer",
"minimum":0,
"maximum":3600
}
},
"additionalProperties":false
}
ネストされたスキーマ: schedule
1つに一致
ソースの表示
{
"x-oneOf":[
{
"description":"Task is not scheduled",
"enum":[
"none"
]
},
{
"description":"Task is run on a time-based schedule",
"type":"object",
"properties":{
"days":{
"description":"Days of the week to run the task",
"x-oneOf":[
{
"enum":[
"every"
]
},
{
"enum":[
"Sunday",
"Monday",
"Tuesday",
"Wednesday",
"Thursday",
"Friday",
"Saturday"
]
},
{
"type":"array",
"items":{
"enum":[
"Sunday",
"Monday",
"Tuesday",
"Wednesday",
"Thursday",
"Friday",
"Saturday"
]
},
"minItems":1,
"maxItems":7
}
]
},
"times":{
"description":"Array of times to run task in 24 hour format HH:MM",
"type":"array",
"items":{
"type":"string",
"pattern":"([01][0-9]|2[0-3]):[0-5][0-9]",
"minLength":5,
"maxLength":5
},
"minItems":1,
"maxItems":1440
}
},
"required":[
"days",
"times"
],
"additionalProperties":false
},
{
"description":"Task is run on an interval",
"type":"object",
"properties":{
"every":{
"type":"object",
"properties":{
"units":{
"x-oneOf":[
{
"enum":[
"minutes"
]
},
{
"enum":[
"hours"
]
},
{
"enum":[
"days"
]
},
{
"enum":[
"weeks"
]
}
]
},
"value":{
"type":"integer",
"minimum":0,
"maximum":1024
}
},
"required":[
"units",
"value"
],
"additionalProperties":false
}
},
"required":[
"every"
],
"additionalProperties":false
},
{
"description":"Task is run when the Admin Server starts",
"type":"object",
"properties":{
"autoStart":{
"description":"Indicates task starts with Admin Server",
"enum":[
true
]
},
"delay":{
"description":"Time to wait in seconds before starting task",
"type":"integer",
"minimum":0,
"default":0,
"maximum":3600
}
},
"required":[
"autoStart"
],
"additionalProperties":false
}
]
}
ネストされたスキーマ: command-x-oneOf[0]
型: object
ExtractまたはReplicatの起動
ソースの表示
{
"description":"Start an Extract or Replicat",
"type":"object",
"properties":{
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"after":{
"description":"Directs Extract/Replicat to position its start point at the beginning of the first transaction after the one that has the specified CSN. Any transactions in the data source that have CSN values that are less than, or equal to, the specified one are skipped.",
"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
}
]
},
"threads":{
"description":"Valid when used with 'skipTransaction', 'at', or 'after' with Replicat in coordinated mode. Starts the specified Replicat thread or threads at the specified location.",
"type":"array",
"items":{
"type":"integer",
"minimum":1,
"maximum":500
},
"minItems":1,
"maxItems":500
},
"name":{
"enum":[
"start"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"$schema":{
"enum":[
"ogg:command"
]
},
"skipTransaction":{
"description":"Causes Replicat to skip the first transaction after its expected startup position in the trail. All operations from that first transaction are excluded.",
"type":"boolean",
"default":false
},
"filterDuplicates":{
"description":"Causes Replicat to ignore transactions that it has already processed. Use when Extract was repositioned to a new start point (using the ATCSN or AFTERCSN) and you are confident that there are duplicate transactions in the trail that could cause Replicat to abend. This option requires the use of a checkpoint table. If the database is Oracle, this option is valid only for Replicat in nonintegrated mode. Integrated mode handles duplicate transactions transparently. The default is true.",
"type":"boolean",
"default":true
},
"at":{
"description":"Directs Extract/Replicat to position its start point at the transaction that has the specified CSN. Any transactions in the data source that have CSN values less than the specified one are skipped.",
"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
}
]
}
},
"additionalProperties":false,
"allOf":[
{
"required":[
"name",
"processName"
]
},
{
"not":{
"required":[
"at",
"after"
]
}
},
{
"not":{
"required":[
"at",
"skipTransaction"
]
}
},
{
"not":{
"required":[
"after",
"skipTransaction"
]
}
},
{
"dependencies":{
"filterDuplicates":{
"properties":{
"processType":{
"enum":[
"replicat",
"ER"
]
}
}
},
"threads":{
"properties":{
"processType":{
"enum":[
"replicat",
"ER"
]
}
}
}
}
},
{
"x-anyOf":[
{
"dependencies":{
"threads":[
"at"
]
}
},
{
"dependencies":{
"threads":[
"after"
]
}
},
{
"dependencies":{
"threads":[
"skipTransaction"
]
}
}
]
}
]
}
すべてに一致
ソースの表示
{
"description":"Start an Extract or Replicat",
"type":"object",
"properties":{
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"after":{
"description":"Directs Extract/Replicat to position its start point at the beginning of the first transaction after the one that has the specified CSN. Any transactions in the data source that have CSN values that are less than, or equal to, the specified one are skipped.",
"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
}
]
},
"threads":{
"description":"Valid when used with 'skipTransaction', 'at', or 'after' with Replicat in coordinated mode. Starts the specified Replicat thread or threads at the specified location.",
"type":"array",
"items":{
"type":"integer",
"minimum":1,
"maximum":500
},
"minItems":1,
"maxItems":500
},
"name":{
"enum":[
"start"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"$schema":{
"enum":[
"ogg:command"
]
},
"skipTransaction":{
"description":"Causes Replicat to skip the first transaction after its expected startup position in the trail. All operations from that first transaction are excluded.",
"type":"boolean",
"default":false
},
"filterDuplicates":{
"description":"Causes Replicat to ignore transactions that it has already processed. Use when Extract was repositioned to a new start point (using the ATCSN or AFTERCSN) and you are confident that there are duplicate transactions in the trail that could cause Replicat to abend. This option requires the use of a checkpoint table. If the database is Oracle, this option is valid only for Replicat in nonintegrated mode. Integrated mode handles duplicate transactions transparently. The default is true.",
"type":"boolean",
"default":true
},
"at":{
"description":"Directs Extract/Replicat to position its start point at the transaction that has the specified CSN. Any transactions in the data source that have CSN values less than the specified one are skipped.",
"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
}
]
}
},
"additionalProperties":false,
"allOf":[
{
"required":[
"name",
"processName"
]
},
{
"not":{
"required":[
"at",
"after"
]
}
},
{
"not":{
"required":[
"at",
"skipTransaction"
]
}
},
{
"not":{
"required":[
"after",
"skipTransaction"
]
}
},
{
"dependencies":{
"filterDuplicates":{
"properties":{
"processType":{
"enum":[
"replicat",
"ER"
]
}
}
},
"threads":{
"properties":{
"processType":{
"enum":[
"replicat",
"ER"
]
}
}
}
}
},
{
"x-anyOf":[
{
"dependencies":{
"threads":[
"at"
]
}
},
{
"dependencies":{
"threads":[
"after"
]
}
},
{
"dependencies":{
"threads":[
"skipTransaction"
]
}
}
]
}
]
}
ネストされたスキーマ: command-x-oneOf[1]
型: object
ExtractまたはReplicatの停止
ソースの表示
{
"description":"Stop an Extract or Replicat",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"stop"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"force":{
"type":"boolean",
"default":false
}
},
"required":[
"name",
"processName"
],
"additionalProperties":false
}
ネストされたスキーマ: command-x-oneOf[2]
型: object
ExtractまたはReplicatの中止
ソースの表示
{
"description":"Kill an Extract or Replicat",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"kill"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
}
},
"required":[
"name",
"processName"
],
"additionalProperties":false
}
ネストされたスキーマ: command-x-oneOf[3]
型: object
ExtractまたはReplicatの実行
ソースの表示
{
"description":"Execute an Extract or Replicat",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"execute"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"processName":{
"type":"string",
"pattern":"^[A-Z_$][A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
}
},
"required":[
"name",
"processName"
],
"additionalProperties":false
}
ネストされたスキーマ: command-x-oneOf[4]
型: object
Replicatの同期
ソースの表示
{
"description":"Synchronize a Replicat",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"synchronize"
]
},
"processType":{
"enum":[
"replicat"
]
},
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
}
},
"required":[
"name",
"processName"
],
"additionalProperties":false
}
ネストされたスキーマ: command-x-oneOf[5]
型: object
モニター・エージェントの実行
ソースの表示
{
"description":"Execute the Monitor Agent",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"execute"
]
},
"processName":{
"enum":[
"Monitor Agent"
]
}
},
"required":[
"name",
"processName"
],
"additionalProperties":false
}
ネストされたスキーマ: command-x-oneOf[6]
型: object
プロセスのレポート
ソースの表示
{
"description":"Report on Processes",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"up",
"down"
]
}
},
"required":[
"name",
"reportType"
],
"additionalProperties":false
}
ネストされたスキーマ: command-x-oneOf[7]
型: object
プロセス・ラグのレポート
ソースの表示
{
"description":"Report on Process Lag",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"lag"
]
},
"thresholds":{
"type":"array",
"items":{
"type":"object",
"properties":{
"type":{
"enum":[
"info",
"critical"
]
},
"units":{
"x-oneOf":[
{
"enum":[
"seconds"
]
},
{
"enum":[
"minutes"
]
},
{
"enum":[
"hours"
]
}
]
},
"value":{
"type":"integer",
"minimum":0,
"maximum":65535
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":2
}
},
"required":[
"name",
"reportType",
"thresholds"
],
"additionalProperties":false
}
ネストされたスキーマ: command-x-oneOf[8]
型: object
オペレーティング・システムとデータベース・バージョン情報のレポート
ソースの表示
{
"description":"Report Operating System and database version information",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"versions"
]
},
"credentials":{
"description":"Credentials for 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"
}
]
}
},
"required":[
"name",
"reportType"
],
"additionalProperties":false
}
ネストされたスキーマ: command-x-oneOf[9]
型: object
名前が入力指定に一致するデータベース内のスキーマをリストします
ソースの表示
{
"description":"Lists the schemas in the database with names that match the input specification",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"schemas"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"specification":{
"description":"The name of a schema which can include wildcard characters",
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":3,
"maxLength":261
}
]
}
},
"required":[
"name",
"reportType",
"credentials",
"specification"
],
"additionalProperties":false
}
ネストされたスキーマ: command-x-oneOf[10]
型: object
名前が入力指定に一致するデータベース内の表をリストします
ソースの表示
{
"description":"Lists the tables in the database with names that match the input specification",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"tables"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"specification":{
"description":"The name of a table or a group of tables which can include wildcard characters",
"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
}
]
}
},
"required":[
"name",
"reportType",
"credentials",
"specification"
],
"additionalProperties":false
}
ネストされたスキーマ: command-x-oneOf[11]
型: object
名前が入力指定に一致するデータベース内のチェックポイント表をリストします
ソースの表示
{
"description":"Lists the checkpoint tables in the database with names that match the input specification",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"checkpointTables"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"specification":{
"description":"The name of a checkpoint table or a group of checkpoint tables which can include wildcard characters",
"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
}
]
}
},
"required":[
"name",
"reportType",
"credentials",
"specification"
],
"additionalProperties":false
}
ネストされたスキーマ: command-x-oneOf[12]
型: object
名前が入力指定に一致するデータベース内のコンテナをリストします
ソースの表示
{
"description":"Lists the containers in the database with names that match the input specification",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"report"
]
},
"reportType":{
"enum":[
"containers"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"specification":{
"description":"The name of a container or a group of containers which can include wildcard characters",
"type":"string",
"pattern":"^([^.\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
}
},
"required":[
"name",
"reportType",
"credentials",
"specification"
],
"additionalProperties":false
}
ネストされたスキーマ: command-x-oneOf[13]
型: object
ERプロセスのチェックポイント履歴をパージします
ソースの表示
{
"description":"Purge checkpoint history for ER processes",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"purge"
]
},
"purgeType":{
"enum":[
"checkpoints"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"keep":{
"type":"array",
"items":{
"type":"object",
"properties":{
"type":{
"enum":[
"max"
]
},
"units":{
"x-oneOf":[
{
"enum":[
"checkpoints"
]
}
]
},
"value":{
"type":"integer",
"minimum":1,
"maximum":500
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":1
}
},
"required":[
"name",
"purgeType",
"processName",
"keep"
],
"additionalProperties":false
}
ネストされたスキーマ: command-x-oneOf[14]
型: object
ソースの表示
{
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"purge"
]
},
"purgeType":{
"enum":[
"ddlHistory",
"ddlHistoryAlt",
"markerHistory"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"keep":{
"type":"array",
"items":{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Maximum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"max"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Maximum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"max"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":2
}
},
"required":[
"name",
"purgeType",
"credentials",
"keep"
],
"additionalProperties":false
}
ネストされたスキーマ: command-x-oneOf[15]
型: object
不要になったトレイル・ファイルをパージします
ソースの表示
{
"description":"Purge trail files no longer needed",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"purge"
]
},
"purgeType":{
"enum":[
"trails"
]
},
"trails":{
"description":"Trails to purge",
"type":"array",
"items":{
"type":"object",
"properties":{
"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
}
},
"required":[
"name"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":1024
},
"useCheckpoints":{
"type":"boolean",
"default":true
},
"keep":{
"type":"array",
"items":{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of files",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"files"
]
},
"value":{
"type":"integer",
"minimum":0,
"maximum":100
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":1
}
},
"required":[
"name",
"purgeType",
"trails",
"keep"
],
"additionalProperties":false
}
ネストされたスキーマ: command-x-oneOf[16]
型: object
ExtractまたはReplicatのタスクをパージします
ソースの表示
{
"description":"Purge Extract or Replicat tasks",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"purge"
]
},
"purgeType":{
"enum":[
"tasks"
]
},
"processType":{
"enum":[
"extract",
"replicat",
"ER"
],
"default":"ER"
},
"processName":{
"type":"string",
"pattern":"^[*A-Z_$][*A-Z0-9_$]*$",
"minLength":1,
"maxLength":8
},
"useStatus":{
"type":"boolean",
"default":false
},
"keep":{
"type":"array",
"items":{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":1
}
},
"required":[
"name",
"purgeType",
"processName",
"keep"
],
"additionalProperties":false
}
ネストされたスキーマ: command-x-oneOf[17]
型: object
不要になったファイルをパージします
ソースの表示
{
"description":"Purge files no longer needed",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"purge"
]
},
"purgeType":{
"enum":[
"files"
]
},
"dumpFiles":{
"description":"Purge dump files (*.dmp) which are generated when an application abnormally terminates",
"type":"boolean",
"default":false
},
"keep":{
"type":"array",
"items":{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":1
}
},
"required":[
"name",
"purgeType",
"keep"
],
"additionalProperties":false
}
ネストされたスキーマ: command-x-oneOf[18]
型: object
レプリケーション環境のインストール後、Extractがトランザクション・データの取得を開始した時点で初期REDOレコードが使用可能になるように、データベース順序を更新します。
ソースの表示
{
"description":"Updates a database sequence so that initial redo records are available at the time that Extract starts capturing transaction data after the instantiation of the replication environment.",
"type":"object",
"properties":{
"$schema":{
"enum":[
"ogg:command"
]
},
"name":{
"enum":[
"flushSequence"
]
},
"credentials":{
"description":"Credentials for database",
"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
},
"sequence":{
"description":"The owner and name of a database sequence. The schema name cannot be null. You can use wildcard characters for the sequence name but not for the owner name.",
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
},
{
"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
}
]
},
"trace":{
"description":"Whether to call the sql procedure to update the sequence with tracing mode on",
"type":"boolean",
"default":false
}
},
"required":[
"name",
"credentials",
"sequence"
],
"additionalProperties":false
}
ネストされたスキーマ: after
ExtractまたはReplicatに、指定したCSNを持つトランザクションの後の最初のトランザクションの先頭に開始位置を配置するように指示します。指定したCSN以下のCSN値が含まれているデータ・ソース内のトランザクションは、すべてスキップされます。
1つに一致
ソースの表示
- integer
最小値: 1
最大値: 9.223372036854776E18
標準の形式
- string
最小長: 3
最大長: 64
パターン: [0-9]+[.][0-9]+
代替の形式
{
"description":"Directs Extract/Replicat to position its start point at the beginning of the first transaction after the one that has the specified CSN. Any transactions in the data source that have CSN values that are less than, or equal to, the specified one are skipped.",
"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
}
]
}
ネストされたスキーマ: at
ExtractまたはReplicatに、指定したCSNを持つトランザクションに開始位置を配置するように指示します。指定したCSNより小さいCSN値を持つデータ・ソース内のトランザクションはすべてスキップされます。
1つに一致
ソースの表示
- integer
最小値: 1
最大値: 9.223372036854776E18
標準の形式
- string
最小長: 3
最大長: 64
パターン: [0-9]+[.][0-9]+
代替の形式
{
"description":"Directs Extract/Replicat to position its start point at the transaction that has the specified CSN. Any transactions in the data source that have CSN values less than the specified one are skipped.",
"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
}
]
}
ネストされたスキーマ: threads
型: array
最小アイテム数: 1
最大アイテム数: 500
調整モードのReplicatでskipTransaction、atまたはafterと一緒に使用した場合に有効です。指定したReplicatスレッドを指定した場所で開始します。
ソースの表示
{
"description":"Valid when used with 'skipTransaction', 'at', or 'after' with Replicat in coordinated mode. Starts the specified Replicat thread or threads at the specified location.",
"type":"array",
"items":{
"type":"integer",
"minimum":1,
"maximum":500
},
"minItems":1,
"maxItems":500
}
ネストされたスキーマ: command-x-oneOf[0]-allOf[5]
いずれかに一致
ソースの表示
{
"x-anyOf":[
{
"dependencies":{
"threads":[
"at"
]
}
},
{
"dependencies":{
"threads":[
"after"
]
}
},
{
"dependencies":{
"threads":[
"skipTransaction"
]
}
}
]
}
ネストされたスキーマ: thresholds
型: array
最小アイテム数: 1
最大アイテム数: 2
ソースの表示
{
"type":"array",
"items":{
"type":"object",
"properties":{
"type":{
"enum":[
"info",
"critical"
]
},
"units":{
"x-oneOf":[
{
"enum":[
"seconds"
]
},
{
"enum":[
"minutes"
]
},
{
"enum":[
"hours"
]
}
]
},
"value":{
"type":"integer",
"minimum":0,
"maximum":65535
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":2
}
ネストされたスキーマ: items
型: object
ソースの表示
{
"type":"object",
"properties":{
"type":{
"enum":[
"info",
"critical"
]
},
"units":{
"x-oneOf":[
{
"enum":[
"seconds"
]
},
{
"enum":[
"minutes"
]
},
{
"enum":[
"hours"
]
}
]
},
"value":{
"type":"integer",
"minimum":0,
"maximum":65535
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
ネストされたスキーマ: units
1つに一致
ソースの表示
{
"x-oneOf":[
{
"enum":[
"seconds"
]
},
{
"enum":[
"minutes"
]
},
{
"enum":[
"hours"
]
}
]
}
ネストされたスキーマ: credentials
データベースの資格証明
デフォルト値: oracle.doceng.json.BetterJsonNull@247d44b4
1つに一致
ソースの表示
{
"description":"Credentials for 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"
}
]
}
ネストされたスキーマ: 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
}
ネストされたスキーマ: credentials
型: object
データベースの資格証明
ソースの表示
{
"description":"Credentials for database",
"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
}
ネストされたスキーマ: specification
スキーマ名(ワイルドカード文字を含むことができる)
いずれかに一致
ソースの表示
- string
最小長: 1
最大長: 130
パターン: ^([^."]{1,128}|["].{1,128}["])$
- string
最小長: 3
最大長: 261
パターン: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
{
"description":"The name of a schema which can include wildcard characters",
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
},
{
"type":"string",
"pattern":"^([^.*?\"]{1,128}|[\"].{1,128}[\"])[.]([^.\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":3,
"maxLength":261
}
]
}
ネストされたスキーマ: credentials
型: object
データベースの資格証明
ソースの表示
{
"description":"Credentials for database",
"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
}
ネストされたスキーマ: specification
1つの表または一連の表の名前(ワイルドカード文字を含むことができる)
いずれかに一致
ソースの表示
- string
最小長: 3
最大長: 261
パターン: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
- string
最小長: 5
最大長: 392
パターン: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
{
"description":"The name of a table or a group of tables which can include wildcard characters",
"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
}
]
}
ネストされたスキーマ: credentials
型: object
データベースの資格証明
ソースの表示
{
"description":"Credentials for database",
"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
}
ネストされたスキーマ: specification
1つのチェックポイント表または一連のチェックポイント表の名前(ワイルドカード文字を含むことができる)
いずれかに一致
ソースの表示
- string
最小長: 3
最大長: 261
パターン: ^([^."]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
- string
最小長: 5
最大長: 392
パターン: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
{
"description":"The name of a checkpoint table or a group of checkpoint tables which can include wildcard characters",
"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
}
]
}
ネストされたスキーマ: credentials
型: object
データベースの資格証明
ソースの表示
{
"description":"Credentials for database",
"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
}
ネストされたスキーマ: keep
型: array
最小アイテム数: 1
最大アイテム数: 1
ソースの表示
{
"type":"array",
"items":{
"type":"object",
"properties":{
"type":{
"enum":[
"max"
]
},
"units":{
"x-oneOf":[
{
"enum":[
"checkpoints"
]
}
]
},
"value":{
"type":"integer",
"minimum":1,
"maximum":500
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":1
}
ネストされたスキーマ: items
型: object
ソースの表示
{
"type":"object",
"properties":{
"type":{
"enum":[
"max"
]
},
"units":{
"x-oneOf":[
{
"enum":[
"checkpoints"
]
}
]
},
"value":{
"type":"integer",
"minimum":1,
"maximum":500
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
ネストされたスキーマ: units
1つに一致
ソースの表示
-
指定できる値: [ "checkpoints" ]
{
"x-oneOf":[
{
"enum":[
"checkpoints"
]
}
]
}
ネストされたスキーマ: credentials
型: object
データベースの資格証明
ソースの表示
{
"description":"Credentials for database",
"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
}
ネストされたスキーマ: keep
型: array
最小アイテム数: 1
最大アイテム数: 2
ソースの表示
{
"type":"array",
"items":{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Maximum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"max"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Maximum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"max"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":2
}
ネストされたスキーマ: items
1つに一致
ソースの表示
{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Maximum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"max"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Maximum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"max"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
}
ネストされたスキーマ: items-x-oneOf[0]
型: object
最短時間数
ソースの表示
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
ネストされたスキーマ: items-x-oneOf[1]
型: object
最長時間数
ソースの表示
{
"description":"Maximum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"max"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
ネストされたスキーマ: items-x-oneOf[2]
型: object
最短日数
ソースの表示
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
ネストされたスキーマ: items-x-oneOf[3]
型: object
最長日数
ソースの表示
{
"description":"Maximum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"max"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
ネストされたスキーマ: keep
型: array
最小アイテム数: 1
最大アイテム数: 1
ソースの表示
{
"type":"array",
"items":{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of files",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"files"
]
},
"value":{
"type":"integer",
"minimum":0,
"maximum":100
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":1
}
ネストされたスキーマ: trails
型: array
最小アイテム数: 1
最大アイテム数: 1024
パージするトレイル
ソースの表示
{
"description":"Trails to purge",
"type":"array",
"items":{
"type":"object",
"properties":{
"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
}
},
"required":[
"name"
],
"additionalProperties":false
},
"minItems":1,
"maxItems":1024
}
ネストされたスキーマ: items
1つに一致
ソースの表示
{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of files",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"files"
]
},
"value":{
"type":"integer",
"minimum":0,
"maximum":100
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
}
ネストされたスキーマ: items-x-oneOf[0]
型: object
最短時間数
ソースの表示
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
ネストされたスキーマ: items-x-oneOf[1]
型: object
最短日数
ソースの表示
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
ネストされたスキーマ: items-x-oneOf[2]
型: object
最小ファイル数
ソースの表示
{
"description":"Minimum number of files",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"files"
]
},
"value":{
"type":"integer",
"minimum":0,
"maximum":100
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
ネストされたスキーマ: items
型: object
ソースの表示
{
"type":"object",
"properties":{
"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
}
},
"required":[
"name"
],
"additionalProperties":false
}
ネストされたスキーマ: keep
型: array
最小アイテム数: 1
最大アイテム数: 1
ソースの表示
{
"type":"array",
"items":{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":1
}
ネストされたスキーマ: items
1つに一致
ソースの表示
{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
}
ネストされたスキーマ: items-x-oneOf[0]
型: object
最短時間数
ソースの表示
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
ネストされたスキーマ: items-x-oneOf[1]
型: object
最短日数
ソースの表示
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
ネストされたスキーマ: keep
型: array
最小アイテム数: 1
最大アイテム数: 1
ソースの表示
{
"type":"array",
"items":{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
},
"minItems":1,
"maxItems":1
}
ネストされたスキーマ: items
1つに一致
ソースの表示
{
"x-oneOf":[
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
},
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
]
}
ネストされたスキーマ: items-x-oneOf[0]
型: object
最短時間数
ソースの表示
{
"description":"Minimum number of hours",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"hours"
]
},
"value":{
"description":"Allowed value for hours value",
"type":"integer",
"minimum":1,
"maximum":1000
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
ネストされたスキーマ: items-x-oneOf[1]
型: object
最短日数
ソースの表示
{
"description":"Minimum number of days",
"type":"object",
"properties":{
"type":{
"enum":[
"min"
]
},
"units":{
"enum":[
"days"
]
},
"value":{
"description":"Allowed value for days value",
"type":"integer",
"minimum":1,
"maximum":365
}
},
"required":[
"type",
"units",
"value"
],
"additionalProperties":false
}
ネストされたスキーマ: credentials
型: object
データベースの資格証明
ソースの表示
{
"description":"Credentials for database",
"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
}
ネストされたスキーマ: sequence
データベース順序の所有者および名前。スキーマ名はNULLにすることはできません。順序名にはワイルドカード文字を使用できますが、所有者名には使用できません。
いずれかに一致
ソースの表示
- string
最小長: 1
最大長: 130
パターン: ^([^."]{1,128}|["].{1,128}["])$
- string
最小長: 3
最大長: 261
パターン: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
- string
最小長: 5
最大長: 392
パターン: ^([^.*?"]{1,128}|["].{1,128}["])[.]([^.*?"]{1,128}|["].{1,128}["])[.]([^."]{1,128}|["].{1,128}["])$
{
"description":"The owner and name of a database sequence. The schema name cannot be null. You can use wildcard characters for the sequence name but not for the owner name.",
"x-anyOf":[
{
"type":"string",
"pattern":"^([^.\"]{1,128}|[\"].{1,128}[\"])$",
"minLength":1,
"maxLength":130
},
{
"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
}
]
}
ネストされたスキーマ: schedule-x-oneOf[1]
型: object
タスクは時間ベースのスケジュールで実行されます
ソースの表示
{
"description":"Task is run on a time-based schedule",
"type":"object",
"properties":{
"days":{
"description":"Days of the week to run the task",
"x-oneOf":[
{
"enum":[
"every"
]
},
{
"enum":[
"Sunday",
"Monday",
"Tuesday",
"Wednesday",
"Thursday",
"Friday",
"Saturday"
]
},
{
"type":"array",
"items":{
"enum":[
"Sunday",
"Monday",
"Tuesday",
"Wednesday",
"Thursday",
"Friday",
"Saturday"
]
},
"minItems":1,
"maxItems":7
}
]
},
"times":{
"description":"Array of times to run task in 24 hour format HH:MM",
"type":"array",
"items":{
"type":"string",
"pattern":"([01][0-9]|2[0-3]):[0-5][0-9]",
"minLength":5,
"maxLength":5
},
"minItems":1,
"maxItems":1440
}
},
"required":[
"days",
"times"
],
"additionalProperties":false
}
ネストされたスキーマ: schedule-x-oneOf[2]
型: object
タスクは一定の間隔で実行されます
ソースの表示
{
"description":"Task is run on an interval",
"type":"object",
"properties":{
"every":{
"type":"object",
"properties":{
"units":{
"x-oneOf":[
{
"enum":[
"minutes"
]
},
{
"enum":[
"hours"
]
},
{
"enum":[
"days"
]
},
{
"enum":[
"weeks"
]
}
]
},
"value":{
"type":"integer",
"minimum":0,
"maximum":1024
}
},
"required":[
"units",
"value"
],
"additionalProperties":false
}
},
"required":[
"every"
],
"additionalProperties":false
}
ネストされたスキーマ: schedule-x-oneOf[3]
型: object
タスクはAdmin Serverの起動時に実行されます
ソースの表示
{
"description":"Task is run when the Admin Server starts",
"type":"object",
"properties":{
"autoStart":{
"description":"Indicates task starts with Admin Server",
"enum":[
true
]
},
"delay":{
"description":"Time to wait in seconds before starting task",
"type":"integer",
"minimum":0,
"default":0,
"maximum":3600
}
},
"required":[
"autoStart"
],
"additionalProperties":false
}
ネストされたスキーマ: days
タスクを実行する曜日
1つに一致
ソースの表示
-
-
指定できる値: [ "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday" ]
- array days-x-oneOf[2]
{
"description":"Days of the week to run the task",
"x-oneOf":[
{
"enum":[
"every"
]
},
{
"enum":[
"Sunday",
"Monday",
"Tuesday",
"Wednesday",
"Thursday",
"Friday",
"Saturday"
]
},
{
"type":"array",
"items":{
"enum":[
"Sunday",
"Monday",
"Tuesday",
"Wednesday",
"Thursday",
"Friday",
"Saturday"
]
},
"minItems":1,
"maxItems":7
}
]
}
ネストされたスキーマ: times
型: array
最小アイテム数: 1
最大アイテム数: 1440
タスクを実行する時刻の配列(24時間形式のHH:MM)
ソースの表示
- 配列: string
最小長: 5
最大長: 5
パターン: ([01][0-9]|2[0-3]):[0-5][0-9]
{
"description":"Array of times to run task in 24 hour format HH:MM",
"type":"array",
"items":{
"type":"string",
"pattern":"([01][0-9]|2[0-3]):[0-5][0-9]",
"minLength":5,
"maxLength":5
},
"minItems":1,
"maxItems":1440
}
ネストされたスキーマ: days-x-oneOf[2]
型: array
最小アイテム数: 1
最大アイテム数: 7
ソースの表示
- 配列:
指定できる値: [ "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday" ]
{
"type":"array",
"items":{
"enum":[
"Sunday",
"Monday",
"Tuesday",
"Wednesday",
"Thursday",
"Friday",
"Saturday"
]
},
"minItems":1,
"maxItems":7
}
ネストされたスキーマ: every
型: object
ソースの表示
{
"type":"object",
"properties":{
"units":{
"x-oneOf":[
{
"enum":[
"minutes"
]
},
{
"enum":[
"hours"
]
},
{
"enum":[
"days"
]
},
{
"enum":[
"weeks"
]
}
]
},
"value":{
"type":"integer",
"minimum":0,
"maximum":1024
}
},
"required":[
"units",
"value"
],
"additionalProperties":false
}
ネストされたスキーマ: units
1つに一致
ソースの表示
{
"x-oneOf":[
{
"enum":[
"minutes"
]
},
{
"enum":[
"hours"
]
},
{
"enum":[
"days"
]
},
{
"enum":[
"weeks"
]
}
]
}