Oracle Cloud Infrastructure v0.20.0, May 31 23

oci.Database.getDatabasePdbConversionHistoryEntries

Explore with Pulumi AI

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

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

Example Usage

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

return await Deployment.RunAsync(() => 
{
    var testDatabasePdbConversionHistoryEntries = Oci.Database.GetDatabasePdbConversionHistoryEntries.Invoke(new()
    {
        DatabaseId = oci_database_database.Test_database.Id,
        PdbConversionAction = @var.Database_pdb_conversion_history_entry_pdb_conversion_action,
        State = @var.Database_pdb_conversion_history_entry_state,
    });

});

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.GetDatabasePdbConversionHistoryEntries(ctx, &database.GetDatabasePdbConversionHistoryEntriesArgs{
			DatabaseId:          oci_database_database.Test_database.Id,
			PdbConversionAction: pulumi.StringRef(_var.Database_pdb_conversion_history_entry_pdb_conversion_action),
			State:               pulumi.StringRef(_var.Database_pdb_conversion_history_entry_state),
		}, 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.GetDatabasePdbConversionHistoryEntriesArgs;
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 testDatabasePdbConversionHistoryEntries = DatabaseFunctions.getDatabasePdbConversionHistoryEntries(GetDatabasePdbConversionHistoryEntriesArgs.builder()
            .databaseId(oci_database_database.test_database().id())
            .pdbConversionAction(var_.database_pdb_conversion_history_entry_pdb_conversion_action())
            .state(var_.database_pdb_conversion_history_entry_state())
            .build());

    }
}

import pulumi
import pulumi_oci as oci

test_database_pdb_conversion_history_entries = oci.Database.get_database_pdb_conversion_history_entries(database_id=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
    pdb_conversion_action=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
    state=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))

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

const testDatabasePdbConversionHistoryEntries = oci.Database.getDatabasePdbConversionHistoryEntries({
    databaseId: oci_database_database.test_database.id,
    pdbConversionAction: _var.database_pdb_conversion_history_entry_pdb_conversion_action,
    state: _var.database_pdb_conversion_history_entry_state,
});

variables:
  testDatabasePdbConversionHistoryEntries:
    fn::invoke:
      Function: oci:Database:getDatabasePdbConversionHistoryEntries
      Arguments:
        databaseId: ${oci_database_database.test_database.id}
        pdbConversionAction: ${var.database_pdb_conversion_history_entry_pdb_conversion_action}
        state: ${var.database_pdb_conversion_history_entry_state}

Using getDatabasePdbConversionHistoryEntries

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 getDatabasePdbConversionHistoryEntries(args: GetDatabasePdbConversionHistoryEntriesArgs, opts?: InvokeOptions): Promise<GetDatabasePdbConversionHistoryEntriesResult>
function getDatabasePdbConversionHistoryEntriesOutput(args: GetDatabasePdbConversionHistoryEntriesOutputArgs, opts?: InvokeOptions): Output<GetDatabasePdbConversionHistoryEntriesResult>

def get_database_pdb_conversion_history_entries(database_id: Optional[str] = None,
                                                filters: Optional[Sequence[_database.GetDatabasePdbConversionHistoryEntriesFilter]] = None,
                                                pdb_conversion_action: Optional[str] = None,
                                                state: Optional[str] = None,
                                                opts: Optional[InvokeOptions] = None) -> GetDatabasePdbConversionHistoryEntriesResult
def get_database_pdb_conversion_history_entries_output(database_id: Optional[pulumi.Input[str]] = None,
                                                filters: Optional[pulumi.Input[Sequence[pulumi.Input[_database.GetDatabasePdbConversionHistoryEntriesFilterArgs]]]] = None,
                                                pdb_conversion_action: Optional[pulumi.Input[str]] = None,
                                                state: Optional[pulumi.Input[str]] = None,
                                                opts: Optional[InvokeOptions] = None) -> Output[GetDatabasePdbConversionHistoryEntriesResult]

