Try SpotterFetches details about one or multiple MaintenanceRunHistory resources in Oracle Cloud Infrastructure
| "added in version" 2.9.0 of oracle.oci"
Authors: Oracle (@oracle)
preview | supported by community
Install with ansible-galaxy collection install oracle.oci:==5.0.0
collections:
- name: oracle.oci
version: 5.0.0Fetches details about one or multiple MaintenanceRunHistory resources in Oracle Cloud Infrastructure
Gets a list of the maintenance run histories in the specified compartment.
If I(maintenance_run_history_id) is specified, the details of a single MaintenanceRunHistory will be returned.
- name: Get a specific maintenance_run_history
oci_database_maintenance_run_history_facts:
# required
maintenance_run_history_id: "ocid1.maintenancerunhistory.oc1..xxxxxxEXAMPLExxxxxx"
- name: List maintenance_run_histories
oci_database_maintenance_run_history_facts:
# required
compartment_id: "ocid1.compartment.oc1..xxxxxxEXAMPLExxxxxx"
# optional
target_resource_id: "ocid1.targetresource.oc1..xxxxxxEXAMPLExxxxxx"
target_resource_type: AUTONOMOUS_EXADATA_INFRASTRUCTURE
maintenance_type: PLANNED
sort_by: TIME_SCHEDULED
sort_order: ASC
lifecycle_state: SCHEDULED
availability_domain: Uocm:PHX-AD-1
maintenance_subtype: QUARTERLY
region:
description:
- The Oracle Cloud Infrastructure region to use for all OCI API requests. If not set,
then the value of the OCI_REGION variable, if any, is used. This option is required
if the region is not specified through a configuration file (See C(config_file_location)).
Please refer to U(https://docs.us-phoenix-1.oraclecloud.com/Content/General/Concepts/regions.htm)
for more information on OCI regions.
type: str
sort_by:
choices:
- TIME_SCHEDULED
- TIME_ENDED
- DISPLAYNAME
description:
- The field to sort by. You can provide one sort order (`sortOrder`). Default order
for TIME_SCHEDULED and TIME_ENDED is descending. Default order for DISPLAYNAME is
ascending. The DISPLAYNAME sort order is case sensitive.
- '**Note:** If you do not include the availability domain filter, the resources are
grouped by availability domain, then sorted.'
type: str
tenancy:
description:
- OCID of your tenancy. If not set, then the value of the OCI_TENANCY variable, if
any, is used. This option is required if the tenancy OCID is not specified through
a configuration file (See C(config_file_location)). To get the tenancy OCID, please
refer U(https://docs.us-phoenix-1.oraclecloud.com/Content/API/Concepts/apisigningkey.htm)
type: str
api_user:
description:
- The OCID of the user, on whose behalf, OCI APIs are invoked. If not set, then the
value of the OCI_USER_ID environment variable, if any, is used. This option is required
if the user is not specified through a configuration file (See C(config_file_location)).
To get the user's OCID, please refer U(https://docs.us-phoenix-1.oraclecloud.com/Content/API/Concepts/apisigningkey.htm).
type: str
auth_type:
choices:
- api_key
- instance_principal
- instance_obo_user
- resource_principal
- security_token
default: api_key
description:
- The type of authentication to use for making API requests. By default C(auth_type="api_key")
based authentication is performed and the API key (see I(api_user_key_file)) in
your config file will be used. If this 'auth_type' module option is not specified,
the value of the OCI_ANSIBLE_AUTH_TYPE, if any, is used. Use C(auth_type="instance_principal")
to use instance principal based authentication when running ansible playbooks within
an OCI compute instance.
type: str
sort_order:
choices:
- ASC
- DESC
description:
- The sort order to use, either ascending (`ASC`) or descending (`DESC`).
type: str
cert_bundle:
description:
- The full path to a CA certificate bundle to be used for SSL verification. This will
override the default CA certificate bundle. If not set, then the value of the OCI_ANSIBLE_CERT_BUNDLE
variable, if any, is used.
type: str
auth_purpose:
choices:
- service_principal
description:
- The auth purpose which can be used in conjunction with 'auth_type=instance_principal'.
The default auth_purpose for instance_principal is None.
type: str
compartment_id:
description:
- The compartment L(OCID,https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm).
- Required to list multiple maintenance_run_histories.
type: str
lifecycle_state:
choices:
- SCHEDULED
- IN_PROGRESS
- SUCCEEDED
- SKIPPED
- FAILED
- UPDATING
- DELETING
- DELETED
- CANCELED
description:
- The state of the maintenance run history.
type: str
maintenance_type:
choices:
- PLANNED
- UNPLANNED
description:
- The maintenance type.
type: str
api_user_key_file:
description:
- Full path and filename of the private key (in PEM format). If not set, then the
value of the OCI_USER_KEY_FILE variable, if any, is used. This option is required
if the private key is not specified through a configuration file (See C(config_file_location)).
If the key is encrypted with a pass-phrase, the C(api_user_key_pass_phrase) option
must also be provided.
type: str
target_resource_id:
description:
- The target resource ID.
type: str
availability_domain:
description:
- A filter to return only resources that match the given availability domain exactly.
type: str
config_profile_name:
description:
- The profile to load from the config file referenced by C(config_file_location).
If not set, then the value of the OCI_CONFIG_PROFILE environment variable, if any,
is used. Otherwise, defaults to the "DEFAULT" profile in C(config_file_location).
type: str
maintenance_subtype:
choices:
- QUARTERLY
- HARDWARE
- CRITICAL
- INFRASTRUCTURE
- DATABASE
- ONEOFF
- SECURITY_MONTHLY
description:
- The sub-type of the maintenance run.
type: str
api_user_fingerprint:
description:
- Fingerprint for the key pair being used. If not set, then the value of the OCI_USER_FINGERPRINT
environment variable, if any, is used. This option is required if the key fingerprint
is not specified through a configuration file (See C(config_file_location)). To
get the key pair's fingerprint value please refer U(https://docs.us-phoenix-1.oraclecloud.com/Content/API/Concepts/apisigningkey.htm).
type: str
config_file_location:
description:
- Path to configuration file. If not set then the value of the OCI_CONFIG_FILE environment
variable, if any, is used. Otherwise, defaults to ~/.oci/config.
type: str
target_resource_type:
choices:
- AUTONOMOUS_EXADATA_INFRASTRUCTURE
- AUTONOMOUS_CONTAINER_DATABASE
- EXADATA_DB_SYSTEM
- CLOUD_EXADATA_INFRASTRUCTURE
- EXACC_INFRASTRUCTURE
- AUTONOMOUS_VM_CLUSTER
- AUTONOMOUS_DATABASE
- CLOUD_AUTONOMOUS_VM_CLUSTER
description:
- The type of the target resource.
type: str
api_user_key_pass_phrase:
description:
- Passphrase used by the key referenced in C(api_user_key_file), if it is encrypted.
If not set, then the value of the OCI_USER_KEY_PASS_PHRASE variable, if any, is
used. This option is required if the key passphrase is not specified through a configuration
file (See C(config_file_location)).
type: str
maintenance_run_history_id:
aliases:
- id
description:
- The maintenance run history OCID.
- Required to get a specific maintenance_run_history.
type: str
realm_specific_endpoint_template_enabled:
description:
- Enable/Disable realm specific endpoint template for service client. By Default,
realm specific endpoint template is disabled. If not set, then the value of the
OCI_REALM_SPECIFIC_SERVICE_ENDPOINT_TEMPLATE_ENABLED variable, if any, is used.
type: bool
maintenance_run_histories:
contains:
db_servers_history_details:
contains:
db_server_patching_details:
contains:
estimated_patch_duration:
description:
- Estimated time, in minutes, to patch one database server.
returned: on success
sample: 56
type: int
patching_status:
description:
- The status of the patching operation.
returned: on success
sample: SCHEDULED
type: str
time_patching_ended:
description:
- The time when the patching operation ended.
returned: on success
sample: '2013-10-20T19:20:30+01:00'
type: str
time_patching_started:
description:
- The time when the patching operation started.
returned: on success
sample: '2013-10-20T19:20:30+01:00'
type: str
description:
- ''
returned: on success
type: complex
display_name:
description:
- The user-friendly name for the database server. The name does not need
to be unique.
returned: on success
sample: display_name_example
type: str
id:
description:
- The OCID of the database server.
returned: on success
sample: ocid1.resource.oc1..xxxxxxEXAMPLExxxxxx
type: str
description:
- List of database server history details.
returned: on success
type: complex
id:
description:
- The OCID of the maintenance run history.
returned: on success
sample: ocid1.resource.oc1..xxxxxxEXAMPLExxxxxx
type: str
maintenance_run_details:
contains:
compartment_id:
description:
- The OCID of the compartment.
returned: on success
sample: ocid1.compartment.oc1..xxxxxxEXAMPLExxxxxx
type: str
current_custom_action_timeout_in_mins:
description:
- Extend current custom action timeout between the current database servers
during waiting state, from 0 (zero) to 30 minutes.
returned: on success
sample: 56
type: int
current_patching_component:
description:
- The name of the current infrastruture component that is getting patched.
returned: on success
sample: current_patching_component_example
type: str
custom_action_timeout_in_mins:
description:
- 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.
returned: on success
sample: 56
type: int
description:
description:
- Description of the maintenance run.
returned: on success
sample: description_example
type: str
display_name:
description:
- The user-friendly name for the maintenance run.
returned: on success
sample: display_name_example
type: str
estimated_component_patching_start_time:
description:
- The estimated start time of the next infrastruture component patching
operation.
returned: on success
sample: '2013-10-20T19:20:30+01:00'
type: str
estimated_patching_time:
contains:
estimated_db_server_patching_time:
description:
- The estimated time required in minutes for database server patching.
returned: on success
sample: 56
type: int
estimated_network_switches_patching_time:
description:
- The estimated time required in minutes for network switch patching.
returned: on success
sample: 56
type: int
estimated_storage_server_patching_time:
description:
- The estimated time required in minutes for storage server patching.
returned: on success
sample: 56
type: int
total_estimated_patching_time:
description:
- The estimated total time required in minutes for all patching operations.
returned: on success
sample: 56
type: int
description:
- ''
returned: on success
type: complex
id:
description:
- The OCID of the maintenance run.
returned: on success
sample: ocid1.resource.oc1..xxxxxxEXAMPLExxxxxx
type: str
is_custom_action_timeout_enabled:
description:
- If true, enables the configuration of a custom action timeout (waiting
period) between database servers patching operations.
returned: on success
sample: true
type: bool
lifecycle_details:
description:
- Additional information about the current lifecycle state.
returned: on success
sample: lifecycle_details_example
type: str
lifecycle_state:
description:
- The current state of the maintenance run. For Autonomous Database Serverless
instances, valid states are IN_PROGRESS, SUCCEEDED, and FAILED.
returned: on success
sample: SCHEDULED
type: str
maintenance_subtype:
description:
- Maintenance sub-type.
returned: on success
sample: QUARTERLY
type: str
maintenance_type:
description:
- Maintenance type.
returned: on success
sample: PLANNED
type: str
patch_failure_count:
description:
- Contain the patch failure count.
returned: on success
sample: 56
type: int
patch_id:
description:
- The unique identifier of the patch. The identifier string includes the
patch type, the Oracle 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 Database 19.9.0.0 that was released
October 30, 2020.
returned: on success
sample: ocid1.patch.oc1..xxxxxxEXAMPLExxxxxx
type: str
patching_end_time:
description:
- The time when the patching operation ended.
returned: on success
sample: '2013-10-20T19:20:30+01:00'
type: str
patching_mode:
description:
- Cloud Exadata infrastructure node patching method, either "ROLLING" or
"NONROLLING". Default value is ROLLING.
- '*IMPORTANT*: Non-rolling infrastructure patching involves system down
time. See L(Oracle-Managed Infrastructure Maintenance Updates,https://docs.cloud.oracle.com/iaas/Content/Database/Concepts/examaintenance.htm#Oracle)
for more information.'
returned: on success
sample: ROLLING
type: str
patching_start_time:
description:
- The time when the patching operation started.
returned: on success
sample: '2013-10-20T19:20:30+01:00'
type: str
patching_status:
description:
- The status of the patching operation.
returned: on success
sample: PATCHING
type: str
peer_maintenance_run_id:
description:
- The L(OCID,https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm)
of the maintenance run for the Autonomous Data Guard association's peer
container database.
returned: on success
sample: ocid1.peermaintenancerun.oc1..xxxxxxEXAMPLExxxxxx
type: str
target_db_server_version:
description:
- The target software version for the database server patching operation.
returned: on success
sample: target_db_server_version_example
type: str
target_resource_id:
description:
- The ID of the target resource on which the maintenance run occurs.
returned: on success
sample: ocid1.targetresource.oc1..xxxxxxEXAMPLExxxxxx
type: str
target_resource_type:
description:
- The type of the target resource on which the maintenance run occurs.
returned: on success
sample: AUTONOMOUS_EXADATA_INFRASTRUCTURE
type: str
target_storage_server_version:
description:
- The target Cell version that is to be patched to.
returned: on success
sample: target_storage_server_version_example
type: str
time_ended:
description:
- The date and time the maintenance run was completed.
returned: on success
sample: '2013-10-20T19:20:30+01:00'
type: str
time_scheduled:
description:
- The date and time the maintenance run is scheduled to occur.
returned: on success
sample: '2013-10-20T19:20:30+01:00'
type: str
time_started:
description:
- The date and time the maintenance run starts.
returned: on success
sample: '2013-10-20T19:20:30+01:00'
type: str
description:
- ''
returned: on success
type: complex
description:
- List of MaintenanceRunHistory resources
returned: on success
sample:
- db_servers_history_details:
- db_server_patching_details:
estimated_patch_duration: 56
patching_status: SCHEDULED
time_patching_ended: '2013-10-20T19:20:30+01:00'
time_patching_started: '2013-10-20T19:20:30+01:00'
display_name: display_name_example
id: ocid1.resource.oc1..xxxxxxEXAMPLExxxxxx
id: ocid1.resource.oc1..xxxxxxEXAMPLExxxxxx
maintenance_run_details:
compartment_id: ocid1.compartment.oc1..xxxxxxEXAMPLExxxxxx
current_custom_action_timeout_in_mins: 56
current_patching_component: current_patching_component_example
custom_action_timeout_in_mins: 56
description: description_example
display_name: display_name_example
estimated_component_patching_start_time: '2013-10-20T19:20:30+01:00'
estimated_patching_time:
estimated_db_server_patching_time: 56
estimated_network_switches_patching_time: 56
estimated_storage_server_patching_time: 56
total_estimated_patching_time: 56
id: ocid1.resource.oc1..xxxxxxEXAMPLExxxxxx
is_custom_action_timeout_enabled: true
lifecycle_details: lifecycle_details_example
lifecycle_state: SCHEDULED
maintenance_subtype: QUARTERLY
maintenance_type: PLANNED
patch_failure_count: 56
patch_id: ocid1.patch.oc1..xxxxxxEXAMPLExxxxxx
patching_end_time: '2013-10-20T19:20:30+01:00'
patching_mode: ROLLING
patching_start_time: '2013-10-20T19:20:30+01:00'
patching_status: PATCHING
peer_maintenance_run_id: ocid1.peermaintenancerun.oc1..xxxxxxEXAMPLExxxxxx
target_db_server_version: target_db_server_version_example
target_resource_id: ocid1.targetresource.oc1..xxxxxxEXAMPLExxxxxx
target_resource_type: AUTONOMOUS_EXADATA_INFRASTRUCTURE
target_storage_server_version: target_storage_server_version_example
time_ended: '2013-10-20T19:20:30+01:00'
time_scheduled: '2013-10-20T19:20:30+01:00'
time_started: '2013-10-20T19:20:30+01:00'
type: complex