Sign in Dashboard Get started
  1. Packages
  2. Packages
  3. Oracle Cloud Infrastructure
  4. API Docs
  5. Psql
  6. getDbSystemPitrDetail
Viewing docs for Oracle Cloud Infrastructure v4.20.0
published on Wednesday, Jul 15, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-oci

oci.Psql.getDbSystemPitrDetail

oci logo
Viewing docs for Oracle Cloud Infrastructure v4.20.0
published on Wednesday, Jul 15, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-oci

    This data source provides details about a specific Db System Pitr Detail resource in Oracle Cloud Infrastructure Psql service.

    Gets the database system PITR details.

    Example Usage

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

const testDbSystemPitrDetail = oci.psql.getDbSystemPitrDetail({
    dbSystemId: testDbSystem.id,
});

    import pulumi
import pulumi_oci as oci

test_db_system_pitr_detail = oci.psql.get_db_system_pitr_detail(db_system_id=test_db_system["id"])

    package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := psql.GetDbSystemPitrDetail(ctx, &psql.GetDbSystemPitrDetailArgs{
			DbSystemId: testDbSystem.Id,
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    var testDbSystemPitrDetail = Oci.Psql.GetDbSystemPitrDetail.Invoke(new()
    {
        DbSystemId = testDbSystem.Id,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Psql.PsqlFunctions;
import com.pulumi.oci.Psql.inputs.GetDbSystemPitrDetailArgs;
import java.util.ArrayList;
import java.util.Arrays;
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 testDbSystemPitrDetail = PsqlFunctions.getDbSystemPitrDetail(GetDbSystemPitrDetailArgs.builder()
            .dbSystemId(testDbSystem.id())
            .build());

    }
}

    variables:
  testDbSystemPitrDetail:
    fn::invoke:
      function: oci:Psql:getDbSystemPitrDetail
      arguments:
        dbSystemId: ${testDbSystem.id}

    pulumi {
  required_providers {
    oci = {
      source = "pulumi/oci"
    }
  }
}

data "oci_psql_getdbsystempitrdetail" "testDbSystemPitrDetail" {
  db_system_id = testDbSystem.id
}

    Using getDbSystemPitrDetail

    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 getDbSystemPitrDetail(args: GetDbSystemPitrDetailArgs, opts?: InvokeOptions): Promise<GetDbSystemPitrDetailResult>
function getDbSystemPitrDetailOutput(args: GetDbSystemPitrDetailOutputArgs, opts?: InvokeOptions): Output<GetDbSystemPitrDetailResult>
    def get_db_system_pitr_detail(db_system_id: Optional[str] = None,
                              opts: Optional[InvokeOptions] = None) -> GetDbSystemPitrDetailResult
def get_db_system_pitr_detail_output(db_system_id: pulumi.Input[Optional[str]] = None,
                              opts: Optional[InvokeOptions] = None) -> Output[GetDbSystemPitrDetailResult]
    func GetDbSystemPitrDetail(ctx *Context, args *GetDbSystemPitrDetailArgs, opts ...InvokeOption) (*GetDbSystemPitrDetailResult, error)
func GetDbSystemPitrDetailOutput(ctx *Context, args *GetDbSystemPitrDetailOutputArgs, opts ...InvokeOption) GetDbSystemPitrDetailResultOutput

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

    public static class GetDbSystemPitrDetail 
{
    public static Task<GetDbSystemPitrDetailResult> InvokeAsync(GetDbSystemPitrDetailArgs args, InvokeOptions? opts = null)
    public static Output<GetDbSystemPitrDetailResult> Invoke(GetDbSystemPitrDetailInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetDbSystemPitrDetailResult> getDbSystemPitrDetail(GetDbSystemPitrDetailArgs args, InvokeOptions options)
public static Output<GetDbSystemPitrDetailResult> getDbSystemPitrDetail(GetDbSystemPitrDetailArgs args, InvokeOptions options)

    fn::invoke:
  function: oci:Psql/getDbSystemPitrDetail:getDbSystemPitrDetail
  arguments:
    # arguments dictionary
    data "oci_psql_get_db_system_pitr_detail" "name" {
    # arguments
}

    The following arguments are supported:

    DbSystemId string
    A unique identifier for the database system.
    DbSystemId string
    A unique identifier for the database system.
    db_system_id string
    A unique identifier for the database system.
    dbSystemId String
    A unique identifier for the database system.
    dbSystemId string
    A unique identifier for the database system.
    db_system_id str
    A unique identifier for the database system.
    dbSystemId String
    A unique identifier for the database system.

    getDbSystemPitrDetail Result

    The following output properties are available:

    DbSystemId string
    Id string
    The provider-assigned unique ID for this managed resource.
    PitrState string
    The current state of the point-in-time recovery of the db system.
    RecoveryTimeWindows List<GetDbSystemPitrDetailRecoveryTimeWindow>
    List of point-in-time recovery windows.
    DbSystemId string
    Id string
    The provider-assigned unique ID for this managed resource.
    PitrState string
    The current state of the point-in-time recovery of the db system.
    RecoveryTimeWindows []GetDbSystemPitrDetailRecoveryTimeWindow
    List of point-in-time recovery windows.
    db_system_id string
    id string
    The provider-assigned unique ID for this managed resource.
    pitr_state string
    The current state of the point-in-time recovery of the db system.
    recovery_time_windows list(object)
    List of point-in-time recovery windows.
    dbSystemId String
    id String
    The provider-assigned unique ID for this managed resource.
    pitrState String
    The current state of the point-in-time recovery of the db system.
    recoveryTimeWindows List<GetDbSystemPitrDetailRecoveryTimeWindow>
    List of point-in-time recovery windows.
    dbSystemId string
    id string
    The provider-assigned unique ID for this managed resource.
    pitrState string
    The current state of the point-in-time recovery of the db system.
    recoveryTimeWindows GetDbSystemPitrDetailRecoveryTimeWindow[]
    List of point-in-time recovery windows.
    db_system_id str
    id str
    The provider-assigned unique ID for this managed resource.
    pitr_state str
    The current state of the point-in-time recovery of the db system.
    recovery_time_windows Sequence[GetDbSystemPitrDetailRecoveryTimeWindow]
    List of point-in-time recovery windows.
    dbSystemId String
    id String
    The provider-assigned unique ID for this managed resource.
    pitrState String
    The current state of the point-in-time recovery of the db system.
    recoveryTimeWindows List<Property Map>
    List of point-in-time recovery windows.

    Supporting Types

    GetDbSystemPitrDetailRecoveryTimeWindow

    TimeRecoveryWindowEnd string
    Latest timestamp in the PITR window to which the database can be restored. Timestamps later than this are not recoverable. The value must be an RFC 3339 timestamp. Example: 2016-08-25T21:10:29Z
    TimeRecoveryWindowStart string
    Earliest timestamp in the PITR window to which the database can be restored. Timestamps earlier than this are not recoverable. The value must be an RFC 3339 timestamp. Example: 2016-08-25T21:10:29Z
    TimeRecoveryWindowEnd string
    Latest timestamp in the PITR window to which the database can be restored. Timestamps later than this are not recoverable. The value must be an RFC 3339 timestamp. Example: 2016-08-25T21:10:29Z
    TimeRecoveryWindowStart string
    Earliest timestamp in the PITR window to which the database can be restored. Timestamps earlier than this are not recoverable. The value must be an RFC 3339 timestamp. Example: 2016-08-25T21:10:29Z
    time_recovery_window_end string
    Latest timestamp in the PITR window to which the database can be restored. Timestamps later than this are not recoverable. The value must be an RFC 3339 timestamp. Example: 2016-08-25T21:10:29Z
    time_recovery_window_start string
    Earliest timestamp in the PITR window to which the database can be restored. Timestamps earlier than this are not recoverable. The value must be an RFC 3339 timestamp. Example: 2016-08-25T21:10:29Z
    timeRecoveryWindowEnd String
    Latest timestamp in the PITR window to which the database can be restored. Timestamps later than this are not recoverable. The value must be an RFC 3339 timestamp. Example: 2016-08-25T21:10:29Z
    timeRecoveryWindowStart String
    Earliest timestamp in the PITR window to which the database can be restored. Timestamps earlier than this are not recoverable. The value must be an RFC 3339 timestamp. Example: 2016-08-25T21:10:29Z
    timeRecoveryWindowEnd string
    Latest timestamp in the PITR window to which the database can be restored. Timestamps later than this are not recoverable. The value must be an RFC 3339 timestamp. Example: 2016-08-25T21:10:29Z
    timeRecoveryWindowStart string
    Earliest timestamp in the PITR window to which the database can be restored. Timestamps earlier than this are not recoverable. The value must be an RFC 3339 timestamp. Example: 2016-08-25T21:10:29Z
    time_recovery_window_end str
    Latest timestamp in the PITR window to which the database can be restored. Timestamps later than this are not recoverable. The value must be an RFC 3339 timestamp. Example: 2016-08-25T21:10:29Z
    time_recovery_window_start str
    Earliest timestamp in the PITR window to which the database can be restored. Timestamps earlier than this are not recoverable. The value must be an RFC 3339 timestamp. Example: 2016-08-25T21:10:29Z
    timeRecoveryWindowEnd String
    Latest timestamp in the PITR window to which the database can be restored. Timestamps later than this are not recoverable. The value must be an RFC 3339 timestamp. Example: 2016-08-25T21:10:29Z
    timeRecoveryWindowStart String
    Earliest timestamp in the PITR window to which the database can be restored. Timestamps earlier than this are not recoverable. The value must be an RFC 3339 timestamp. Example: 2016-08-25T21:10:29Z

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Viewing docs for Oracle Cloud Infrastructure v4.20.0
    published on Wednesday, Jul 15, 2026 by Pulumi
    Schema (JSON)
    pulumi/pulumi-oci

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial