exadb_vm_cluster_update_history_entries

Creates, updates, deletes, gets or lists an exadb_vm_cluster_update_history_entries resource.

Overview

Name	exadb_vm_cluster_update_history_entries
Type	Resource
Id	oci.database.exadb_vm_cluster_update_history_entries

Fields

The following fields are returned by SELECT queries:

get

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. (ROLLING_APPLY, NON_ROLLING_APPLY, PRECHECK, ROLLBACK)
updateId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the maintenance update.
updateType	string	The type of cloud VM cluster maintenance update. (GI_UPGRADE, GI_PATCH, OS_UPDATE)
version	string	The version of the maintenance update package. (x-default-description: The version of the maintenance update package.)

list

The record of an maintenance update action on a specified Exadata VM cluster on Exascale Infrastructure.<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. (ROLLING_APPLY, NON_ROLLING_APPLY, PRECHECK, ROLLBACK)
updateId	string	The [OCID](/Content/General/Concepts/identifiers.htm) of the maintenance update.
updateType	string	The type of cloud VM cluster maintenance update. (GI_UPGRADE, GI_PATCH, OS_UPDATE)
version	string	The version of the maintenance update package. (x-default-description: The version of the maintenance update package.)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	exadbVmClusterId, updateHistoryEntryId, region	opc-request-id	Gets the maintenance update history details for the specified update history entry.<br />
list	select	exadbVmClusterId, region	updateType, limit, page, opc-request-id	Gets the history of the maintenance update actions performed on the specified Exadata VM cluster on Exascale Infrastructure.<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
exadbVmClusterId	string	The Exadata VM cluster [OCID](/Content/General/Concepts/identifiers.htm) on Exascale Infrastructure.
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.
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

Gets the maintenance update history details for the specified update history entry.<br />

SELECT
id,
lifecycleDetails,
lifecycleState,
timeCompleted,
timeStarted,
updateAction,
updateId,
updateType,
version
FROM oci.database.exadb_vm_cluster_update_history_entries
WHERE exadbVmClusterId = '{{ exadbVmClusterId }}' -- required
AND updateHistoryEntryId = '{{ updateHistoryEntryId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
;

list

Gets the history of the maintenance update actions performed on the specified Exadata VM cluster on Exascale Infrastructure.<br />

SELECT
id,
lifecycleDetails,
lifecycleState,
timeCompleted,
timeStarted,
updateAction,
updateId,
updateType,
version
FROM oci.database.exadb_vm_cluster_update_history_entries
WHERE exadbVmClusterId = '{{ exadbVmClusterId }}' -- required
AND region = '{{ region }}' -- required
AND updateType = '{{ updateType }}'
AND limit = '{{ limit }}'
AND page = '{{ page }}'
AND opc-request-id = '{{ opc-request-id }}'
;