vm_cluster_update_history_entries
Creates, updates, deletes, gets or lists a vm_cluster_update_history_entries resource.
Overview​
| Name | vm_cluster_update_history_entries |
| Type | Resource |
| Id | oci.database.vm_cluster_update_history_entries |
Fields​
The following fields are returned by SELECT queries:
- get
- list
The maintenance update history details for the specified update history entry.
| Name | Datatype | Description |
|---|---|---|
id | string | The [OCID](/Content/General/Concepts/identifiers.htm) of the maintenance update history entry. |
lifecycleDetails | string | Descriptive text providing additional details about the lifecycle state. |
lifecycleState | string | The current lifecycle state of the maintenance update operation. (IN_PROGRESS, SUCCEEDED, FAILED) |
timeCompleted | string (date-time) | The date and time when the maintenance update action completed. |
timeStarted | string (date-time) | The date and time when the maintenance update action started. |
updateAction | string | The update action performed using this maintenance update. (ROLLING_APPLY, PRECHECK, ROLLBACK) |
updateId | string | The [OCID](/Content/General/Concepts/identifiers.htm) of the maintenance update. |
updateType | string | The type of VM cluster maintenance update. (GI_UPGRADE, GI_PATCH, OS_UPDATE) |
The record of a maintenance update action performed on a specified VM cluster. Applies to Exadata Cloud@Customer instances only.<br />
| Name | Datatype | Description |
|---|---|---|
id | string | The [OCID](/Content/General/Concepts/identifiers.htm) of the maintenance update history entry. |
lifecycleDetails | string | Descriptive text providing additional details about the lifecycle state. |
lifecycleState | string | The current lifecycle state of the maintenance update operation. (IN_PROGRESS, SUCCEEDED, FAILED) |
timeCompleted | string (date-time) | The date and time when the maintenance update action completed. |
timeStarted | string (date-time) | The date and time when the maintenance update action started. |
updateAction | string | The update action performed using this maintenance update. (ROLLING_APPLY, PRECHECK, ROLLBACK) |
updateId | string | The [OCID](/Content/General/Concepts/identifiers.htm) of the maintenance update. |
updateType | string | The type of VM cluster maintenance update. (GI_UPGRADE, GI_PATCH, OS_UPDATE) |
Methods​
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | vmClusterId, updateHistoryEntryId, region | opc-request-id | Gets the maintenance update history details for the specified update history entry. Applies to Exadata Cloud@Customer instances only.<br /> |
list | select | vmClusterId, region | updateType, lifecycleState, limit, page, opc-request-id | Gets the history of the maintenance update actions performed on the specified VM cluster. Applies to Exadata Cloud@Customer instances only.<br /> |
Parameters​
Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.
| Name | Datatype | Description |
|---|---|---|
region | string | OCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION) |
updateHistoryEntryId | string | The [OCID](/Content/General/Concepts/identifiers.htm) of the maintenance update history entry. |
vmClusterId | string | The VM cluster [OCID](/Content/General/Concepts/identifiers.htm). |
lifecycleState | string | A filter to return only resources that match the given lifecycle state exactly. |
limit | integer | The maximum number of items to return per page. |
opc-request-id | string | Unique identifier for the request. |
page | string | The pagination token to continue listing from. |
updateType | string | A filter to return only resources that match the given update type exactly. |
SELECT examples​
- get
- list
Gets the maintenance update history details for the specified update history entry. Applies to Exadata Cloud@Customer instances only.<br />
SELECT
id,
lifecycleDetails,
lifecycleState,
timeCompleted,
timeStarted,
updateAction,
updateId,
updateType
FROM oci.database.vm_cluster_update_history_entries
WHERE vmClusterId = '{{ vmClusterId }}' -- required
AND updateHistoryEntryId = '{{ updateHistoryEntryId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
;
Gets the history of the maintenance update actions performed on the specified VM cluster. Applies to Exadata Cloud@Customer instances only.<br />
SELECT
id,
lifecycleDetails,
lifecycleState,
timeCompleted,
timeStarted,
updateAction,
updateId,
updateType
FROM oci.database.vm_cluster_update_history_entries
WHERE vmClusterId = '{{ vmClusterId }}' -- required
AND region = '{{ region }}' -- required
AND updateType = '{{ updateType }}'
AND lifecycleState = '{{ lifecycleState }}'
AND limit = '{{ limit }}'
AND page = '{{ page }}'
AND opc-request-id = '{{ opc-request-id }}'
;