Oracle GoldenGate REST API 21c (21.1.0)

既存の出力トレイル・ファイル統計の取得

get

/services/{version}/mpoints/{item}/trailOutput

リクエスト

パス・パラメータ

item: string

最小長: 1

最大長: 32
version: string

Oracle GoldenGateサービスのAPIバージョン。

指定できる値: [ "v2" ]

先頭に戻る

レスポンス

サポートされるメディア・タイプ

application/json

200レスポンス

ルート・スキーマ: Oracle GoldenGate Output trail description

型: object

タイトル: Oracle GoldenGate Output trail description

ソースの表示

$schema(optional):

指定できる値: [ "mpoints:trailOutput" ]
hostname(optional): hostname

リモート・トレイルのホスト名
ioWriteBytes(optional): integer

最小値: 0

最大値: 9.223372036854776E18

I/O数(転送された書込みバイト)
ioWriteCount(optional): integer

最小値: 0

最大値: 9.223372036854776E18

I/O数(書込み操作)
portNumber(optional): integer

最小値: 1

最大値: 65535

リモート・トレイルのTCP/IPポート
portType(optional):

指定できる値: [ "LocalTrail", "Manager", "ServerCollector" ]

ポート接続のタイプ
trailBufferFlushes(optional): integer

最小値: 0

最大値: 9.223372036854776E18

トレイル・ファイルのバッファ・フラッシュ回数
trailBufferFlushTime(optional): integer

最小値: 0

最大値: 9.223372036854776E18

トレイル・ファイルのバッファのフラッシュにかかった時間
trailBytesFlushed(optional): integer

最小値: 0

最大値: 9.223372036854776E18

トレイル・ファイル・バッファからフラッシュされたバイト数
trailLastBufferFlushTs(optional): trailLastBufferFlushTs

最後のトレイル・ファイル・バッファ・フラッシュのタイムスタンプ
trailLobBytes(optional): integer

最小値: 0

最大値: 9.223372036854776E18

トレイル・ファイルのLOBバイト書込みの数
trailMaxBytes(optional): integer

最小値: 0

最大値: 4.294967295E9

トレイル・ファイルの最大バイト数
trailName(optional): string

最小長: 1

最大長: 16

トレイルの基本名
trailPath(optional): string

最小長: 1

最大長: 512

トレイルを格納するパス
trailRba(optional): integer

最小値: 0

最大値: 4.294967295E9

現在のRBA
trailSeq(optional): integer

最小値: 0

最大値: 4.294967295E9

現在の順序
trailWriteTime(optional): integer

最小値: 0

最大値: 9.223372036854776E18

トレイル・ファイルの書込みにかかった時間

