Oracle Cloud Infrastructure v1.16.0, Nov 2 23

Oracle Cloud Infrastructure v1.16.0 published on Thursday, Nov 2, 2023 by Pulumi

oci.Database.getMaintenanceRuns

Explore with Pulumi AI

Oracle Cloud Infrastructure v1.16.0 published on Thursday, Nov 2, 2023 by Pulumi

Example Usage

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testMaintenanceRuns = Oci.Database.GetMaintenanceRuns.Invoke(new()
    {
        CompartmentId = @var.Compartment_id,
        AvailabilityDomain = @var.Maintenance_run_availability_domain,
        MaintenanceSubtype = @var.Maintenance_run_maintenance_subtype,
        MaintenanceType = @var.Maintenance_run_maintenance_type,
        State = @var.Maintenance_run_state,
        TargetResourceId = oci_database_target_resource.Test_target_resource.Id,
        TargetResourceType = @var.Maintenance_run_target_resource_type,
    });

});

package main

import (
	"github.com/pulumi/pulumi-oci/sdk/go/oci/Database"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := Database.GetMaintenanceRuns(ctx, &database.GetMaintenanceRunsArgs{
			CompartmentId:      _var.Compartment_id,
			AvailabilityDomain: pulumi.StringRef(_var.Maintenance_run_availability_domain),
			MaintenanceSubtype: pulumi.StringRef(_var.Maintenance_run_maintenance_subtype),
			MaintenanceType:    pulumi.StringRef(_var.Maintenance_run_maintenance_type),
			State:              pulumi.StringRef(_var.Maintenance_run_state),
			TargetResourceId:   pulumi.StringRef(oci_database_target_resource.Test_target_resource.Id),
			TargetResourceType: pulumi.StringRef(_var.Maintenance_run_target_resource_type),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Database.DatabaseFunctions;
import com.pulumi.oci.Database.inputs.GetMaintenanceRunsArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var testMaintenanceRuns = DatabaseFunctions.getMaintenanceRuns(GetMaintenanceRunsArgs.builder()
            .compartmentId(var_.compartment_id())
            .availabilityDomain(var_.maintenance_run_availability_domain())
            .maintenanceSubtype(var_.maintenance_run_maintenance_subtype())
            .maintenanceType(var_.maintenance_run_maintenance_type())
            .state(var_.maintenance_run_state())
            .targetResourceId(oci_database_target_resource.test_target_resource().id())
            .targetResourceType(var_.maintenance_run_target_resource_type())
            .build());

    }
}

import pulumi
import pulumi_oci as oci

test_maintenance_runs = oci.Database.get_maintenance_runs(compartment_id=var["compartment_id"],
    availability_domain=var["maintenance_run_availability_domain"],
    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"])

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testMaintenanceRuns = oci.Database.getMaintenanceRuns({
    compartmentId: _var.compartment_id,
    availabilityDomain: _var.maintenance_run_availability_domain,
    maintenanceSubtype: _var.maintenance_run_maintenance_subtype,
    maintenanceType: _var.maintenance_run_maintenance_type,
    state: _var.maintenance_run_state,
    targetResourceId: oci_database_target_resource.test_target_resource.id,
    targetResourceType: _var.maintenance_run_target_resource_type,
});

variables:
  testMaintenanceRuns:
    fn::invoke:
      Function: oci:Database:getMaintenanceRuns
      Arguments:
        compartmentId: ${var.compartment_id}
        availabilityDomain: ${var.maintenance_run_availability_domain}
        maintenanceSubtype: ${var.maintenance_run_maintenance_subtype}
        maintenanceType: ${var.maintenance_run_maintenance_type}
        state: ${var.maintenance_run_state}
        targetResourceId: ${oci_database_target_resource.test_target_resource.id}
        targetResourceType: ${var.maintenance_run_target_resource_type}

Using getMaintenanceRuns

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getMaintenanceRuns(args: GetMaintenanceRunsArgs, opts?: InvokeOptions): Promise<GetMaintenanceRunsResult>
function getMaintenanceRunsOutput(args: GetMaintenanceRunsOutputArgs, opts?: InvokeOptions): Output<GetMaintenanceRunsResult>

def get_maintenance_runs(availability_domain: Optional[str] = None,
                         compartment_id: Optional[str] = None,
                         filters: Optional[Sequence[_database.GetMaintenanceRunsFilter]] = None,
                         maintenance_subtype: Optional[str] = None,
                         maintenance_type: Optional[str] = None,
                         state: Optional[str] = None,
                         target_resource_id: Optional[str] = None,
                         target_resource_type: Optional[str] = None,
                         opts: Optional[InvokeOptions] = None) -> GetMaintenanceRunsResult
def get_maintenance_runs_output(availability_domain: Optional[pulumi.Input[str]] = None,
                         compartment_id: Optional[pulumi.Input[str]] = None,
                         filters: Optional[pulumi.Input[Sequence[pulumi.Input[_database.GetMaintenanceRunsFilterArgs]]]] = None,
                         maintenance_subtype: Optional[pulumi.Input[str]] = None,
                         maintenance_type: Optional[pulumi.Input[str]] = None,
                         state: Optional[pulumi.Input[str]] = None,
                         target_resource_id: Optional[pulumi.Input[str]] = None,
                         target_resource_type: Optional[pulumi.Input[str]] = None,
                         opts: Optional[InvokeOptions] = None) -> Output[GetMaintenanceRunsResult]

func GetMaintenanceRuns(ctx *Context, args *GetMaintenanceRunsArgs, opts ...InvokeOption) (*GetMaintenanceRunsResult, error)
func GetMaintenanceRunsOutput(ctx *Context, args *GetMaintenanceRunsOutputArgs, opts ...InvokeOption) GetMaintenanceRunsResultOutput

> Note: This function is named GetMaintenanceRuns in the Go SDK.

public static class GetMaintenanceRuns 
{
    public static Task<GetMaintenanceRunsResult> InvokeAsync(GetMaintenanceRunsArgs args, InvokeOptions? opts = null)
    public static Output<GetMaintenanceRunsResult> Invoke(GetMaintenanceRunsInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetMaintenanceRunsResult> getMaintenanceRuns(GetMaintenanceRunsArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

fn::invoke:
  function: oci:Database/getMaintenanceRuns:getMaintenanceRuns
  arguments:
    # arguments dictionary

The following arguments are supported:

CompartmentId string: The compartment OCID.
AvailabilityDomain string: A filter to return only resources that match the given availability domain exactly.
Filters List<GetMaintenanceRunsFilter>
MaintenanceSubtype string: The sub-type of the maintenance run.
MaintenanceType string: The maintenance type.
State string: A filter to return only resources that match the given lifecycle state exactly.
TargetResourceId string: The target resource ID.
TargetResourceType string: The type of the target resource. Accepted values are: AUTONOMOUS_CONTAINER_DATABASE, AUTONOMOUS_EXADATA_INFRASTRUCTURE, EXADATA_DB_SYSTEM

CompartmentId string: The compartment OCID.
AvailabilityDomain string: A filter to return only resources that match the given availability domain exactly.
Filters []GetMaintenanceRunsFilter
MaintenanceSubtype string: The sub-type of the maintenance run.
MaintenanceType string: The maintenance type.
State string: A filter to return only resources that match the given lifecycle state exactly.
TargetResourceId string: The target resource ID.
TargetResourceType string: The type of the target resource. Accepted values are: AUTONOMOUS_CONTAINER_DATABASE, AUTONOMOUS_EXADATA_INFRASTRUCTURE, EXADATA_DB_SYSTEM

compartmentId String: The compartment OCID.
availabilityDomain String: A filter to return only resources that match the given availability domain exactly.
filters List<GetMaintenanceRunsFilter>
maintenanceSubtype String: The sub-type of the maintenance run.
maintenanceType String: The maintenance type.
state String: A filter to return only resources that match the given lifecycle state exactly.
targetResourceId String: The target resource ID.
targetResourceType String: The type of the target resource. Accepted values are: AUTONOMOUS_CONTAINER_DATABASE, AUTONOMOUS_EXADATA_INFRASTRUCTURE, EXADATA_DB_SYSTEM

compartmentId string: The compartment OCID.
availabilityDomain string: A filter to return only resources that match the given availability domain exactly.
filters GetMaintenanceRunsFilter[]
maintenanceSubtype string: The sub-type of the maintenance run.
maintenanceType string: The maintenance type.
state string: A filter to return only resources that match the given lifecycle state exactly.
targetResourceId string: The target resource ID.
targetResourceType string: The type of the target resource. Accepted values are: AUTONOMOUS_CONTAINER_DATABASE, AUTONOMOUS_EXADATA_INFRASTRUCTURE, EXADATA_DB_SYSTEM

compartment_id str: The compartment OCID.
availability_domain str: A filter to return only resources that match the given availability domain exactly.
filters GetMaintenanceRunsFilter]
maintenance_subtype str: The sub-type of the maintenance run.
maintenance_type str: The maintenance type.
state str: A filter to return only resources that match the given lifecycle state exactly.
target_resource_id str: The target resource ID.
target_resource_type str: The type of the target resource. Accepted values are: AUTONOMOUS_CONTAINER_DATABASE, AUTONOMOUS_EXADATA_INFRASTRUCTURE, EXADATA_DB_SYSTEM

compartmentId String: The compartment OCID.
availabilityDomain String: A filter to return only resources that match the given availability domain exactly.
filters List<Property Map>
maintenanceSubtype String: The sub-type of the maintenance run.
maintenanceType String: The maintenance type.
state String: A filter to return only resources that match the given lifecycle state exactly.
targetResourceId String: The target resource ID.
targetResourceType String: The type of the target resource. Accepted values are: AUTONOMOUS_CONTAINER_DATABASE, AUTONOMOUS_EXADATA_INFRASTRUCTURE, EXADATA_DB_SYSTEM

getMaintenanceRuns Result

The following output properties are available:

CompartmentId string: The OCID of the compartment.
Id string: The provider-assigned unique ID for this managed resource.
MaintenanceRuns List<GetMaintenanceRunsMaintenanceRun>: The list of maintenance_runs.
AvailabilityDomain string
Filters List<GetMaintenanceRunsFilter>
MaintenanceSubtype string: Maintenance sub-type.
MaintenanceType string: Maintenance type.
State string: The current state of the maintenance run. For Autonomous Database Serverless instances, valid states are IN_PROGRESS, SUCCEEDED, and FAILED.
TargetResourceId string: The ID of the target resource on which the maintenance run occurs.
TargetResourceType string: The type of the target resource on which the maintenance run occurs.

CompartmentId string: The OCID of the compartment.
Id string: The provider-assigned unique ID for this managed resource.
MaintenanceRuns []GetMaintenanceRunsMaintenanceRun: The list of maintenance_runs.
AvailabilityDomain string
Filters []GetMaintenanceRunsFilter
MaintenanceSubtype string: Maintenance sub-type.
MaintenanceType string: Maintenance type.
State string: The current state of the maintenance run. For Autonomous Database Serverless instances, valid states are IN_PROGRESS, SUCCEEDED, and FAILED.
TargetResourceId string: The ID of the target resource on which the maintenance run occurs.
TargetResourceType string: The type of the target resource on which the maintenance run occurs.

compartmentId String: The OCID of the compartment.
id String: The provider-assigned unique ID for this managed resource.
maintenanceRuns List<GetMaintenanceRunsMaintenanceRun>: The list of maintenance_runs.
availabilityDomain String
filters List<GetMaintenanceRunsFilter>
maintenanceSubtype String: Maintenance sub-type.
maintenanceType String: Maintenance type.
state String: The current state of the maintenance run. For Autonomous Database Serverless instances, valid states are IN_PROGRESS, SUCCEEDED, and FAILED.
targetResourceId String: The ID of the target resource on which the maintenance run occurs.
targetResourceType String: The type of the target resource on which the maintenance run occurs.

compartmentId string: The OCID of the compartment.
id string: The provider-assigned unique ID for this managed resource.
maintenanceRuns GetMaintenanceRunsMaintenanceRun[]: The list of maintenance_runs.
availabilityDomain string
filters GetMaintenanceRunsFilter[]
maintenanceSubtype string: Maintenance sub-type.
maintenanceType string: Maintenance type.
state string: The current state of the maintenance run. For Autonomous Database Serverless instances, valid states are IN_PROGRESS, SUCCEEDED, and FAILED.
targetResourceId string: The ID of the target resource on which the maintenance run occurs.
targetResourceType string: The type of the target resource on which the maintenance run occurs.

compartment_id str: The OCID of the compartment.
id str: The provider-assigned unique ID for this managed resource.
maintenance_runs GetMaintenanceRunsMaintenanceRun]: The list of maintenance_runs.
availability_domain str
filters GetMaintenanceRunsFilter]
maintenance_subtype str: Maintenance sub-type.
maintenance_type str: Maintenance type.
state str: The current state of the maintenance run. For Autonomous Database Serverless instances, valid states are IN_PROGRESS, SUCCEEDED, and FAILED.
target_resource_id str: The ID of the target resource on which the maintenance run occurs.
target_resource_type str: The type of the target resource on which the maintenance run occurs.

compartmentId String: The OCID of the compartment.
id String: The provider-assigned unique ID for this managed resource.
maintenanceRuns List<Property Map>: The list of maintenance_runs.
availabilityDomain String
filters List<Property Map>
maintenanceSubtype String: Maintenance sub-type.
maintenanceType String: Maintenance type.
state String: The current state of the maintenance run. For Autonomous Database Serverless instances, valid states are IN_PROGRESS, SUCCEEDED, and FAILED.
targetResourceId String: The ID of the target resource on which the maintenance run occurs.
targetResourceType String: The type of the target resource on which the maintenance run occurs.

Supporting Types

GetMaintenanceRunsFilter

Name string
Values List<string>
Regex bool

Name string
Values []string
Regex bool

name String
values List<String>
regex Boolean

name string
values string[]
regex boolean

name str
values Sequence[str]
regex bool

name String
values List<String>
regex Boolean

GetMaintenanceRunsMaintenanceRun

CompartmentId string: The compartment OCID.
CurrentCustomActionTimeoutInMins int: Extend current custom action timeout between the current database servers during waiting state, from 0 (zero) to 30 minutes.
CurrentPatchingComponent string: The name of the current infrastruture component that is getting patched.
CustomActionTimeoutInMins int: 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.
Description string: Description of the maintenance run.
DisplayName string: The user-friendly name for the maintenance run.
EstimatedComponentPatchingStartTime string: The estimated start time of the next infrastruture component patching operation.
EstimatedPatchingTimes List<GetMaintenanceRunsMaintenanceRunEstimatedPatchingTime>: The estimated total time required in minutes for all patching operations (database server, storage server, and network switch patching).
Id string: The OCID of the maintenance run.
IsCustomActionTimeoutEnabled bool: If true, enables the configuration of a custom action timeout (waiting period) between database servers patching operations.
IsDstFileUpdateEnabled bool: 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.
LifecycleDetails string: Additional information about the current lifecycle state.
MaintenanceSubtype string: The sub-type of the maintenance run.
MaintenanceType string: The maintenance type.
PatchFailureCount int: Contain the patch failure count.
PatchId string: 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.
PatchType string
PatchingEndTime string: The time when the patching operation ended.
PatchingMode string: Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.
PatchingStartTime string: The time when the patching operation started.
PatchingStatus string: The status of the patching operation.
PeerMaintenanceRunId string: The OCID of the maintenance run for the Autonomous Data Guard association's peer container database.
State string: A filter to return only resources that match the given lifecycle state exactly.
TargetDbServerVersion string: The target software version for the database server patching operation.
TargetResourceId string: The target resource ID.
TargetResourceType string: The type of the target resource. Accepted values are: AUTONOMOUS_CONTAINER_DATABASE, AUTONOMOUS_EXADATA_INFRASTRUCTURE, EXADATA_DB_SYSTEM
TargetStorageServerVersion string: The target Cell version that is to be patched to.
TimeEnded string: The date and time the maintenance run was completed.
TimeScheduled string: The date and time the maintenance run is scheduled to occur.
TimeStarted string: The date and time the maintenance run starts.

CompartmentId string: The compartment OCID.
CurrentCustomActionTimeoutInMins int: Extend current custom action timeout between the current database servers during waiting state, from 0 (zero) to 30 minutes.
CurrentPatchingComponent string: The name of the current infrastruture component that is getting patched.
CustomActionTimeoutInMins int: 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.
Description string: Description of the maintenance run.
DisplayName string: The user-friendly name for the maintenance run.
EstimatedComponentPatchingStartTime string: The estimated start time of the next infrastruture component patching operation.
EstimatedPatchingTimes []GetMaintenanceRunsMaintenanceRunEstimatedPatchingTime: The estimated total time required in minutes for all patching operations (database server, storage server, and network switch patching).
Id string: The OCID of the maintenance run.
IsCustomActionTimeoutEnabled bool: If true, enables the configuration of a custom action timeout (waiting period) between database servers patching operations.
IsDstFileUpdateEnabled bool: 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.
LifecycleDetails string: Additional information about the current lifecycle state.
MaintenanceSubtype string: The sub-type of the maintenance run.
MaintenanceType string: The maintenance type.
PatchFailureCount int: Contain the patch failure count.
PatchId string: 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.
PatchType string
PatchingEndTime string: The time when the patching operation ended.
PatchingMode string: Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.
PatchingStartTime string: The time when the patching operation started.
PatchingStatus string: The status of the patching operation.
PeerMaintenanceRunId string: The OCID of the maintenance run for the Autonomous Data Guard association's peer container database.
State string: A filter to return only resources that match the given lifecycle state exactly.
TargetDbServerVersion string: The target software version for the database server patching operation.
TargetResourceId string: The target resource ID.
TargetResourceType string: The type of the target resource. Accepted values are: AUTONOMOUS_CONTAINER_DATABASE, AUTONOMOUS_EXADATA_INFRASTRUCTURE, EXADATA_DB_SYSTEM
TargetStorageServerVersion string: The target Cell version that is to be patched to.
TimeEnded string: The date and time the maintenance run was completed.
TimeScheduled string: The date and time the maintenance run is scheduled to occur.
TimeStarted string: The date and time the maintenance run starts.

compartmentId String: The compartment OCID.
currentCustomActionTimeoutInMins Integer: Extend current custom action timeout between the current database servers during waiting state, from 0 (zero) to 30 minutes.
currentPatchingComponent String: The name of the current infrastruture component that is getting patched.
customActionTimeoutInMins Integer: 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.
description String: Description of the maintenance run.
displayName String: The user-friendly name for the maintenance run.
estimatedComponentPatchingStartTime String: The estimated start time of the next infrastruture component patching operation.
estimatedPatchingTimes List<GetMaintenanceRunsMaintenanceRunEstimatedPatchingTime>: The estimated total time required in minutes for all patching operations (database server, storage server, and network switch patching).
id String: The OCID of the maintenance run.
isCustomActionTimeoutEnabled Boolean: If true, enables the configuration of a custom action timeout (waiting period) between database servers patching operations.
isDstFileUpdateEnabled Boolean: 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.
lifecycleDetails String: Additional information about the current lifecycle state.
maintenanceSubtype String: The sub-type of the maintenance run.
maintenanceType String: The maintenance type.
patchFailureCount Integer: Contain the patch failure count.
patchId String: 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.
patchType String
patchingEndTime String: The time when the patching operation ended.
patchingMode String: Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.
patchingStartTime String: The time when the patching operation started.
patchingStatus String: The status of the patching operation.
peerMaintenanceRunId String: The OCID of the maintenance run for the Autonomous Data Guard association's peer container database.
state String: A filter to return only resources that match the given lifecycle state exactly.
targetDbServerVersion String: The target software version for the database server patching operation.
targetResourceId String: The target resource ID.
targetResourceType String: The type of the target resource. Accepted values are: AUTONOMOUS_CONTAINER_DATABASE, AUTONOMOUS_EXADATA_INFRASTRUCTURE, EXADATA_DB_SYSTEM
targetStorageServerVersion String: The target Cell version that is to be patched to.
timeEnded String: The date and time the maintenance run was completed.
timeScheduled String: The date and time the maintenance run is scheduled to occur.
timeStarted String: The date and time the maintenance run starts.

compartmentId string: The compartment OCID.
currentCustomActionTimeoutInMins number: Extend current custom action timeout between the current database servers during waiting state, from 0 (zero) to 30 minutes.
currentPatchingComponent string: The name of the current infrastruture component that is getting patched.
customActionTimeoutInMins number: 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.
description string: Description of the maintenance run.
displayName string: The user-friendly name for the maintenance run.
estimatedComponentPatchingStartTime string: The estimated start time of the next infrastruture component patching operation.
estimatedPatchingTimes GetMaintenanceRunsMaintenanceRunEstimatedPatchingTime[]: The estimated total time required in minutes for all patching operations (database server, storage server, and network switch patching).
id string: The OCID of the maintenance run.
isCustomActionTimeoutEnabled boolean: If true, enables the configuration of a custom action timeout (waiting period) between database servers patching operations.
isDstFileUpdateEnabled boolean: 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.
lifecycleDetails string: Additional information about the current lifecycle state.
maintenanceSubtype string: The sub-type of the maintenance run.
maintenanceType string: The maintenance type.
patchFailureCount number: Contain the patch failure count.
patchId string: 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.
patchType string
patchingEndTime string: The time when the patching operation ended.
patchingMode string: Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.
patchingStartTime string: The time when the patching operation started.
patchingStatus string: The status of the patching operation.
peerMaintenanceRunId string: The OCID of the maintenance run for the Autonomous Data Guard association's peer container database.
state string: A filter to return only resources that match the given lifecycle state exactly.
targetDbServerVersion string: The target software version for the database server patching operation.
targetResourceId string: The target resource ID.
targetResourceType string: The type of the target resource. Accepted values are: AUTONOMOUS_CONTAINER_DATABASE, AUTONOMOUS_EXADATA_INFRASTRUCTURE, EXADATA_DB_SYSTEM
targetStorageServerVersion string: The target Cell version that is to be patched to.
timeEnded string: The date and time the maintenance run was completed.
timeScheduled string: The date and time the maintenance run is scheduled to occur.
timeStarted string: The date and time the maintenance run starts.

compartment_id str: The compartment OCID.
current_custom_action_timeout_in_mins int: Extend current custom action timeout between the current database servers during waiting state, from 0 (zero) to 30 minutes.
current_patching_component str: The name of the current infrastruture component that is getting patched.
custom_action_timeout_in_mins int: 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.
description str: Description of the maintenance run.
display_name str: The user-friendly name for the maintenance run.
estimated_component_patching_start_time str: The estimated start time of the next infrastruture component patching operation.
estimated_patching_times GetMaintenanceRunsMaintenanceRunEstimatedPatchingTime]: The estimated total time required in minutes for all patching operations (database server, storage server, and network switch patching).
id str: The OCID of the maintenance run.
is_custom_action_timeout_enabled bool: If true, enables the configuration of a custom action timeout (waiting period) between database servers patching operations.
is_dst_file_update_enabled bool: 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.
lifecycle_details str: Additional information about the current lifecycle state.
maintenance_subtype str: The sub-type of the maintenance run.
maintenance_type str: The maintenance type.
patch_failure_count int: Contain the patch failure count.
patch_id str: 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.
patch_type str
patching_end_time str: The time when the patching operation ended.
patching_mode str: Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.
patching_start_time str: The time when the patching operation started.
patching_status str: The status of the patching operation.
peer_maintenance_run_id str: The OCID of the maintenance run for the Autonomous Data Guard association's peer container database.
state str: A filter to return only resources that match the given lifecycle state exactly.
target_db_server_version str: The target software version for the database server patching operation.
target_resource_id str: The target resource ID.
target_resource_type str: The type of the target resource. Accepted values are: AUTONOMOUS_CONTAINER_DATABASE, AUTONOMOUS_EXADATA_INFRASTRUCTURE, EXADATA_DB_SYSTEM
target_storage_server_version str: The target Cell version that is to be patched to.
time_ended str: The date and time the maintenance run was completed.
time_scheduled str: The date and time the maintenance run is scheduled to occur.
time_started str: The date and time the maintenance run starts.

compartmentId String: The compartment OCID.
currentCustomActionTimeoutInMins Number: Extend current custom action timeout between the current database servers during waiting state, from 0 (zero) to 30 minutes.
currentPatchingComponent String: The name of the current infrastruture component that is getting patched.
customActionTimeoutInMins Number: 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.
description String: Description of the maintenance run.
displayName String: The user-friendly name for the maintenance run.
estimatedComponentPatchingStartTime String: The estimated start time of the next infrastruture component patching operation.
estimatedPatchingTimes List<Property Map>: The estimated total time required in minutes for all patching operations (database server, storage server, and network switch patching).
id String: The OCID of the maintenance run.
isCustomActionTimeoutEnabled Boolean: If true, enables the configuration of a custom action timeout (waiting period) between database servers patching operations.
isDstFileUpdateEnabled Boolean: 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.
lifecycleDetails String: Additional information about the current lifecycle state.
maintenanceSubtype String: The sub-type of the maintenance run.
maintenanceType String: The maintenance type.
patchFailureCount Number: Contain the patch failure count.
patchId String: 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.
patchType String
patchingEndTime String: The time when the patching operation ended.
patchingMode String: Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.
patchingStartTime String: The time when the patching operation started.
patchingStatus String: The status of the patching operation.
peerMaintenanceRunId String: The OCID of the maintenance run for the Autonomous Data Guard association's peer container database.
state String: A filter to return only resources that match the given lifecycle state exactly.
targetDbServerVersion String: The target software version for the database server patching operation.
targetResourceId String: The target resource ID.
targetResourceType String: The type of the target resource. Accepted values are: AUTONOMOUS_CONTAINER_DATABASE, AUTONOMOUS_EXADATA_INFRASTRUCTURE, EXADATA_DB_SYSTEM
targetStorageServerVersion String: The target Cell version that is to be patched to.
timeEnded String: The date and time the maintenance run was completed.
timeScheduled String: The date and time the maintenance run is scheduled to occur.
timeStarted String: The date and time the maintenance run starts.

GetMaintenanceRunsMaintenanceRunEstimatedPatchingTime

EstimatedDbServerPatchingTime int: The estimated time required in minutes for database server patching.
EstimatedNetworkSwitchesPatchingTime int: The estimated time required in minutes for network switch patching.
EstimatedStorageServerPatchingTime int: The estimated time required in minutes for storage server patching.
TotalEstimatedPatchingTime int: The estimated total time required in minutes for all patching operations.

EstimatedDbServerPatchingTime int: The estimated time required in minutes for database server patching.
EstimatedNetworkSwitchesPatchingTime int: The estimated time required in minutes for network switch patching.
EstimatedStorageServerPatchingTime int: The estimated time required in minutes for storage server patching.
TotalEstimatedPatchingTime int: The estimated total time required in minutes for all patching operations.

estimatedDbServerPatchingTime Integer: The estimated time required in minutes for database server patching.
estimatedNetworkSwitchesPatchingTime Integer: The estimated time required in minutes for network switch patching.
estimatedStorageServerPatchingTime Integer: The estimated time required in minutes for storage server patching.
totalEstimatedPatchingTime Integer: The estimated total time required in minutes for all patching operations.

estimatedDbServerPatchingTime number: The estimated time required in minutes for database server patching.
estimatedNetworkSwitchesPatchingTime number: The estimated time required in minutes for network switch patching.
estimatedStorageServerPatchingTime number: The estimated time required in minutes for storage server patching.
totalEstimatedPatchingTime number: The estimated total time required in minutes for all patching operations.

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

estimatedDbServerPatchingTime Number: The estimated time required in minutes for database server patching.
estimatedNetworkSwitchesPatchingTime Number: The estimated time required in minutes for network switch patching.
estimatedStorageServerPatchingTime Number: The estimated time required in minutes for storage server patching.
totalEstimatedPatchingTime Number: The estimated total time required in minutes for all patching operations.

Package Details

Repository: oci pulumi/pulumi-oci
License: Apache-2.0
Notes: This Pulumi package is based on the oci Terraform Provider.

Oracle Cloud Infrastructure v1.16.0 published on Thursday, Nov 2, 2023 by Pulumi

pulumi/pulumi-oci

oci.Database.getMaintenanceRuns

On this page

On this page

Example Usage

Using getMaintenanceRuns

getMaintenanceRuns Result

Supporting Types

GetMaintenanceRunsFilter

GetMaintenanceRunsMaintenanceRun

GetMaintenanceRunsMaintenanceRunEstimatedPatchingTime

Package Details

On this page

On this page