Slide 21
Slide 21 text
21
• デプロイメントのエンドポイントとHTTPS通信(Port 443)可能な任意のホストからコマンドを実行可能です。
例：プロセス情報取得リクエスト：チェックポイント取得
curl -k -u : -H “Content-Type: application/json” -H “Accept: application/json” -X POST
https:///services/v2//<プロセス名>/info/checkpoints | json_reformat
【参考】GoldenGate REST APIを利用したコマンド出力例
[oracle@cmp01 ~]$ curl -k -u ggadmin:xxxxxxx -H "Content-Type:
application/json" -H "Accept: application/json" -X GET
https://xxxxxxx.deployment.goldengate.xxxxxxx.oci.oraclecloud.com/servic
es/v2/extracts/ICAP01/info/checkpoints | json_reformat
% Total % Received % Xferd Average Speed Time Time Time
Current
Dload Upload Total Spent Left
Speed
100 1536 100 1536 0 0 15360 0 --:--:-- --:--:-- --:--:--
15360
{
"$schema": "api:standardResponse",
"links": [
{
"rel": "canonical",
"href":
"https://xxxxxxx.deployment.goldengate.xxxxxxx.oci.oraclecloud.com/servi
ces/v2/extracts/ICAP01/info/checkpoints",
"mediaType": "application/json"
},
{
"rel": "self",
"href":
"https://xxxxxxx.deployment.goldengate.xxxxxxx.oci.oraclecloud.com/servi
ces/v2/extracts/ICAP01/info/checkpoints",
"mediaType": "application/json"
},
{
"rel": "describedby",
"href":
"https://xxxxxxx.deployment.goldengate.xxxxxxx.oci.oraclecloud.com/servi
ces/adminsrvr/v2/metadata-catalog/extractCheckpoints",
"mediaType": "application/schema+json"
}
],
"messages": [
],
"response": {
"$schema": "ogg:extractCheckpoints",
"current": {
"input": [
{
"starting": {
"timestamp": "2024-05-24T05:13:31.000Z",
"thread": 1,
"sequence": 0,
"offset": 0,
"csn": null,
"name": null
},
"recovery": {
"timestamp": "2024-05-31T03:17:58.000Z",
"thread": 1,
"sequence": 0,
"offset": 0,
"csn": 7344497,
"name": null
},
"current": {
"timestamp": "2024-05-31T03:18:04.000Z",
"thread": 0,
"sequence": 0,
"offset": 0,
"csn": 7344509,
"name": null
},
"boundedRecoveryPrevious": {
"timestamp": "2024-05-24T05:13:40.464Z",
"thread": 1,
"sequence": 0,
"offset": 0,
"csn": null,
"name": null
},
"boundedRecoveryBegin": {
"timestamp": "2024-05-24T05:13:40.464Z",
"thread": 1,
"sequence": 0,
"offset": 0,
"csn": null,
"name": null
},
"boundedRecoveryEnd": {
"timestamp": "2024-05-24T05:13:40.464Z",
"thread": 1,
"sequence": 0,
"offset": 0,
"csn": null,
"name": null
}
}
],
"output": [
{
"current": {
"timestamp": "2024-05-31T03:18:08.680Z",
"offset": 1366,
"name": "l1",
"sequence": 22,
"sequenceLength": 9,
"sequenceLengthFlip": false
}
}
]
}
}
}
Copyright © 2024, Oracle and/or its affiliates