Oracle Cloud Infrastructure v1.16.1, Nov 22 23

Oracle Cloud Infrastructure v1.16.1 published on Wednesday, Nov 22, 2023 by Pulumi

oci.Database.getDatabaseMaintenanceRunHistories

Explore with Pulumi AI

Oracle Cloud Infrastructure v1.16.1 published on Wednesday, Nov 22, 2023 by Pulumi

Example Usage

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

return await Deployment.RunAsync(() => 
{
    var testMaintenanceRunHistories = Oci.Database.GetDatabaseMaintenanceRunHistories.Invoke(new()
    {
        CompartmentId = @var.Compartment_id,
        AvailabilityDomain = @var.Maintenance_run_history_availability_domain,
        MaintenanceType = @var.Maintenance_run_history_maintenance_type,
        State = @var.Maintenance_run_history_state,
        TargetResourceId = oci_database_target_resource.Test_target_resource.Id,
        TargetResourceType = @var.Maintenance_run_history_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.GetDatabaseMaintenanceRunHistories(ctx, &database.GetDatabaseMaintenanceRunHistoriesArgs{
			CompartmentId:      _var.Compartment_id,
			AvailabilityDomain: pulumi.StringRef(_var.Maintenance_run_history_availability_domain),
			MaintenanceType:    pulumi.StringRef(_var.Maintenance_run_history_maintenance_type),
			State:              pulumi.StringRef(_var.Maintenance_run_history_state),
			TargetResourceId:   pulumi.StringRef(oci_database_target_resource.Test_target_resource.Id),
			TargetResourceType: pulumi.StringRef(_var.Maintenance_run_history_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.GetDatabaseMaintenanceRunHistoriesArgs;
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 testMaintenanceRunHistories = DatabaseFunctions.getDatabaseMaintenanceRunHistories(GetDatabaseMaintenanceRunHistoriesArgs.builder()
            .compartmentId(var_.compartment_id())
            .availabilityDomain(var_.maintenance_run_history_availability_domain())
            .maintenanceType(var_.maintenance_run_history_maintenance_type())
            .state(var_.maintenance_run_history_state())
            .targetResourceId(oci_database_target_resource.test_target_resource().id())
            .targetResourceType(var_.maintenance_run_history_target_resource_type())
            .build());

    }
}

import pulumi
import pulumi_oci as oci

test_maintenance_run_histories = oci.Database.get_database_maintenance_run_histories(compartment_id=var["compartment_id"],
    availability_domain=var["maintenance_run_history_availability_domain"],
    maintenance_type=var["maintenance_run_history_maintenance_type"],
    state=var["maintenance_run_history_state"],
    target_resource_id=oci_database_target_resource["test_target_resource"]["id"],
    target_resource_type=var["maintenance_run_history_target_resource_type"])

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

const testMaintenanceRunHistories = oci.Database.getDatabaseMaintenanceRunHistories({
    compartmentId: _var.compartment_id,
    availabilityDomain: _var.maintenance_run_history_availability_domain,
    maintenanceType: _var.maintenance_run_history_maintenance_type,
    state: _var.maintenance_run_history_state,
    targetResourceId: oci_database_target_resource.test_target_resource.id,
    targetResourceType: _var.maintenance_run_history_target_resource_type,
});

variables:
  testMaintenanceRunHistories:
    fn::invoke:
      Function: oci:Database:getDatabaseMaintenanceRunHistories
      Arguments:
        compartmentId: ${var.compartment_id}
        availabilityDomain: ${var.maintenance_run_history_availability_domain}
        maintenanceType: ${var.maintenance_run_history_maintenance_type}
        state: ${var.maintenance_run_history_state}
        targetResourceId: ${oci_database_target_resource.test_target_resource.id}
        targetResourceType: ${var.maintenance_run_history_target_resource_type}

Using getDatabaseMaintenanceRunHistories

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 getDatabaseMaintenanceRunHistories(args: GetDatabaseMaintenanceRunHistoriesArgs, opts?: InvokeOptions): Promise<GetDatabaseMaintenanceRunHistoriesResult>
function getDatabaseMaintenanceRunHistoriesOutput(args: GetDatabaseMaintenanceRunHistoriesOutputArgs, opts?: InvokeOptions): Output<GetDatabaseMaintenanceRunHistoriesResult>

def get_database_maintenance_run_histories(availability_domain: Optional[str] = None,
                                           compartment_id: Optional[str] = None,
                                           filters: Optional[Sequence[_database.GetDatabaseMaintenanceRunHistoriesFilter]] = 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) -> GetDatabaseMaintenanceRunHistoriesResult
def get_database_maintenance_run_histories_output(availability_domain: Optional[pulumi.Input[str]] = None,
                                           compartment_id: Optional[pulumi.Input[str]] = None,
                                           filters: Optional[pulumi.Input[Sequence[pulumi.Input[_database.GetDatabaseMaintenanceRunHistoriesFilterArgs]]]] = 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[GetDatabaseMaintenanceRunHistoriesResult]

func GetDatabaseMaintenanceRunHistories(ctx *Context, args *GetDatabaseMaintenanceRunHistoriesArgs, opts ...InvokeOption) (*GetDatabaseMaintenanceRunHistoriesResult, error)
func GetDatabaseMaintenanceRunHistoriesOutput(ctx *Context, args *GetDatabaseMaintenanceRunHistoriesOutputArgs, opts ...InvokeOption) GetDatabaseMaintenanceRunHistoriesResultOutput

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

public static class GetDatabaseMaintenanceRunHistories 
{
    public static Task<GetDatabaseMaintenanceRunHistoriesResult> InvokeAsync(GetDatabaseMaintenanceRunHistoriesArgs args, InvokeOptions? opts = null)
    public static Output<GetDatabaseMaintenanceRunHistoriesResult> Invoke(GetDatabaseMaintenanceRunHistoriesInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetDatabaseMaintenanceRunHistoriesResult> getDatabaseMaintenanceRunHistories(GetDatabaseMaintenanceRunHistoriesArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

fn::invoke:
  function: oci:Database/getDatabaseMaintenanceRunHistories:getDatabaseMaintenanceRunHistories
  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<GetDatabaseMaintenanceRunHistoriesFilter>
MaintenanceType string: The maintenance type.
State string: The state of the maintenance run history.
TargetResourceId string: The target resource ID.
TargetResourceType string: The type of the target resource.

CompartmentId string: The compartment OCID.
AvailabilityDomain string: A filter to return only resources that match the given availability domain exactly.
Filters []GetDatabaseMaintenanceRunHistoriesFilter
MaintenanceType string: The maintenance type.
State string: The state of the maintenance run history.
TargetResourceId string: The target resource ID.
TargetResourceType string: The type of the target resource.

compartmentId String: The compartment OCID.
availabilityDomain String: A filter to return only resources that match the given availability domain exactly.
filters List<GetMaintenanceRunHistoriesFilter>
maintenanceType String: The maintenance type.
state String: The state of the maintenance run history.
targetResourceId String: The target resource ID.
targetResourceType String: The type of the target resource.

compartmentId string: The compartment OCID.
availabilityDomain string: A filter to return only resources that match the given availability domain exactly.
filters GetDatabaseMaintenanceRunHistoriesFilter[]
maintenanceType string: The maintenance type.
state string: The state of the maintenance run history.
targetResourceId string: The target resource ID.
targetResourceType string: The type of the target resource.

compartment_id str: The compartment OCID.
availability_domain str: A filter to return only resources that match the given availability domain exactly.
filters GetDatabaseMaintenanceRunHistoriesFilter]
maintenance_type str: The maintenance type.
state str: The state of the maintenance run history.
target_resource_id str: The target resource ID.
target_resource_type str: The type of the target resource.

compartmentId String: The compartment OCID.
availabilityDomain String: A filter to return only resources that match the given availability domain exactly.
filters List<Property Map>
maintenanceType String: The maintenance type.
state String: The state of the maintenance run history.
targetResourceId String: The target resource ID.
targetResourceType String: The type of the target resource.

getDatabaseMaintenanceRunHistories 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.
MaintenanceRunHistories List<GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistory>: The list of maintenance_run_histories.
AvailabilityDomain string
Filters List<GetDatabaseMaintenanceRunHistoriesFilter>
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.
MaintenanceRunHistories []GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistory: The list of maintenance_run_histories.
AvailabilityDomain string
Filters []GetDatabaseMaintenanceRunHistoriesFilter
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.
maintenanceRunHistories List<GetMaintenanceRunHistoriesMaintenanceRunHistory>: The list of maintenance_run_histories.
availabilityDomain String
filters List<GetMaintenanceRunHistoriesFilter>
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.
maintenanceRunHistories GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistory[]: The list of maintenance_run_histories.
availabilityDomain string
filters GetDatabaseMaintenanceRunHistoriesFilter[]
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_run_histories GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistory]: The list of maintenance_run_histories.
availability_domain str
filters GetDatabaseMaintenanceRunHistoriesFilter]
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.
maintenanceRunHistories List<Property Map>: The list of maintenance_run_histories.
availabilityDomain String
filters List<Property Map>
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

GetDatabaseMaintenanceRunHistoriesFilter

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

GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistory

DbServersHistoryDetails List<GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryDbServersHistoryDetail>: List of database server history details.
Id string: The OCID of the maintenance run.
MaintenanceRunDetails List<GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryMaintenanceRunDetail>: Details of a maintenance run.

DbServersHistoryDetails []GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryDbServersHistoryDetail: List of database server history details.
Id string: The OCID of the maintenance run.
MaintenanceRunDetails []GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryMaintenanceRunDetail: Details of a maintenance run.

dbServersHistoryDetails List<GetMaintenanceRunHistoriesMaintenanceRunHistoryDbServersHistoryDetail>: List of database server history details.
id String: The OCID of the maintenance run.
maintenanceRunDetails List<GetMaintenanceRunHistoriesMaintenanceRunHistoryMaintenanceRunDetail>: Details of a maintenance run.

dbServersHistoryDetails GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryDbServersHistoryDetail[]: List of database server history details.
id string: The OCID of the maintenance run.
maintenanceRunDetails GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryMaintenanceRunDetail[]: Details of a maintenance run.

db_servers_history_details GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryDbServersHistoryDetail]: List of database server history details.
id str: The OCID of the maintenance run.
maintenance_run_details GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryMaintenanceRunDetail]: Details of a maintenance run.

dbServersHistoryDetails List<Property Map>: List of database server history details.
id String: The OCID of the maintenance run.
maintenanceRunDetails List<Property Map>: Details of a maintenance run.

GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryDbServersHistoryDetail

DbServerPatchingDetails List<GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryDbServersHistoryDetailDbServerPatchingDetail>: The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.
DisplayName string: The user-friendly name for the maintenance run.
Id string: The OCID of the maintenance run.

DbServerPatchingDetails []GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryDbServersHistoryDetailDbServerPatchingDetail: The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.
DisplayName string: The user-friendly name for the maintenance run.
Id string: The OCID of the maintenance run.

dbServerPatchingDetails List<GetMaintenanceRunHistoriesMaintenanceRunHistoryDbServersHistoryDetailDbServerPatchingDetail>: The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.
displayName String: The user-friendly name for the maintenance run.
id String: The OCID of the maintenance run.

dbServerPatchingDetails GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryDbServersHistoryDetailDbServerPatchingDetail[]: The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.
displayName string: The user-friendly name for the maintenance run.
id string: The OCID of the maintenance run.

db_server_patching_details GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryDbServersHistoryDetailDbServerPatchingDetail]: The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.
display_name str: The user-friendly name for the maintenance run.
id str: The OCID of the maintenance run.

dbServerPatchingDetails List<Property Map>: The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.
displayName String: The user-friendly name for the maintenance run.
id String: The OCID of the maintenance run.

GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryDbServersHistoryDetailDbServerPatchingDetail

EstimatedPatchDuration int: Estimated time, in minutes, to patch one database server.
PatchingStatus string: The status of the patching operation.
TimePatchingEnded string: The time when the patching operation ended.
TimePatchingStarted string: The time when the patching operation started.

EstimatedPatchDuration int: Estimated time, in minutes, to patch one database server.
PatchingStatus string: The status of the patching operation.
TimePatchingEnded string: The time when the patching operation ended.
TimePatchingStarted string: The time when the patching operation started.

estimatedPatchDuration Integer: Estimated time, in minutes, to patch one database server.
patchingStatus String: The status of the patching operation.
timePatchingEnded String: The time when the patching operation ended.
timePatchingStarted String: The time when the patching operation started.

estimatedPatchDuration number: Estimated time, in minutes, to patch one database server.
patchingStatus string: The status of the patching operation.
timePatchingEnded string: The time when the patching operation ended.
timePatchingStarted string: The time when the patching operation started.

estimated_patch_duration int: Estimated time, in minutes, to patch one database server.
patching_status str: The status of the patching operation.
time_patching_ended str: The time when the patching operation ended.
time_patching_started str: The time when the patching operation started.

estimatedPatchDuration Number: Estimated time, in minutes, to patch one database server.
patchingStatus String: The status of the patching operation.
timePatchingEnded String: The time when the patching operation ended.
timePatchingStarted String: The time when the patching operation started.

GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryMaintenanceRunDetail

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<GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryMaintenanceRunDetailEstimatedPatchingTime>: 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: Maintenance sub-type.
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.
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: The state of the maintenance run history.
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.
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 []GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryMaintenanceRunDetailEstimatedPatchingTime: 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: Maintenance sub-type.
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.
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: The state of the maintenance run history.
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.
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<GetMaintenanceRunHistoriesMaintenanceRunHistoryMaintenanceRunDetailEstimatedPatchingTime>: 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: Maintenance sub-type.
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.
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: The state of the maintenance run history.
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.
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 GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryMaintenanceRunDetailEstimatedPatchingTime[]: 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: Maintenance sub-type.
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.
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: The state of the maintenance run history.
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.
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 GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryMaintenanceRunDetailEstimatedPatchingTime]: 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: Maintenance sub-type.
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.
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: The state of the maintenance run history.
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.
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: Maintenance sub-type.
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.
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: The state of the maintenance run history.
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.
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.

GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryMaintenanceRunDetailEstimatedPatchingTime

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.1 published on Wednesday, Nov 22, 2023 by Pulumi

pulumi/pulumi-oci

oci.Database.getDatabaseMaintenanceRunHistories

On this page

On this page

Example Usage

Using getDatabaseMaintenanceRunHistories

getDatabaseMaintenanceRunHistories Result

Supporting Types

GetDatabaseMaintenanceRunHistoriesFilter

GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistory

GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryDbServersHistoryDetail

GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryDbServersHistoryDetailDbServerPatchingDetail

GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryMaintenanceRunDetail

GetDatabaseMaintenanceRunHistoriesMaintenanceRunHistoryMaintenanceRunDetailEstimatedPatchingTime

Package Details

On this page

On this page