func GetDatabasePdbConversionHistoryEntries(ctx *Context, args *GetDatabasePdbConversionHistoryEntriesArgs, opts ...InvokeOption) (*GetDatabasePdbConversionHistoryEntriesResult, error)
func GetDatabasePdbConversionHistoryEntriesOutput(ctx *Context, args *GetDatabasePdbConversionHistoryEntriesOutputArgs, opts ...InvokeOption) GetDatabasePdbConversionHistoryEntriesResultOutput

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

public static class GetDatabasePdbConversionHistoryEntries 
{
    public static Task<GetDatabasePdbConversionHistoryEntriesResult> InvokeAsync(GetDatabasePdbConversionHistoryEntriesArgs args, InvokeOptions? opts = null)
    public static Output<GetDatabasePdbConversionHistoryEntriesResult> Invoke(GetDatabasePdbConversionHistoryEntriesInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetDatabasePdbConversionHistoryEntriesResult> getDatabasePdbConversionHistoryEntries(GetDatabasePdbConversionHistoryEntriesArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

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

The following arguments are supported:

DatabaseId string: The database OCID.
Filters List<GetDatabasePdbConversionHistoryEntriesFilter>
PdbConversionAction string: A filter to return only the pluggable database conversion history entries that match the specified conversion action. For example, you can use this filter to return only entries for the precheck operation.
State string: A filter to return only the pluggable database conversion history entries that match the specified lifecycle state. For example, you can use this filter to return only entries in the "failed" lifecycle state.

DatabaseId string: The database OCID.
Filters []GetDatabasePdbConversionHistoryEntriesFilter
PdbConversionAction string: A filter to return only the pluggable database conversion history entries that match the specified conversion action. For example, you can use this filter to return only entries for the precheck operation.
State string: A filter to return only the pluggable database conversion history entries that match the specified lifecycle state. For example, you can use this filter to return only entries in the "failed" lifecycle state.

databaseId String: The database OCID.
filters List<GetPdbConversionHistoryEntriesFilter>
pdbConversionAction String: A filter to return only the pluggable database conversion history entries that match the specified conversion action. For example, you can use this filter to return only entries for the precheck operation.
state String: A filter to return only the pluggable database conversion history entries that match the specified lifecycle state. For example, you can use this filter to return only entries in the "failed" lifecycle state.

databaseId string: The database OCID.
filters GetDatabasePdbConversionHistoryEntriesFilter[]
pdbConversionAction string: A filter to return only the pluggable database conversion history entries that match the specified conversion action. For example, you can use this filter to return only entries for the precheck operation.
state string: A filter to return only the pluggable database conversion history entries that match the specified lifecycle state. For example, you can use this filter to return only entries in the "failed" lifecycle state.

database_id str: The database OCID.
filters GetDatabasePdbConversionHistoryEntriesFilter]
pdb_conversion_action str: A filter to return only the pluggable database conversion history entries that match the specified conversion action. For example, you can use this filter to return only entries for the precheck operation.
state str: A filter to return only the pluggable database conversion history entries that match the specified lifecycle state. For example, you can use this filter to return only entries in the "failed" lifecycle state.

databaseId String: The database OCID.
filters List<Property Map>
pdbConversionAction String: A filter to return only the pluggable database conversion history entries that match the specified conversion action. For example, you can use this filter to return only entries for the precheck operation.
state String: A filter to return only the pluggable database conversion history entries that match the specified lifecycle state. For example, you can use this filter to return only entries in the "failed" lifecycle state.

getDatabasePdbConversionHistoryEntries Result

The following output properties are available:

DatabaseId string
Id string: The provider-assigned unique ID for this managed resource.
PdbConversionHistoryEntries List<GetDatabasePdbConversionHistoryEntriesPdbConversionHistoryEntry>: The list of pdb_conversion_history_entries.
Filters List<GetDatabasePdbConversionHistoryEntriesFilter>
PdbConversionAction string
State string: Status of an operation performed during the conversion of a non-container database to a pluggable database.

DatabaseId string
Id string: The provider-assigned unique ID for this managed resource.
PdbConversionHistoryEntries []GetDatabasePdbConversionHistoryEntriesPdbConversionHistoryEntry: The list of pdb_conversion_history_entries.
Filters []GetDatabasePdbConversionHistoryEntriesFilter
PdbConversionAction string
State string: Status of an operation performed during the conversion of a non-container database to a pluggable database.

databaseId String
id String: The provider-assigned unique ID for this managed resource.
pdbConversionHistoryEntries List<GetPdbConversionHistoryEntriesPdbConversionHistoryEntry>: The list of pdb_conversion_history_entries.
filters List<GetPdbConversionHistoryEntriesFilter>
pdbConversionAction String
state String: Status of an operation performed during the conversion of a non-container database to a pluggable database.

databaseId string
id string: The provider-assigned unique ID for this managed resource.
pdbConversionHistoryEntries GetDatabasePdbConversionHistoryEntriesPdbConversionHistoryEntry[]: The list of pdb_conversion_history_entries.
filters GetDatabasePdbConversionHistoryEntriesFilter[]
pdbConversionAction string
state string: Status of an operation performed during the conversion of a non-container database to a pluggable database.

database_id str
id str: The provider-assigned unique ID for this managed resource.
pdb_conversion_history_entries GetDatabasePdbConversionHistoryEntriesPdbConversionHistoryEntry]: The list of pdb_conversion_history_entries.
filters GetDatabasePdbConversionHistoryEntriesFilter]
pdb_conversion_action str
state str: Status of an operation performed during the conversion of a non-container database to a pluggable database.