{
    "title":"Oracle GoldenGate Output trail description",
    "type":"object",
    "properties":{
        "trailBufferFlushTime":{
            "description":"Time spent flushing trail file buffers",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        "hostname":{
            "description":"The host name for a remote trail",
            "x-oneOf":[
                {
                    "description":"Network host name",
                    "type":"string",
                    "pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
                    "minLength":1,
                    "maxLength":4095
                },
                {
                    "description":"Network IP address",
                    "x-oneOf":[
                        {
                            "description":"Network IPv4 address",
                            "type":"string",
                            "pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
                            "minLength":7,
                            "maxLength":15
                        },
                        {
                            "description":"Network IPv6 address",
                            "type":"string",
                            "pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
                            "minLength":1,
                            "maxLength":256
                        }
                    ]
                }
            ]
        },
        "trailBytesFlushed":{
            "description":"Number of bytes flushed from trail file buffers",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        "ioWriteCount":{
            "description":"Number of I/O Write Operations",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        "trailName":{
            "description":"The base name of the trail",
            "type":"string",
            "minLength":1,
            "maxLength":16
        },
        "trailRba":{
            "description":"Current RBA",
            "type":"integer",
            "minimum":0,
            "maximum":4.294967295E9
        },
        "ioWriteBytes":{
            "description":"Number of I/O Write Bytes Transfered",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        "trailPath":{
            "description":"The path for storing the trail",
            "type":"string",
            "minLength":1,
            "maxLength":512
        },
        "portType":{
            "description":"The type of port connection",
            "enum":[
                "LocalTrail",
                "Manager",
                "ServerCollector"
            ]
        },
        "$schema":{
            "enum":[
                "mpoints:trailOutput"
            ]
        },
        "portNumber":{
            "description":"The TCP/IP port for the remote trail",
            "type":"integer",
            "minimum":1,
            "maximum":65535
        },
        "trailMaxBytes":{
            "description":"Max Number of Bytes for a Trail file",
            "type":"integer",
            "minimum":0,
            "maximum":4.294967295E9
        },
        "trailLobBytes":{
            "description":"Number of LOB bytes write in trail file",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        "trailBufferFlushes":{
            "description":"Number trail file buffer flushes",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        "trailWriteTime":{
            "description":"Time spent in write of trail file",
            "type":"integer",
            "minimum":0,
            "maximum":9.223372036854776E18
        },
        "trailSeq":{
            "description":"Current Sequence",
            "type":"integer",
            "minimum":0,
            "maximum":4.294967295E9
        },
        "trailLastBufferFlushTs":{
            "description":"Last trail file buffer flush time stamp",
            "x-oneOf":[
                {
                    "type":"string",
                    "pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
                    "minLength":20,
                    "maxLength":32
                },
                {
                    "type":"null"
                }
            ]
        }
    },
    "additionalProperties":false
}

ネストされたスキーマ: hostname

リモート・トレイルのホスト名

1つに一致

ソースの表示

string

最小長: 1

最大長: 4095

パターン: ^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$

ネットワーク・ホスト名
hostname-x-oneOf[1]

ネットワークIPアドレス

{
    "description":"The host name for a remote trail",
    "x-oneOf":[
        {
            "description":"Network host name",
            "type":"string",
            "pattern":"^(((([a-zA-Z0-9][-a-zA-Z0-9]{0,61})?[a-zA-Z0-9])[.])*([a-zA-Z][-a-zA-Z0-9]{0,61}[a-zA-Z0-9]|[a-zA-Z])[.]?)$",
            "minLength":1,
            "maxLength":4095
        },
        {
            "description":"Network IP address",
            "x-oneOf":[
                {
                    "description":"Network IPv4 address",
                    "type":"string",
                    "pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
                    "minLength":7,
                    "maxLength":15
                },
                {
                    "description":"Network IPv6 address",
                    "type":"string",
                    "pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
                    "minLength":1,
                    "maxLength":256
                }
            ]
        }
    ]
}

ネストされたスキーマ: trailLastBufferFlushTs

最後のトレイル・ファイル・バッファ・フラッシュのタイムスタンプ

1つに一致

ソースの表示

string

最小長: 20

最大長: 32

パターン: ^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$
null

{
    "description":"Last trail file buffer flush time stamp",
    "x-oneOf":[
        {
            "type":"string",
            "pattern":"^[0-9]{4}[-](0[1-9]|1[0-2])[-](0[1-9]|[12][0-9]|3[01])[tT ]([01][0-9]|2[0-3]):[0-5][0-9]:([0-5][0-9]|60)([.][0-9]{1,6})?([zZ]|[+-][0-9][0-9]:[0-5][0-9])$",
            "minLength":20,
            "maxLength":32
        },
        {
            "type":"null"
        }
    ]
}

ネストされたスキーマ: hostname-x-oneOf[1]

ネットワークIPアドレス

1つに一致

ソースの表示

string

最小長: 7

最大長: 15

パターン: ^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$

ネットワークIPv4アドレス
string

最小長: 1

最大長: 256

パターン: ^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$

ネットワークIPv6アドレス

{
    "description":"Network IP address",
    "x-oneOf":[
        {
            "description":"Network IPv4 address",
            "type":"string",
            "pattern":"^((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)[.]){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$",
            "minLength":7,
            "maxLength":15
        },
        {
            "description":"Network IPv6 address",
            "type":"string",
            "pattern":"^((([0-9A-Fa-f]{1,4}:){7}([0-9A-Fa-f]{1,4}|:))|(([0-9A-Fa-f]{1,4}:){6}(:[0-9A-Fa-f]{1,4}|((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){5}(((:[0-9A-Fa-f]{1,4}){1,2})|:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3})|:))|(([0-9A-Fa-f]{1,4}:){4}(((:[0-9A-Fa-f]{1,4}){1,3})|((:[0-9A-Fa-f]{1,4})((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){3}(((:[0-9A-Fa-f]{1,4}){1,4})|((:[0-9A-Fa-f]{1,4}){0,2}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){2}(((:[0-9A-Fa-f]{1,4}){1,5})|((:[0-9A-Fa-f]{1,4}){0,3}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(([0-9A-Fa-f]{1,4}:){1}(((:[0-9A-Fa-f]{1,4}){1,6})|((:[0-9A-Fa-f]{1,4}){0,4}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:))|(:(((:[0-9A-Fa-f]{1,4}){1,7})|((:[0-9A-Fa-f]{1,4}){0,5}:((25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])([.](25[0-5]|2[0-4][0-9]|1[0-9][0-9]|[1-9]?[0-9])){3}))|:)))(%.+)?$",
            "minLength":1,
            "maxLength":256
        }
    ]
}

レスポンスの例(application/json)

{
    "$schema":"api:standardResponse",
    "response":{
        "trailBufferFlushTime":0,
        "hostname":"slc03flg",
        "trailBytesFlushed":160119,
        "ioWriteCount":1,
        "trailName":"aa",
        "trailRba":1530,
        "ioWriteBytes":61,
        "trailPath":"/net/slc03flg/scratch/jdivinc/view_storage/jdivinc_db1/tklocal/ggora/dirdat",
        "portType":"LocalTrail",
        "$schema":"mpoints:trailOutput",
        "portNumber":0,
        "trailMaxBytes":20000000,
        "trailLobBytes":0,
        "trailBufferFlushes":61405,
        "trailWriteTime":0,
        "trailSeq":20,
        "trailLastBufferFlushTs":"2015-06-10T11:06:57.024Z"
    },
    "messages":[
    ],
    "links":[
    ]
}

先頭に戻る