Data Source: oci_database_database_upgrade_history_entries

This data source provides the list of Database Upgrade History Entries in Oracle Cloud Infrastructure Database service.

Gets the upgrade history for a specified database in a bare metal or virtual machine DB system.

Example Usage

data "oci_database_database_upgrade_history_entries" "test_database_upgrade_history_entries" {
	#Required
	database_id = oci_database_database.test_database.id

	#Optional
	state = var.database_upgrade_history_entry_state
	upgrade_action = var.database_upgrade_history_entry_upgrade_action
}

Argument Reference

The following arguments are supported:

• database_id - (Required) The database OCID.
• state - (Optional) A filter to return only upgradeHistoryEntries that match the given lifecycle state exactly.
• upgrade_action - (Optional) A filter to return only upgradeHistoryEntries that match the specified Upgrade Action.

Attributes Reference

The following attributes are exported:

• database_upgrade_history_entries - The list of database_upgrade_history_entries.

DatabaseUpgradeHistoryEntry Reference

The following attributes are exported:

• action - The database upgrade action.

• id - The OCID of the database upgrade history.

• lifecycle_details - Additional information about the current lifecycle state.

• options - Additional upgrade options supported by DBUA(Database Upgrade Assistant). Example: “-upgradeTimezone false -keepEvents”

• source - The source of the Oracle Database software to be used for the upgrade.

  • Use DB_VERSION to specify a generally-available Oracle Database software version to upgrade the database.
  • Use DB_SOFTWARE_IMAGE to specify a database software image to upgrade the database.

• source_db_home_id - The OCID of the Database Home.

• state - Status of database upgrade history SUCCEEDED|IN_PROGRESS|FAILED.

• target_db_version - A valid Oracle Database version. For a list of supported versions, use the ListDbVersions operation.

  This cannot be updated in parallel with any of the following: licenseModel, dbEdition, cpuCoreCount, computeCount, computeModel, adminPassword, whitelistedIps, isMTLSConnectionRequired, openMode, permissionLevel, dbWorkload, privateEndpointLabel, nsgIds, isRefreshable, dbName, scheduledOperations, dbToolsDetails, isLocalDataGuardEnabled, or isFreeTier.

• target_database_software_image_id - the database software image used for upgrading database.

• target_db_home_id - The OCID of the Database Home.

• time_ended - The date and time when the database upgrade ended.

• time_started - The date and time when the database upgrade started.