databaseId String
id String: The provider-assigned unique ID for this managed resource.
pdbConversionHistoryEntries List<Property Map>: The list of pdb_conversion_history_entries.
filters List<Property Map>
pdbConversionAction String
state String: Status of an operation performed during the conversion of a non-container database to a pluggable database.

Supporting Types

GetDatabasePdbConversionHistoryEntriesFilter

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

GetDatabasePdbConversionHistoryEntriesPdbConversionHistoryEntry

Action string

The operations used to convert a non-container database to a pluggable database.

Use PRECHECK to run a pre-check operation on non-container database prior to converting it into a pluggable database.
Use CONVERT to convert a non-container database into a pluggable database.
Use SYNC if the non-container database was manually converted into a pluggable database using the dbcli command-line utility. Databases may need to be converted manually if the CONVERT action fails when converting a non-container database using the API.
Use SYNC_ROLLBACK if the conversion of a non-container database into a pluggable database was manually rolled back using the dbcli command line utility. Conversions may need to be manually rolled back if the CONVERT action fails when converting a non-container database using the API.

AdditionalCdbParams string

Additional container database parameter.

CdbName string

The database name. The name must begin with an alphabetic character and can contain a maximum of 8 alphanumeric characters. Special characters are not permitted. The database name must be unique in the tenancy.

Id string

The OCID of the database conversion history.

LifecycleDetails string

Additional information about the current lifecycle state for the conversion operation.

SourceDatabaseId string

The OCID of the database.

State string

A filter to return only the pluggable database conversion history entries that match the specified lifecycle state. For example, you can use this filter to return only entries in the "failed" lifecycle state.

Target string

The target container database of the pluggable database created by the database conversion operation. Currently, the database conversion operation only supports creating the pluggable database in a new container database.

Use NEW_DATABASE to specify that the pluggable database be created within a new container database in the same database home.

TargetDatabaseId string

The OCID of the database.

TimeEnded string

The date and time when the database conversion operation ended.

TimeStarted string

The date and time when the database conversion operation started.

Action string

The operations used to convert a non-container database to a pluggable database.

Use PRECHECK to run a pre-check operation on non-container database prior to converting it into a pluggable database.
Use CONVERT to convert a non-container database into a pluggable database.
Use SYNC if the non-container database was manually converted into a pluggable database using the dbcli command-line utility. Databases may need to be converted manually if the CONVERT action fails when converting a non-container database using the API.
Use SYNC_ROLLBACK if the conversion of a non-container database into a pluggable database was manually rolled back using the dbcli command line utility. Conversions may need to be manually rolled back if the CONVERT action fails when converting a non-container database using the API.

AdditionalCdbParams string

Additional container database parameter.

CdbName string

Id string

The OCID of the database conversion history.

LifecycleDetails string

Additional information about the current lifecycle state for the conversion operation.

SourceDatabaseId string

The OCID of the database.

State string

Target string

