Oracle REST Data Services (ORDS) と DB21c XE で Database REST APIs による PDB lifecycle management を使えるようにしてみる

[satokaz]

{
  "items": [
    {
      "inst_id": 1,
      "con_id": 2,
      "dbid": 1393529065,
      "con_uid": 1393529065,
      "guid": "6d6YmK4ABOLgUwEAAH9Ytw==",
      "name": "PDB$SEED",
      "open_mode": "READ ONLY",
      "restricted": "NO",
      "open_time": "2022-12-28T04:26:09.889Z",
      "create_scn": 2571578,
      "total_size": 802160640,
      "block_size": 8192,
      "recovery_status": "ENABLED",
      "snapshot_parent_con_id": null,
      "application_root": "NO",
      "application_pdb": "NO",
      "application_seed": "NO",
      "application_root_con_id": null,
      "application_root_clone": "NO",
      "proxy_pdb": "NO",
      "local_undo": 1,
      "undo_scn": 289,
      "undo_timestamp": null,
      "creation_time": "2022-09-30T04:40:40Z",
      "diagnostics_size": 0,
      "pdb_count": 0,
      "audit_files_size": 0,
      "max_size": 0,
      "max_diagnostics_size": 0,
      "max_audit_size": 0,
      "last_changed_by": "COMMON USER",
      "template": "NO",
      "tenant_id": null,
      "upgrade_level": 1,
      "guid_base64": "6d6YmK4ABOLgUwEAAH9YtwA=",
      "recovery_target_pdb_incarnation#": 0,
      "cloud_identity": null,
      "close_time": "2022-12-28T04:26:09.821Z",
      "links": [
        {
          "rel": "self",
          "href": "http://192.168.100.153:8080/ords/_/db-api/stable/database/pdbs/PDB%24SEED/"
        }
      ]
    },
    {
      "inst_id": 1,
      "con_id": 3,
      "dbid": 3023130239,
      "con_uid": 3023130239,
      "guid": "6d6w9NndCQvgUwEAAH++1A==",
      "name": "XEPDB1",
      "open_mode": "READ WRITE",
      "restricted": "NO",
      "open_time": "2022-12-27T06:37:23.936Z",
      "create_scn": 2620375,
      "total_size": 1067450368,
      "block_size": 8192,
      "recovery_status": "ENABLED",
      "snapshot_parent_con_id": null,
      "application_root": "NO",
      "application_pdb": "NO",
      "application_seed": "NO",
      "application_root_con_id": null,
      "application_root_clone": "NO",
      "proxy_pdb": "NO",
      "local_undo": 1,
      "undo_scn": 289,
      "undo_timestamp": null,
      "creation_time": "2022-09-30T04:47:29Z",
      "diagnostics_size": 0,
      "pdb_count": 0,
      "audit_files_size": 0,
      "max_size": 0,
      "max_diagnostics_size": 0,
      "max_audit_size": 0,
      "last_changed_by": "COMMON USER",
      "template": "NO",
      "tenant_id": null,
      "upgrade_level": 1,
      "guid_base64": "6d6w9NndCQvgUwEAAH++1AA=",
      "recovery_target_pdb_incarnation#": 0,
      "cloud_identity": null,
      "close_time": null,
      "links": [
        {
          "rel": "self",
          "href": "http://192.168.100.153:8080/ords/_/db-api/stable/database/pdbs/XEPDB1/"
        }
      ]
    }
  ],
  "hasMore": false,
  "limit": 25,
  "offset": 0,
  "count": 2,
  "links": [
    {
      "rel": "self",
      "href": "http://192.168.100.153:8080/ords/_/db-api/stable/database/pdbs/"
    },
    {
      "rel": "describedby",
      "href": "http://192.168.100.153:8080/ords/_/db-api/stable/metadata-catalog/"
    },
    {
      "rel": "first",
      "href": "http://192.168.100.153:8080/ords/_/db-api/stable/database/pdbs/"
    }
  ]
}