使用 REST API
連線至專用部署
如果部署有專用端點,您可以使用 Cloud Shell 網路將 Cloud Shell 連線至可存取部署的網路,或是建立堡壘主機、堡壘主機階段作業以及 SSH 通道。
Cloud Shell 預設會限制您租用戶原建立區域中 OCI 內部資源的網路存取,除非您已啟用 Cloud Shell 管理的公用網路。您的管理員必須設定身分識別原則,才能啟用 Cloud Shell 公用網路。如需詳細資訊,請參閱 Cloud Shell 網路。
若要連線至「管理從屬端」中的專用 OCI GoldenGate 部署,請執行下列動作:
REST API 呼叫範例
或者,您可以將建置使用者名稱和密碼儲存在 .netrc 檔案中。下列範例假設您使用的是 .netrc 檔案。
您現在可以使用 Curl 將要求傳送給資料複製部署。例如,下列命令會傳回部署狀況:
curl -n -H "Content-Type: application/json" -H "Accept: application/json" -X GET https://<deployment URL>/services/v2/config/health列出歷程檔
curl -n -H "Content-Type: application/json" -H "Accept: application/json" -X GET https://<deployment URL>/services/v2/exttrails
列出擷取或複製
清單擷取:
curl -n -H "Content-Type: application/json" -H "Accept: application/json" -X GET https://<deployment URL>/v2/extracts列出 Replicats:
curl -n -H "Content-Type: application/json" -H "Accept: application/json" -X GET https://<deployment URL>/v2/replicats擷取 Extract 或 Replicat 詳細資訊
擷取擷取明細:
curl -n -H "Content-Type: application/json" -H "Accept: application/json" -X GET https://<deployment URL>/v2/extracts/<extract name>擷取 Replicat 詳細資訊:
curl -n -H "Content-Type: application/json" -H "Accept: application/json" -X GET https://<deployment URL>/v2/replicats/<replicat name>建立擷取
首先,建立一個包含 Extract 組態的 JSON 文件。例如,此檔案可用來使用 E1 歷程檔產生名為 EATP 的 Extract,以及從 SRC_OCIGGLL.* 擷取資料:
{
"config":[
"Extract EATP",
"ExtTrail E1",
"UseridAlias BLOGSRCATP",
"Table SRC_OCIGGLL.*;"
],
"source":{"tranlogs":"integrated"},
"credentials":{"alias":"BLOGSRCATP"},
"registration":{"optimized":false},
"begin":"now",
"targets":[{"name":"E1"}]
}
然後,執行下列命令以建立「摘錄」處理程序:
curl -n -H "Content-Type: application/json" -H "Accept: application/json" -X POST https://<deployment URL>/services/v2/extracts/<Extract name> -d @<JSON file>.json建立 Replicat
首先,建立一個包含 Replicat 組態的 JSON 文件。例如,此檔案可以使用 E1 歷程檔產生名為 RADW 的 Replicat,並將資料從 SRC_OCIGGLL.* 複製到 SRCMIRROR_OCIGGLL.*:
{
"config":[
"REPLICAT RADW",
"UseridAlias BLOGTRGADW",
"MAP SRC_OCIGGLL.*, TARGET SRCMIRROR_OCIGGLL.*;"
],
"source":{"name": "E1"},
"credentials":{"alias":"BLOGTRGADW"},
"checkpoint":{"table":"SRCMIRROR_OCIGGLL.CHECKTABLE"},
"mode":{
"type":"nonintegrated",
"parallel": false
},
"registration":"none",
"begin":"now",
"status":"stopped"
}
然後,執行下列命令來建立 Replicat 處理作業:
curl -n -H "Content-Type: application/json" -H "Accept: application/json" -X POST https://<deployment URL>/services/v2/replicats/<Replicat name> -d @<JSON file>.json啟動 Extract 或 Replicat
curl -n -H "Content-Type: application/json" -H "Accept: application/json" -X POST https://<deployment URL>/services/v2/commands/execute -d '{ "name":"start", "processName":"<Extract or Replicat name>"}'
取得指定之 Extract 的狀態和統計資料
取得擷取狀態:
curl -n -H "Content-Type: application/json" -H "Accept: application/json" -X POST https://<deployment URL>:<port>/services/v2/extracts/<extract name>/command -d '{"command":"STATUS"}'取得 Extract 統計資料:
curl -n -H "Content-Type: application/json" -H "Accept: application/json" -X POST https://<deployment URL>:<port>/services/v2/extracts/<extract name>/command -d '{"command":"STATUS"}'取得指定 Replicat 的狀態和統計資料
取得 Replicat 狀態:
curl -n -H "Content-Type: application/json" -H "Accept: application/json" -X POST https://<deployment URL>:<port>/services/v2/replicats/<replicat name>/command -d '{"command":"STATUS"}'取得 Replicat 統計資料:
curl -n -H "Content-Type: application/json" -H "Accept: application/json" -X POST https://<deployment URL>:<port>/services/v2/replicats/<replicat name>/command -d '{"command":"STATS"}'