Use NEW_DATABASE to specify that the pluggable database be created within a new container database in the same database home.

TargetDatabaseId string

The OCID of the database.

TimeEnded string

The date and time when the database conversion operation ended.

TimeStarted string

The date and time when the database conversion operation started.

action String

The operations used to convert a non-container database to a pluggable database.

Use PRECHECK to run a pre-check operation on non-container database prior to converting it into a pluggable database.
Use CONVERT to convert a non-container database into a pluggable database.
Use SYNC if the non-container database was manually converted into a pluggable database using the dbcli command-line utility. Databases may need to be converted manually if the CONVERT action fails when converting a non-container database using the API.
Use SYNC_ROLLBACK if the conversion of a non-container database into a pluggable database was manually rolled back using the dbcli command line utility. Conversions may need to be manually rolled back if the CONVERT action fails when converting a non-container database using the API.

additionalCdbParams String

Additional container database parameter.

cdbName String

id String

The OCID of the database conversion history.

lifecycleDetails String

Additional information about the current lifecycle state for the conversion operation.

sourceDatabaseId String

The OCID of the database.

state String

target String

Use NEW_DATABASE to specify that the pluggable database be created within a new container database in the same database home.

targetDatabaseId String

The OCID of the database.

timeEnded String

The date and time when the database conversion operation ended.

timeStarted String

The date and time when the database conversion operation started.

action string

The operations used to convert a non-container database to a pluggable database.

Use PRECHECK to run a pre-check operation on non-container database prior to converting it into a pluggable database.
Use CONVERT to convert a non-container database into a pluggable database.
Use SYNC if the non-container database was manually converted into a pluggable database using the dbcli command-line utility. Databases may need to be converted manually if the CONVERT action fails when converting a non-container database using the API.
Use SYNC_ROLLBACK if the conversion of a non-container database into a pluggable database was manually rolled back using the dbcli command line utility. Conversions may need to be manually rolled back if the CONVERT action fails when converting a non-container database using the API.

additionalCdbParams string

Additional container database parameter.

cdbName string

id string

The OCID of the database conversion history.

lifecycleDetails string

Additional information about the current lifecycle state for the conversion operation.

sourceDatabaseId string

The OCID of the database.

state string

target string

Use NEW_DATABASE to specify that the pluggable database be created within a new container database in the same database home.

targetDatabaseId string

The OCID of the database.

timeEnded string

The date and time when the database conversion operation ended.

timeStarted string

The date and time when the database conversion operation started.

action str

The operations used to convert a non-container database to a pluggable database.

Use PRECHECK to run a pre-check operation on non-container database prior to converting it into a pluggable database.
Use CONVERT to convert a non-container database into a pluggable database.
Use SYNC if the non-container database was manually converted into a pluggable database using the dbcli command-line utility. Databases may need to be converted manually if the CONVERT action fails when converting a non-container database using the API.
Use SYNC_ROLLBACK if the conversion of a non-container database into a pluggable database was manually rolled back using the dbcli command line utility. Conversions may need to be manually rolled back if the CONVERT action fails when converting a non-container database using the API.

additional_cdb_params str

Additional container database parameter.

cdb_name str

id str

The OCID of the database conversion history.

lifecycle_details str

Additional information about the current lifecycle state for the conversion operation.

source_database_id str

The OCID of the database.

state str

target str

Use NEW_DATABASE to specify that the pluggable database be created within a new container database in the same database home.

target_database_id str

The OCID of the database.

time_ended str

The date and time when the database conversion operation ended.

time_started str

The date and time when the database conversion operation started.

action String

The operations used to convert a non-container database to a pluggable database.

Use PRECHECK to run a pre-check operation on non-container database prior to converting it into a pluggable database.
Use CONVERT to convert a non-container database into a pluggable database.
Use SYNC if the non-container database was manually converted into a pluggable database using the dbcli command-line utility. Databases may need to be converted manually if the CONVERT action fails when converting a non-container database using the API.
Use SYNC_ROLLBACK if the conversion of a non-container database into a pluggable database was manually rolled back using the dbcli command line utility. Conversions may need to be manually rolled back if the CONVERT action fails when converting a non-container database using the API.

additionalCdbParams String