Data Source: oci_database_maintenance_runs

This data source provides the list of Maintenance Runs in Oracle Cloud Infrastructure Database service.

Gets a list of the maintenance runs in the specified compartment.

Example Usage

data "oci_database_maintenance_runs" "test_maintenance_runs" {
	#Required
	compartment_id = var.compartment_id

	#Optional
	availability_domain = var.maintenance_run_availability_domain
	is_local_adg = var.maintenance_run_is_local_adg
	maintenance_subtype = var.maintenance_run_maintenance_subtype
	maintenance_type = var.maintenance_run_maintenance_type
	state = var.maintenance_run_state
	target_resource_id = oci_database_target_resource.test_target_resource.id
	target_resource_type = var.maintenance_run_target_resource_type
}

Argument Reference

The following arguments are supported:

• availability_domain - (Optional) A filter to return only resources that match the given availability domain exactly.
• compartment_id - (Required) The compartment OCID.
• is_local_adg - (Optional) A filter to return the maintenance history results for the local standby Autonomous AI Database Serverless only.
• maintenance_subtype - (Optional) The sub-type of the maintenance run.
• maintenance_type - (Optional) The maintenance type.
• state - (Optional) A filter to return only resources that match the given lifecycle state exactly.
• target_resource_id - (Optional) The target resource ID.
• target_resource_type - (Optional) The type of the target resource. Accepted values are: AUTONOMOUS_CONTAINER_DATABASE, AUTONOMOUS_EXADATA_INFRASTRUCTURE, EXADATA_DB_SYSTEM

Attributes Reference

The following attributes are exported:

• maintenance_runs - The list of maintenance_runs.

MaintenanceRun Reference

The following attributes are exported:

• compartment_id - The OCID of the compartment.

• current_custom_action_timeout_in_mins - Extend current custom action timeout between the current database servers during waiting state, from 0 (zero) to 30 minutes.

• current_patching_component - The name of the current infrastruture component that is getting patched.

• custom_action_timeout_in_mins - Determines the amount of time the system will wait before the start of each database server patching operation. Specify a number of minutes, from 15 to 120.

• database_software_image_id - The Autonomous AI Database Software Image OCID

• description - Description of the maintenance run.

• display_name - The user-friendly name for the maintenance run.

• estimated_component_patching_start_time - The estimated start time of the next infrastruture component patching operation.

• estimated_patching_time - The estimated total time required in minutes for all patching operations (database server, storage server, and network switch patching).

  • estimated_db_server_patching_time - The estimated time required in minutes for database server patching.
  • estimated_network_switches_patching_time - The estimated time required in minutes for network switch patching.
  • estimated_storage_server_patching_time - The estimated time required in minutes for storage server patching.
  • total_estimated_patching_time - The estimated total time required in minutes for all patching operations.

• id - The OCID of the maintenance run.

• is_custom_action_timeout_enabled - If true, enables the configuration of a custom action timeout (waiting period) between database servers patching operations.

• is_dst_file_update_enabled - Indicates if an automatic DST Time Zone file update is enabled for the Autonomous Container Database. If enabled along with Release Update, patching will be done in a Non-Rolling manner.

• is_maintenance_run_granular - If FALSE, the maintenance run doesn’t support granular maintenance.

• lifecycle_details - Additional information about the current lifecycle state.

• maintenance_subtype - Maintenance sub-type.

• maintenance_type - Maintenance type.

• patch_failure_count - Contain the patch failure count.

• patch_id - The unique identifier of the patch. The identifier string includes the patch type, the Oracle AI Database version, and the patch creation date (using the format YYMMDD). For example, the identifier ru_patch_19.9.0.0_201030 is used for an RU patch for Oracle AI Database 19.9.0.0 that was released October 30, 2020.

• patching_end_time - The time when the patching operation ended.

• patching_mode - Cloud Exadata infrastructure node patching method, either “ROLLING” or “NONROLLING”. Default value is ROLLING.

  IMPORTANT: Non-rolling infrastructure patching involves system down time. See Oracle-Managed Infrastructure Maintenance Updates for more information.

• patching_start_time - The time when the patching operation started.

• patching_status - The status of the patching operation.

• peer_maintenance_run_id - The OCID of the maintenance run for the Autonomous Data Guard association’s peer container database.

• peer_maintenance_run_ids - The list of OCIDs for the maintenance runs associated with their Autonomous Data Guard peer container databases.

• state - The current state of the maintenance run. For Autonomous AI Database Serverless instances, valid states are IN_PROGRESS, SUCCEEDED, and FAILED.

• system_tags - System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

• target_db_server_version - The target software version for the database server patching operation.

• target_resource_id - The ID of the target resource on which the maintenance run occurs.

• target_resource_type - The type of the target resource on which the maintenance run occurs.

• target_storage_server_version - The target Cell version that is to be patched to.

• time_ended - The date and time the maintenance run was completed.

• time_scheduled - The date and time the maintenance run is scheduled to occur.

• time_started - The date and time the maintenance run starts.

• total_time_taken_in_mins - The total time taken by corresponding resource activity in minutes.