DbSystem

This resource provides the Db System resource in Oracle Cloud Infrastructure Database service.

Creates a new DB system in the specified compartment and availability domain. The Oracle Database edition that you specify applies to all the databases on that DB system. The selected edition cannot be changed.

An initial database is created on the DB system based on the request parameters you provide and some default options. For detailed information about default options, see Bare metal and virtual machine DB system default options.

Note: Deprecated for Exadata Cloud Service systems. Use the new resource model APIs instead.

For Exadata Cloud Service instances, support for this API will end on May 15th, 2021. See Switching an Exadata DB System to the New Resource Model and APIs for details on converting existing Exadata DB systems to the new resource model.

Use the CreateCloudExadataInfrastructure and CreateCloudVmCluster APIs to provision a new Exadata Cloud Service instance.

Create DbSystem Resource

new DbSystem(name: string, args: DbSystemArgs, opts?: CustomResourceOptions);
@overload
def DbSystem(resource_name: str,
             opts: Optional[ResourceOptions] = None,
             availability_domain: Optional[str] = None,
             backup_network_nsg_ids: Optional[Sequence[str]] = None,
             backup_subnet_id: Optional[str] = None,
             cluster_name: Optional[str] = None,
             compartment_id: Optional[str] = None,
             cpu_core_count: Optional[int] = None,
             data_collection_options: Optional[_database.DbSystemDataCollectionOptionsArgs] = None,
             data_storage_percentage: Optional[int] = None,
             data_storage_size_in_gb: Optional[int] = None,
             database_edition: Optional[str] = None,
             db_home: Optional[_database.DbSystemDbHomeArgs] = None,
             db_system_options: Optional[_database.DbSystemDbSystemOptionsArgs] = None,
             defined_tags: Optional[Mapping[str, Any]] = None,
             disk_redundancy: Optional[str] = None,
             display_name: Optional[str] = None,
             domain: Optional[str] = None,
             fault_domains: Optional[Sequence[str]] = None,
             freeform_tags: Optional[Mapping[str, Any]] = None,
             hostname: Optional[str] = None,
             kms_key_id: Optional[str] = None,
             kms_key_version_id: Optional[str] = None,
             license_model: Optional[str] = None,
             maintenance_window_details: Optional[_database.DbSystemMaintenanceWindowDetailsArgs] = None,
             node_count: Optional[int] = None,
             nsg_ids: Optional[Sequence[str]] = None,
             private_ip: Optional[str] = None,
             reco_storage_size_in_gb: Optional[int] = None,
             shape: Optional[str] = None,
             source: Optional[str] = None,
             source_db_system_id: Optional[str] = None,
             sparse_diskgroup: Optional[bool] = None,
             ssh_public_keys: Optional[Sequence[str]] = None,
             storage_volume_performance_mode: Optional[str] = None,
             subnet_id: Optional[str] = None,
             time_zone: Optional[str] = None)
@overload
def DbSystem(resource_name: str,
             args: DbSystemArgs,
             opts: Optional[ResourceOptions] = None)
func NewDbSystem(ctx *Context, name string, args DbSystemArgs, opts ...ResourceOption) (*DbSystem, error)
public DbSystem(string name, DbSystemArgs args, CustomResourceOptions? opts = null)
public DbSystem(String name, DbSystemArgs args)
public DbSystem(String name, DbSystemArgs args, CustomResourceOptions options)
type: oci:Database:DbSystem
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

name string
The unique name of the resource.
args DbSystemArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name str
The unique name of the resource.
args DbSystemArgs
The arguments to resource properties.
opts ResourceOptions
Bag of options to control resource's behavior.
ctx Context
Context object for the current deployment.
name string
The unique name of the resource.
args DbSystemArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name string
The unique name of the resource.
args DbSystemArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name String
The unique name of the resource.
args DbSystemArgs
The arguments to resource properties.
options CustomResourceOptions
Bag of options to control resource's behavior.

DbSystem Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

The DbSystem resource accepts the following input properties:

AvailabilityDomain string

The availability domain where the DB system is located.

CompartmentId string

(Updatable) The OCID of the compartment the DB system belongs in.

DbHome DbSystemDbHomeArgs

(Updatable) Details for creating a Database Home if you are creating a database by restoring from a database backup.

Hostname string

The hostname for the DB system. The hostname must begin with an alphabetic character, and can contain alphanumeric characters and hyphens (-). The maximum length of the hostname is 16 characters for bare metal and virtual machine DB systems, and 12 characters for Exadata DB systems.

Shape string

(Updatable) The shape of the DB system. The shape determines resources allocated to the DB system.

  • For virtual machine shapes, the number of CPU cores and memory
  • For bare metal and Exadata shapes, the number of CPU cores, memory, and storage
SshPublicKeys List<string>

(Updatable) The public key portion of the key pair to use for SSH access to the DB system. Multiple public keys can be provided. The length of the combined keys cannot exceed 40,000 characters.

SubnetId string

The OCID of the subnet the DB system is associated with.

BackupNetworkNsgIds List<string>

(Updatable) A list of the OCIDs of the network security groups (NSGs) that the backup network of this DB system belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. Applicable only to Exadata systems.

BackupSubnetId string

The OCID of the backup network subnet the DB system is associated with. Applicable only to Exadata DB systems.

ClusterName string

The cluster name for Exadata and 2-node RAC virtual machine DB systems. The cluster name must begin with an alphabetic character, and may contain hyphens (-). Underscores (_) are not permitted. The cluster name can be no longer than 11 characters and is not case sensitive.

CpuCoreCount int

(Updatable) The number of CPU cores to enable for a bare metal or Exadata DB system or AMD VMDB Systems. The valid values depend on the specified shape:

  • BM.DenseIO1.36 - Specify a multiple of 2, from 2 to 36.
  • BM.DenseIO2.52 - Specify a multiple of 2, from 2 to 52.
  • Exadata.Base.48 - Specify a multiple of 2, from 0 to 48.
  • Exadata.Quarter1.84 - Specify a multiple of 2, from 22 to 84.
  • Exadata.Half1.168 - Specify a multiple of 4, from 44 to 168.
  • Exadata.Full1.336 - Specify a multiple of 8, from 88 to 336.
  • Exadata.Quarter2.92 - Specify a multiple of 2, from 0 to 92.
  • Exadata.Half2.184 - Specify a multiple of 4, from 0 to 184.
  • Exadata.Full2.368 - Specify a multiple of 8, from 0 to 368.
  • VM.Standard.E4.Flex - Specify any thing from 1 to 64.
DataCollectionOptions DbSystemDataCollectionOptionsArgs

(Updatable) Indicates user preferences for the various diagnostic collection options for the VM cluster/Cloud VM cluster/VMBM DBCS.

DataStoragePercentage int

The percentage assigned to DATA storage (user data and database files). The remaining percentage is assigned to RECO storage (database redo logs, archive logs, and recovery manager backups). Specify 80 or 40. The default is 80 percent assigned to DATA storage. Not applicable for virtual machine DB systems. Required for BMDBs.

DataStorageSizeInGb int

(Updatable) Size (in GB) of the initial data volume that will be created and attached to a virtual machine DB system. You can scale up storage after provisioning, as needed. Note that the total storage size attached will be more than the amount you specify to allow for REDO/RECO space and software volume. Required for VMDBs.

DatabaseEdition string

The Oracle Database Edition that applies to all the databases on the DB system. Exadata DB systems and 2-node RAC DB systems require ENTERPRISE_EDITION_EXTREME_PERFORMANCE.

DbSystemOptions DbSystemDbSystemOptionsArgs

The DB system options.

DefinedTags Dictionary<string, object>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

DiskRedundancy string

The type of redundancy configured for the DB system. Normal is 2-way redundancy, recommended for test and development systems. High is 3-way redundancy, recommended for production systems.

DisplayName string

The user-friendly name for the DB system. The name does not have to be unique.

Domain string

A domain name used for the DB system. If the Oracle-provided Internet and VCN Resolver is enabled for the specified subnet, the domain name for the subnet is used (do not provide one). Otherwise, provide a valid DNS domain name. Hyphens (-) are not permitted.

FaultDomains List<string>

A Fault Domain is a grouping of hardware and infrastructure within an availability domain. Fault Domains let you distribute your instances so that they are not on the same physical hardware within a single availability domain. A hardware failure or maintenance that affects one Fault Domain does not affect DB systems in other Fault Domains.

FreeformTags Dictionary<string, object>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

KmsKeyId string

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

KmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

LicenseModel string

(Updatable) The Oracle license model that applies to all the databases on the DB system. The default is LICENSE_INCLUDED.

MaintenanceWindowDetails DbSystemMaintenanceWindowDetailsArgs

(Updatable) The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

NodeCount int

The number of nodes to launch for a 2-node RAC virtual machine DB system. Specify either 1 or 2.

NsgIds List<string>

(Updatable) The list of OCIDs for the network security groups (NSGs) to which this resource belongs. Setting this to an empty list removes all resources from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.
PrivateIp string

A private IP address of your choice. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. Supported for VM BM shape.

RecoStorageSizeInGb int

The RECO/REDO storage size, in gigabytes, that is currently allocated to the DB system. Applies only for virtual machine DB systems.

Source string

The source of the database: Use NONE for creating a new database. Use DB_BACKUP for creating a new database by restoring from a backup. Use DATABASE for creating a new database from an existing database, including archive redo log data. The default is NONE.

SourceDbSystemId string

The OCID of the DB system.

SparseDiskgroup bool

If true, Sparse Diskgroup is configured for Exadata dbsystem. If False, Sparse diskgroup is not configured. Only applied for Exadata shape.

StorageVolumePerformanceMode string

The block storage volume performance level. Valid values are BALANCED and HIGH_PERFORMANCE. See Block Volume Performance for more information.

TimeZone string

The time zone to use for the DB system. For details, see DB System Time Zones.

AvailabilityDomain string

The availability domain where the DB system is located.

CompartmentId string

(Updatable) The OCID of the compartment the DB system belongs in.

DbHome DbSystemDbHomeArgs

(Updatable) Details for creating a Database Home if you are creating a database by restoring from a database backup.

Hostname string

The hostname for the DB system. The hostname must begin with an alphabetic character, and can contain alphanumeric characters and hyphens (-). The maximum length of the hostname is 16 characters for bare metal and virtual machine DB systems, and 12 characters for Exadata DB systems.

Shape string

(Updatable) The shape of the DB system. The shape determines resources allocated to the DB system.

  • For virtual machine shapes, the number of CPU cores and memory
  • For bare metal and Exadata shapes, the number of CPU cores, memory, and storage
SshPublicKeys []string

(Updatable) The public key portion of the key pair to use for SSH access to the DB system. Multiple public keys can be provided. The length of the combined keys cannot exceed 40,000 characters.

SubnetId string

The OCID of the subnet the DB system is associated with.

BackupNetworkNsgIds []string

(Updatable) A list of the OCIDs of the network security groups (NSGs) that the backup network of this DB system belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. Applicable only to Exadata systems.

BackupSubnetId string

The OCID of the backup network subnet the DB system is associated with. Applicable only to Exadata DB systems.

ClusterName string

The cluster name for Exadata and 2-node RAC virtual machine DB systems. The cluster name must begin with an alphabetic character, and may contain hyphens (-). Underscores (_) are not permitted. The cluster name can be no longer than 11 characters and is not case sensitive.

CpuCoreCount int

(Updatable) The number of CPU cores to enable for a bare metal or Exadata DB system or AMD VMDB Systems. The valid values depend on the specified shape:

  • BM.DenseIO1.36 - Specify a multiple of 2, from 2 to 36.
  • BM.DenseIO2.52 - Specify a multiple of 2, from 2 to 52.
  • Exadata.Base.48 - Specify a multiple of 2, from 0 to 48.
  • Exadata.Quarter1.84 - Specify a multiple of 2, from 22 to 84.
  • Exadata.Half1.168 - Specify a multiple of 4, from 44 to 168.
  • Exadata.Full1.336 - Specify a multiple of 8, from 88 to 336.
  • Exadata.Quarter2.92 - Specify a multiple of 2, from 0 to 92.
  • Exadata.Half2.184 - Specify a multiple of 4, from 0 to 184.
  • Exadata.Full2.368 - Specify a multiple of 8, from 0 to 368.
  • VM.Standard.E4.Flex - Specify any thing from 1 to 64.
DataCollectionOptions DbSystemDataCollectionOptionsArgs

(Updatable) Indicates user preferences for the various diagnostic collection options for the VM cluster/Cloud VM cluster/VMBM DBCS.

DataStoragePercentage int

The percentage assigned to DATA storage (user data and database files). The remaining percentage is assigned to RECO storage (database redo logs, archive logs, and recovery manager backups). Specify 80 or 40. The default is 80 percent assigned to DATA storage. Not applicable for virtual machine DB systems. Required for BMDBs.

DataStorageSizeInGb int

(Updatable) Size (in GB) of the initial data volume that will be created and attached to a virtual machine DB system. You can scale up storage after provisioning, as needed. Note that the total storage size attached will be more than the amount you specify to allow for REDO/RECO space and software volume. Required for VMDBs.

DatabaseEdition string

The Oracle Database Edition that applies to all the databases on the DB system. Exadata DB systems and 2-node RAC DB systems require ENTERPRISE_EDITION_EXTREME_PERFORMANCE.

DbSystemOptions DbSystemDbSystemOptionsArgs

The DB system options.

DefinedTags map[string]interface{}

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

DiskRedundancy string

The type of redundancy configured for the DB system. Normal is 2-way redundancy, recommended for test and development systems. High is 3-way redundancy, recommended for production systems.

DisplayName string

The user-friendly name for the DB system. The name does not have to be unique.

Domain string

A domain name used for the DB system. If the Oracle-provided Internet and VCN Resolver is enabled for the specified subnet, the domain name for the subnet is used (do not provide one). Otherwise, provide a valid DNS domain name. Hyphens (-) are not permitted.

FaultDomains []string

A Fault Domain is a grouping of hardware and infrastructure within an availability domain. Fault Domains let you distribute your instances so that they are not on the same physical hardware within a single availability domain. A hardware failure or maintenance that affects one Fault Domain does not affect DB systems in other Fault Domains.

FreeformTags map[string]interface{}

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

KmsKeyId string

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

KmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

LicenseModel string

(Updatable) The Oracle license model that applies to all the databases on the DB system. The default is LICENSE_INCLUDED.

MaintenanceWindowDetails DbSystemMaintenanceWindowDetailsArgs

(Updatable) The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

NodeCount int

The number of nodes to launch for a 2-node RAC virtual machine DB system. Specify either 1 or 2.

NsgIds []string

(Updatable) The list of OCIDs for the network security groups (NSGs) to which this resource belongs. Setting this to an empty list removes all resources from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.
PrivateIp string

A private IP address of your choice. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. Supported for VM BM shape.

RecoStorageSizeInGb int

The RECO/REDO storage size, in gigabytes, that is currently allocated to the DB system. Applies only for virtual machine DB systems.

Source string

The source of the database: Use NONE for creating a new database. Use DB_BACKUP for creating a new database by restoring from a backup. Use DATABASE for creating a new database from an existing database, including archive redo log data. The default is NONE.

SourceDbSystemId string

The OCID of the DB system.

SparseDiskgroup bool

If true, Sparse Diskgroup is configured for Exadata dbsystem. If False, Sparse diskgroup is not configured. Only applied for Exadata shape.

StorageVolumePerformanceMode string

The block storage volume performance level. Valid values are BALANCED and HIGH_PERFORMANCE. See Block Volume Performance for more information.

TimeZone string

The time zone to use for the DB system. For details, see DB System Time Zones.

availabilityDomain String

The availability domain where the DB system is located.

compartmentId String

(Updatable) The OCID of the compartment the DB system belongs in.

dbHome DbSystemDbHomeArgs

(Updatable) Details for creating a Database Home if you are creating a database by restoring from a database backup.

hostname String

The hostname for the DB system. The hostname must begin with an alphabetic character, and can contain alphanumeric characters and hyphens (-). The maximum length of the hostname is 16 characters for bare metal and virtual machine DB systems, and 12 characters for Exadata DB systems.

shape String

(Updatable) The shape of the DB system. The shape determines resources allocated to the DB system.

  • For virtual machine shapes, the number of CPU cores and memory
  • For bare metal and Exadata shapes, the number of CPU cores, memory, and storage
sshPublicKeys List<String>

(Updatable) The public key portion of the key pair to use for SSH access to the DB system. Multiple public keys can be provided. The length of the combined keys cannot exceed 40,000 characters.

subnetId String

The OCID of the subnet the DB system is associated with.

backupNetworkNsgIds List<String>

(Updatable) A list of the OCIDs of the network security groups (NSGs) that the backup network of this DB system belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. Applicable only to Exadata systems.

backupSubnetId String

The OCID of the backup network subnet the DB system is associated with. Applicable only to Exadata DB systems.

clusterName String

The cluster name for Exadata and 2-node RAC virtual machine DB systems. The cluster name must begin with an alphabetic character, and may contain hyphens (-). Underscores (_) are not permitted. The cluster name can be no longer than 11 characters and is not case sensitive.

cpuCoreCount Integer

(Updatable) The number of CPU cores to enable for a bare metal or Exadata DB system or AMD VMDB Systems. The valid values depend on the specified shape:

  • BM.DenseIO1.36 - Specify a multiple of 2, from 2 to 36.
  • BM.DenseIO2.52 - Specify a multiple of 2, from 2 to 52.
  • Exadata.Base.48 - Specify a multiple of 2, from 0 to 48.
  • Exadata.Quarter1.84 - Specify a multiple of 2, from 22 to 84.
  • Exadata.Half1.168 - Specify a multiple of 4, from 44 to 168.
  • Exadata.Full1.336 - Specify a multiple of 8, from 88 to 336.
  • Exadata.Quarter2.92 - Specify a multiple of 2, from 0 to 92.
  • Exadata.Half2.184 - Specify a multiple of 4, from 0 to 184.
  • Exadata.Full2.368 - Specify a multiple of 8, from 0 to 368.
  • VM.Standard.E4.Flex - Specify any thing from 1 to 64.
dataCollectionOptions DbSystemDataCollectionOptionsArgs

(Updatable) Indicates user preferences for the various diagnostic collection options for the VM cluster/Cloud VM cluster/VMBM DBCS.

dataStoragePercentage Integer

The percentage assigned to DATA storage (user data and database files). The remaining percentage is assigned to RECO storage (database redo logs, archive logs, and recovery manager backups). Specify 80 or 40. The default is 80 percent assigned to DATA storage. Not applicable for virtual machine DB systems. Required for BMDBs.

dataStorageSizeInGb Integer

(Updatable) Size (in GB) of the initial data volume that will be created and attached to a virtual machine DB system. You can scale up storage after provisioning, as needed. Note that the total storage size attached will be more than the amount you specify to allow for REDO/RECO space and software volume. Required for VMDBs.

databaseEdition String

The Oracle Database Edition that applies to all the databases on the DB system. Exadata DB systems and 2-node RAC DB systems require ENTERPRISE_EDITION_EXTREME_PERFORMANCE.

dbSystemOptions DbSystemDbSystemOptionsArgs

The DB system options.

definedTags Map<String,Object>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

diskRedundancy String

The type of redundancy configured for the DB system. Normal is 2-way redundancy, recommended for test and development systems. High is 3-way redundancy, recommended for production systems.

displayName String

The user-friendly name for the DB system. The name does not have to be unique.

domain String

A domain name used for the DB system. If the Oracle-provided Internet and VCN Resolver is enabled for the specified subnet, the domain name for the subnet is used (do not provide one). Otherwise, provide a valid DNS domain name. Hyphens (-) are not permitted.

faultDomains List<String>

A Fault Domain is a grouping of hardware and infrastructure within an availability domain. Fault Domains let you distribute your instances so that they are not on the same physical hardware within a single availability domain. A hardware failure or maintenance that affects one Fault Domain does not affect DB systems in other Fault Domains.

freeformTags Map<String,Object>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

kmsKeyId String

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

kmsKeyVersionId String

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

licenseModel String

(Updatable) The Oracle license model that applies to all the databases on the DB system. The default is LICENSE_INCLUDED.

maintenanceWindowDetails DbSystemMaintenanceWindowDetailsArgs

(Updatable) The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

nodeCount Integer

The number of nodes to launch for a 2-node RAC virtual machine DB system. Specify either 1 or 2.

nsgIds List<String>

(Updatable) The list of OCIDs for the network security groups (NSGs) to which this resource belongs. Setting this to an empty list removes all resources from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.
privateIp String

A private IP address of your choice. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. Supported for VM BM shape.

recoStorageSizeInGb Integer

The RECO/REDO storage size, in gigabytes, that is currently allocated to the DB system. Applies only for virtual machine DB systems.

source String

The source of the database: Use NONE for creating a new database. Use DB_BACKUP for creating a new database by restoring from a backup. Use DATABASE for creating a new database from an existing database, including archive redo log data. The default is NONE.

sourceDbSystemId String

The OCID of the DB system.

sparseDiskgroup Boolean

If true, Sparse Diskgroup is configured for Exadata dbsystem. If False, Sparse diskgroup is not configured. Only applied for Exadata shape.

storageVolumePerformanceMode String

The block storage volume performance level. Valid values are BALANCED and HIGH_PERFORMANCE. See Block Volume Performance for more information.

timeZone String

The time zone to use for the DB system. For details, see DB System Time Zones.

availabilityDomain string

The availability domain where the DB system is located.

compartmentId string

(Updatable) The OCID of the compartment the DB system belongs in.

dbHome DbSystemDbHomeArgs

(Updatable) Details for creating a Database Home if you are creating a database by restoring from a database backup.

hostname string

The hostname for the DB system. The hostname must begin with an alphabetic character, and can contain alphanumeric characters and hyphens (-). The maximum length of the hostname is 16 characters for bare metal and virtual machine DB systems, and 12 characters for Exadata DB systems.

shape string

(Updatable) The shape of the DB system. The shape determines resources allocated to the DB system.

  • For virtual machine shapes, the number of CPU cores and memory
  • For bare metal and Exadata shapes, the number of CPU cores, memory, and storage
sshPublicKeys string[]

(Updatable) The public key portion of the key pair to use for SSH access to the DB system. Multiple public keys can be provided. The length of the combined keys cannot exceed 40,000 characters.

subnetId string

The OCID of the subnet the DB system is associated with.

backupNetworkNsgIds string[]

(Updatable) A list of the OCIDs of the network security groups (NSGs) that the backup network of this DB system belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. Applicable only to Exadata systems.

backupSubnetId string

The OCID of the backup network subnet the DB system is associated with. Applicable only to Exadata DB systems.

clusterName string

The cluster name for Exadata and 2-node RAC virtual machine DB systems. The cluster name must begin with an alphabetic character, and may contain hyphens (-). Underscores (_) are not permitted. The cluster name can be no longer than 11 characters and is not case sensitive.

cpuCoreCount number

(Updatable) The number of CPU cores to enable for a bare metal or Exadata DB system or AMD VMDB Systems. The valid values depend on the specified shape:

  • BM.DenseIO1.36 - Specify a multiple of 2, from 2 to 36.
  • BM.DenseIO2.52 - Specify a multiple of 2, from 2 to 52.
  • Exadata.Base.48 - Specify a multiple of 2, from 0 to 48.
  • Exadata.Quarter1.84 - Specify a multiple of 2, from 22 to 84.
  • Exadata.Half1.168 - Specify a multiple of 4, from 44 to 168.
  • Exadata.Full1.336 - Specify a multiple of 8, from 88 to 336.
  • Exadata.Quarter2.92 - Specify a multiple of 2, from 0 to 92.
  • Exadata.Half2.184 - Specify a multiple of 4, from 0 to 184.
  • Exadata.Full2.368 - Specify a multiple of 8, from 0 to 368.
  • VM.Standard.E4.Flex - Specify any thing from 1 to 64.
dataCollectionOptions DbSystemDataCollectionOptionsArgs

(Updatable) Indicates user preferences for the various diagnostic collection options for the VM cluster/Cloud VM cluster/VMBM DBCS.

dataStoragePercentage number

The percentage assigned to DATA storage (user data and database files). The remaining percentage is assigned to RECO storage (database redo logs, archive logs, and recovery manager backups). Specify 80 or 40. The default is 80 percent assigned to DATA storage. Not applicable for virtual machine DB systems. Required for BMDBs.

dataStorageSizeInGb number

(Updatable) Size (in GB) of the initial data volume that will be created and attached to a virtual machine DB system. You can scale up storage after provisioning, as needed. Note that the total storage size attached will be more than the amount you specify to allow for REDO/RECO space and software volume. Required for VMDBs.

databaseEdition string

The Oracle Database Edition that applies to all the databases on the DB system. Exadata DB systems and 2-node RAC DB systems require ENTERPRISE_EDITION_EXTREME_PERFORMANCE.

dbSystemOptions DbSystemDbSystemOptionsArgs

The DB system options.

definedTags {[key: string]: any}

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

diskRedundancy string

The type of redundancy configured for the DB system. Normal is 2-way redundancy, recommended for test and development systems. High is 3-way redundancy, recommended for production systems.

displayName string

The user-friendly name for the DB system. The name does not have to be unique.

domain string

A domain name used for the DB system. If the Oracle-provided Internet and VCN Resolver is enabled for the specified subnet, the domain name for the subnet is used (do not provide one). Otherwise, provide a valid DNS domain name. Hyphens (-) are not permitted.

faultDomains string[]

A Fault Domain is a grouping of hardware and infrastructure within an availability domain. Fault Domains let you distribute your instances so that they are not on the same physical hardware within a single availability domain. A hardware failure or maintenance that affects one Fault Domain does not affect DB systems in other Fault Domains.

freeformTags {[key: string]: any}

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

kmsKeyId string

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

kmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

licenseModel string

(Updatable) The Oracle license model that applies to all the databases on the DB system. The default is LICENSE_INCLUDED.

maintenanceWindowDetails DbSystemMaintenanceWindowDetailsArgs

(Updatable) The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

nodeCount number

The number of nodes to launch for a 2-node RAC virtual machine DB system. Specify either 1 or 2.

nsgIds string[]

(Updatable) The list of OCIDs for the network security groups (NSGs) to which this resource belongs. Setting this to an empty list removes all resources from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.
privateIp string

A private IP address of your choice. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. Supported for VM BM shape.

recoStorageSizeInGb number

The RECO/REDO storage size, in gigabytes, that is currently allocated to the DB system. Applies only for virtual machine DB systems.

source string

The source of the database: Use NONE for creating a new database. Use DB_BACKUP for creating a new database by restoring from a backup. Use DATABASE for creating a new database from an existing database, including archive redo log data. The default is NONE.

sourceDbSystemId string

The OCID of the DB system.

sparseDiskgroup boolean

If true, Sparse Diskgroup is configured for Exadata dbsystem. If False, Sparse diskgroup is not configured. Only applied for Exadata shape.

storageVolumePerformanceMode string

The block storage volume performance level. Valid values are BALANCED and HIGH_PERFORMANCE. See Block Volume Performance for more information.

timeZone string

The time zone to use for the DB system. For details, see DB System Time Zones.

availability_domain str

The availability domain where the DB system is located.

compartment_id str

(Updatable) The OCID of the compartment the DB system belongs in.

db_home DbSystemDbHomeArgs

(Updatable) Details for creating a Database Home if you are creating a database by restoring from a database backup.

hostname str

The hostname for the DB system. The hostname must begin with an alphabetic character, and can contain alphanumeric characters and hyphens (-). The maximum length of the hostname is 16 characters for bare metal and virtual machine DB systems, and 12 characters for Exadata DB systems.

shape str

(Updatable) The shape of the DB system. The shape determines resources allocated to the DB system.

  • For virtual machine shapes, the number of CPU cores and memory
  • For bare metal and Exadata shapes, the number of CPU cores, memory, and storage
ssh_public_keys Sequence[str]

(Updatable) The public key portion of the key pair to use for SSH access to the DB system. Multiple public keys can be provided. The length of the combined keys cannot exceed 40,000 characters.

subnet_id str

The OCID of the subnet the DB system is associated with.

backup_network_nsg_ids Sequence[str]

(Updatable) A list of the OCIDs of the network security groups (NSGs) that the backup network of this DB system belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. Applicable only to Exadata systems.

backup_subnet_id str

The OCID of the backup network subnet the DB system is associated with. Applicable only to Exadata DB systems.

cluster_name str

The cluster name for Exadata and 2-node RAC virtual machine DB systems. The cluster name must begin with an alphabetic character, and may contain hyphens (-). Underscores (_) are not permitted. The cluster name can be no longer than 11 characters and is not case sensitive.

cpu_core_count int

(Updatable) The number of CPU cores to enable for a bare metal or Exadata DB system or AMD VMDB Systems. The valid values depend on the specified shape:

  • BM.DenseIO1.36 - Specify a multiple of 2, from 2 to 36.
  • BM.DenseIO2.52 - Specify a multiple of 2, from 2 to 52.
  • Exadata.Base.48 - Specify a multiple of 2, from 0 to 48.
  • Exadata.Quarter1.84 - Specify a multiple of 2, from 22 to 84.
  • Exadata.Half1.168 - Specify a multiple of 4, from 44 to 168.
  • Exadata.Full1.336 - Specify a multiple of 8, from 88 to 336.
  • Exadata.Quarter2.92 - Specify a multiple of 2, from 0 to 92.
  • Exadata.Half2.184 - Specify a multiple of 4, from 0 to 184.
  • Exadata.Full2.368 - Specify a multiple of 8, from 0 to 368.
  • VM.Standard.E4.Flex - Specify any thing from 1 to 64.
data_collection_options DbSystemDataCollectionOptionsArgs

(Updatable) Indicates user preferences for the various diagnostic collection options for the VM cluster/Cloud VM cluster/VMBM DBCS.

data_storage_percentage int

The percentage assigned to DATA storage (user data and database files). The remaining percentage is assigned to RECO storage (database redo logs, archive logs, and recovery manager backups). Specify 80 or 40. The default is 80 percent assigned to DATA storage. Not applicable for virtual machine DB systems. Required for BMDBs.

data_storage_size_in_gb int

(Updatable) Size (in GB) of the initial data volume that will be created and attached to a virtual machine DB system. You can scale up storage after provisioning, as needed. Note that the total storage size attached will be more than the amount you specify to allow for REDO/RECO space and software volume. Required for VMDBs.

database_edition str

The Oracle Database Edition that applies to all the databases on the DB system. Exadata DB systems and 2-node RAC DB systems require ENTERPRISE_EDITION_EXTREME_PERFORMANCE.

db_system_options DbSystemDbSystemOptionsArgs

The DB system options.

defined_tags Mapping[str, Any]

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

disk_redundancy str

The type of redundancy configured for the DB system. Normal is 2-way redundancy, recommended for test and development systems. High is 3-way redundancy, recommended for production systems.

display_name str

The user-friendly name for the DB system. The name does not have to be unique.

domain str

A domain name used for the DB system. If the Oracle-provided Internet and VCN Resolver is enabled for the specified subnet, the domain name for the subnet is used (do not provide one). Otherwise, provide a valid DNS domain name. Hyphens (-) are not permitted.

fault_domains Sequence[str]

A Fault Domain is a grouping of hardware and infrastructure within an availability domain. Fault Domains let you distribute your instances so that they are not on the same physical hardware within a single availability domain. A hardware failure or maintenance that affects one Fault Domain does not affect DB systems in other Fault Domains.

freeform_tags Mapping[str, Any]

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

kms_key_id str

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

kms_key_version_id str

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

license_model str

(Updatable) The Oracle license model that applies to all the databases on the DB system. The default is LICENSE_INCLUDED.

maintenance_window_details DbSystemMaintenanceWindowDetailsArgs

(Updatable) The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

node_count int

The number of nodes to launch for a 2-node RAC virtual machine DB system. Specify either 1 or 2.

nsg_ids Sequence[str]

(Updatable) The list of OCIDs for the network security groups (NSGs) to which this resource belongs. Setting this to an empty list removes all resources from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.
private_ip str

A private IP address of your choice. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. Supported for VM BM shape.

reco_storage_size_in_gb int

The RECO/REDO storage size, in gigabytes, that is currently allocated to the DB system. Applies only for virtual machine DB systems.

source str

The source of the database: Use NONE for creating a new database. Use DB_BACKUP for creating a new database by restoring from a backup. Use DATABASE for creating a new database from an existing database, including archive redo log data. The default is NONE.

source_db_system_id str

The OCID of the DB system.

sparse_diskgroup bool

If true, Sparse Diskgroup is configured for Exadata dbsystem. If False, Sparse diskgroup is not configured. Only applied for Exadata shape.

storage_volume_performance_mode str

The block storage volume performance level. Valid values are BALANCED and HIGH_PERFORMANCE. See Block Volume Performance for more information.

time_zone str

The time zone to use for the DB system. For details, see DB System Time Zones.

availabilityDomain String

The availability domain where the DB system is located.

compartmentId String

(Updatable) The OCID of the compartment the DB system belongs in.

dbHome Property Map

(Updatable) Details for creating a Database Home if you are creating a database by restoring from a database backup.

hostname String

The hostname for the DB system. The hostname must begin with an alphabetic character, and can contain alphanumeric characters and hyphens (-). The maximum length of the hostname is 16 characters for bare metal and virtual machine DB systems, and 12 characters for Exadata DB systems.

shape String

(Updatable) The shape of the DB system. The shape determines resources allocated to the DB system.

  • For virtual machine shapes, the number of CPU cores and memory
  • For bare metal and Exadata shapes, the number of CPU cores, memory, and storage
sshPublicKeys List<String>

(Updatable) The public key portion of the key pair to use for SSH access to the DB system. Multiple public keys can be provided. The length of the combined keys cannot exceed 40,000 characters.

subnetId String

The OCID of the subnet the DB system is associated with.

backupNetworkNsgIds List<String>

(Updatable) A list of the OCIDs of the network security groups (NSGs) that the backup network of this DB system belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. Applicable only to Exadata systems.

backupSubnetId String

The OCID of the backup network subnet the DB system is associated with. Applicable only to Exadata DB systems.

clusterName String

The cluster name for Exadata and 2-node RAC virtual machine DB systems. The cluster name must begin with an alphabetic character, and may contain hyphens (-). Underscores (_) are not permitted. The cluster name can be no longer than 11 characters and is not case sensitive.

cpuCoreCount Number

(Updatable) The number of CPU cores to enable for a bare metal or Exadata DB system or AMD VMDB Systems. The valid values depend on the specified shape:

  • BM.DenseIO1.36 - Specify a multiple of 2, from 2 to 36.
  • BM.DenseIO2.52 - Specify a multiple of 2, from 2 to 52.
  • Exadata.Base.48 - Specify a multiple of 2, from 0 to 48.
  • Exadata.Quarter1.84 - Specify a multiple of 2, from 22 to 84.
  • Exadata.Half1.168 - Specify a multiple of 4, from 44 to 168.
  • Exadata.Full1.336 - Specify a multiple of 8, from 88 to 336.
  • Exadata.Quarter2.92 - Specify a multiple of 2, from 0 to 92.
  • Exadata.Half2.184 - Specify a multiple of 4, from 0 to 184.
  • Exadata.Full2.368 - Specify a multiple of 8, from 0 to 368.
  • VM.Standard.E4.Flex - Specify any thing from 1 to 64.
dataCollectionOptions Property Map

(Updatable) Indicates user preferences for the various diagnostic collection options for the VM cluster/Cloud VM cluster/VMBM DBCS.

dataStoragePercentage Number

The percentage assigned to DATA storage (user data and database files). The remaining percentage is assigned to RECO storage (database redo logs, archive logs, and recovery manager backups). Specify 80 or 40. The default is 80 percent assigned to DATA storage. Not applicable for virtual machine DB systems. Required for BMDBs.

dataStorageSizeInGb Number

(Updatable) Size (in GB) of the initial data volume that will be created and attached to a virtual machine DB system. You can scale up storage after provisioning, as needed. Note that the total storage size attached will be more than the amount you specify to allow for REDO/RECO space and software volume. Required for VMDBs.

databaseEdition String

The Oracle Database Edition that applies to all the databases on the DB system. Exadata DB systems and 2-node RAC DB systems require ENTERPRISE_EDITION_EXTREME_PERFORMANCE.

dbSystemOptions Property Map

The DB system options.

definedTags Map<Any>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

diskRedundancy String

The type of redundancy configured for the DB system. Normal is 2-way redundancy, recommended for test and development systems. High is 3-way redundancy, recommended for production systems.

displayName String

The user-friendly name for the DB system. The name does not have to be unique.

domain String

A domain name used for the DB system. If the Oracle-provided Internet and VCN Resolver is enabled for the specified subnet, the domain name for the subnet is used (do not provide one). Otherwise, provide a valid DNS domain name. Hyphens (-) are not permitted.

faultDomains List<String>

A Fault Domain is a grouping of hardware and infrastructure within an availability domain. Fault Domains let you distribute your instances so that they are not on the same physical hardware within a single availability domain. A hardware failure or maintenance that affects one Fault Domain does not affect DB systems in other Fault Domains.

freeformTags Map<Any>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

kmsKeyId String

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

kmsKeyVersionId String

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

licenseModel String

(Updatable) The Oracle license model that applies to all the databases on the DB system. The default is LICENSE_INCLUDED.

maintenanceWindowDetails Property Map

(Updatable) The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

nodeCount Number

The number of nodes to launch for a 2-node RAC virtual machine DB system. Specify either 1 or 2.

nsgIds List<String>

(Updatable) The list of OCIDs for the network security groups (NSGs) to which this resource belongs. Setting this to an empty list removes all resources from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.
privateIp String

A private IP address of your choice. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. Supported for VM BM shape.

recoStorageSizeInGb Number

The RECO/REDO storage size, in gigabytes, that is currently allocated to the DB system. Applies only for virtual machine DB systems.

source String

The source of the database: Use NONE for creating a new database. Use DB_BACKUP for creating a new database by restoring from a backup. Use DATABASE for creating a new database from an existing database, including archive redo log data. The default is NONE.

sourceDbSystemId String

The OCID of the DB system.

sparseDiskgroup Boolean

If true, Sparse Diskgroup is configured for Exadata dbsystem. If False, Sparse diskgroup is not configured. Only applied for Exadata shape.

storageVolumePerformanceMode String

The block storage volume performance level. Valid values are BALANCED and HIGH_PERFORMANCE. See Block Volume Performance for more information.

timeZone String

The time zone to use for the DB system. For details, see DB System Time Zones.

Outputs

All input properties are implicitly available as output properties. Additionally, the DbSystem resource produces the following output properties:

Id string

The provider-assigned unique ID for this managed resource.

IormConfigCaches List<DbSystemIormConfigCach>

The IORM settings of the Exadata DB system.

LastMaintenanceRunId string

The OCID of the last maintenance run.

LastPatchHistoryEntryId string

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

LifecycleDetails string

Additional information about the current lifecycle state.

ListenerPort int

The port number configured for the listener on the DB system.

MaintenanceWindows List<DbSystemMaintenanceWindow>

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

MemorySizeInGbs int

Memory allocated to the DB system, in gigabytes.

NextMaintenanceRunId string

The OCID of the next maintenance run.

PointInTimeDataDiskCloneTimestamp string

The point in time for a cloned database system when the data disks were cloned from the source database system, as described in RFC 3339.

ScanDnsName string

The FQDN of the DNS record for the SCAN IP addresses that are associated with the DB system.

ScanDnsRecordId string

The OCID of the DNS record for the SCAN IP addresses that are associated with the DB system.

ScanIpIds List<string>

The OCID of the Single Client Access Name (SCAN) IP addresses associated with the DB system. SCAN IP addresses are typically used for load balancing and are not assigned to any interface. Oracle Clusterware directs the requests to the appropriate nodes in the cluster.

State string

The current state of the DB system.

TimeCreated string

The date and time the DB system was created.

Version string

The Oracle Database version of the DB system.

VipIds List<string>

The OCID of the virtual IP (VIP) addresses associated with the DB system. The Cluster Ready Services (CRS) creates and maintains one VIP address for each node in the DB system to enable failover. If one node fails, the VIP is reassigned to another active node in the cluster.

ZoneId string

The OCID of the zone the DB system is associated with.

Id string

The provider-assigned unique ID for this managed resource.

IormConfigCaches []DbSystemIormConfigCach

The IORM settings of the Exadata DB system.

LastMaintenanceRunId string

The OCID of the last maintenance run.

LastPatchHistoryEntryId string

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

LifecycleDetails string

Additional information about the current lifecycle state.

ListenerPort int

The port number configured for the listener on the DB system.

MaintenanceWindows []DbSystemMaintenanceWindow

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

MemorySizeInGbs int

Memory allocated to the DB system, in gigabytes.

NextMaintenanceRunId string

The OCID of the next maintenance run.

PointInTimeDataDiskCloneTimestamp string

The point in time for a cloned database system when the data disks were cloned from the source database system, as described in RFC 3339.

ScanDnsName string

The FQDN of the DNS record for the SCAN IP addresses that are associated with the DB system.

ScanDnsRecordId string

The OCID of the DNS record for the SCAN IP addresses that are associated with the DB system.

ScanIpIds []string

The OCID of the Single Client Access Name (SCAN) IP addresses associated with the DB system. SCAN IP addresses are typically used for load balancing and are not assigned to any interface. Oracle Clusterware directs the requests to the appropriate nodes in the cluster.

State string

The current state of the DB system.

TimeCreated string

The date and time the DB system was created.

Version string

The Oracle Database version of the DB system.

VipIds []string

The OCID of the virtual IP (VIP) addresses associated with the DB system. The Cluster Ready Services (CRS) creates and maintains one VIP address for each node in the DB system to enable failover. If one node fails, the VIP is reassigned to another active node in the cluster.

ZoneId string

The OCID of the zone the DB system is associated with.

id String

The provider-assigned unique ID for this managed resource.

iormConfigCaches List<DbSystemIormConfigCach>

The IORM settings of the Exadata DB system.

lastMaintenanceRunId String

The OCID of the last maintenance run.

lastPatchHistoryEntryId String

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

lifecycleDetails String

Additional information about the current lifecycle state.

listenerPort Integer

The port number configured for the listener on the DB system.

maintenanceWindows List<DbSystemMaintenanceWindow>

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

memorySizeInGbs Integer

Memory allocated to the DB system, in gigabytes.

nextMaintenanceRunId String

The OCID of the next maintenance run.

pointInTimeDataDiskCloneTimestamp String

The point in time for a cloned database system when the data disks were cloned from the source database system, as described in RFC 3339.

scanDnsName String

The FQDN of the DNS record for the SCAN IP addresses that are associated with the DB system.

scanDnsRecordId String

The OCID of the DNS record for the SCAN IP addresses that are associated with the DB system.

scanIpIds List<String>

The OCID of the Single Client Access Name (SCAN) IP addresses associated with the DB system. SCAN IP addresses are typically used for load balancing and are not assigned to any interface. Oracle Clusterware directs the requests to the appropriate nodes in the cluster.

state String

The current state of the DB system.

timeCreated String

The date and time the DB system was created.

version String

The Oracle Database version of the DB system.

vipIds List<String>

The OCID of the virtual IP (VIP) addresses associated with the DB system. The Cluster Ready Services (CRS) creates and maintains one VIP address for each node in the DB system to enable failover. If one node fails, the VIP is reassigned to another active node in the cluster.

zoneId String

The OCID of the zone the DB system is associated with.

id string

The provider-assigned unique ID for this managed resource.

iormConfigCaches DbSystemIormConfigCach[]

The IORM settings of the Exadata DB system.

lastMaintenanceRunId string

The OCID of the last maintenance run.

lastPatchHistoryEntryId string

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

lifecycleDetails string

Additional information about the current lifecycle state.

listenerPort number

The port number configured for the listener on the DB system.

maintenanceWindows DbSystemMaintenanceWindow[]

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

memorySizeInGbs number

Memory allocated to the DB system, in gigabytes.

nextMaintenanceRunId string

The OCID of the next maintenance run.

pointInTimeDataDiskCloneTimestamp string

The point in time for a cloned database system when the data disks were cloned from the source database system, as described in RFC 3339.

scanDnsName string

The FQDN of the DNS record for the SCAN IP addresses that are associated with the DB system.

scanDnsRecordId string

The OCID of the DNS record for the SCAN IP addresses that are associated with the DB system.

scanIpIds string[]

The OCID of the Single Client Access Name (SCAN) IP addresses associated with the DB system. SCAN IP addresses are typically used for load balancing and are not assigned to any interface. Oracle Clusterware directs the requests to the appropriate nodes in the cluster.

state string

The current state of the DB system.

timeCreated string

The date and time the DB system was created.

version string

The Oracle Database version of the DB system.

vipIds string[]

The OCID of the virtual IP (VIP) addresses associated with the DB system. The Cluster Ready Services (CRS) creates and maintains one VIP address for each node in the DB system to enable failover. If one node fails, the VIP is reassigned to another active node in the cluster.

zoneId string

The OCID of the zone the DB system is associated with.

id str

The provider-assigned unique ID for this managed resource.

iorm_config_caches DbSystemIormConfigCach]

The IORM settings of the Exadata DB system.

last_maintenance_run_id str

The OCID of the last maintenance run.

last_patch_history_entry_id str

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

lifecycle_details str

Additional information about the current lifecycle state.

listener_port int

The port number configured for the listener on the DB system.

maintenance_windows DbSystemMaintenanceWindow]

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

memory_size_in_gbs int

Memory allocated to the DB system, in gigabytes.

next_maintenance_run_id str

The OCID of the next maintenance run.

point_in_time_data_disk_clone_timestamp str

The point in time for a cloned database system when the data disks were cloned from the source database system, as described in RFC 3339.

scan_dns_name str

The FQDN of the DNS record for the SCAN IP addresses that are associated with the DB system.

scan_dns_record_id str

The OCID of the DNS record for the SCAN IP addresses that are associated with the DB system.

scan_ip_ids Sequence[str]

The OCID of the Single Client Access Name (SCAN) IP addresses associated with the DB system. SCAN IP addresses are typically used for load balancing and are not assigned to any interface. Oracle Clusterware directs the requests to the appropriate nodes in the cluster.

state str

The current state of the DB system.

time_created str

The date and time the DB system was created.

version str

The Oracle Database version of the DB system.

vip_ids Sequence[str]

The OCID of the virtual IP (VIP) addresses associated with the DB system. The Cluster Ready Services (CRS) creates and maintains one VIP address for each node in the DB system to enable failover. If one node fails, the VIP is reassigned to another active node in the cluster.

zone_id str

The OCID of the zone the DB system is associated with.

id String

The provider-assigned unique ID for this managed resource.

iormConfigCaches List<Property Map>

The IORM settings of the Exadata DB system.

lastMaintenanceRunId String

The OCID of the last maintenance run.

lastPatchHistoryEntryId String

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

lifecycleDetails String

Additional information about the current lifecycle state.

listenerPort Number

The port number configured for the listener on the DB system.

maintenanceWindows List<Property Map>

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

memorySizeInGbs Number

Memory allocated to the DB system, in gigabytes.

nextMaintenanceRunId String

The OCID of the next maintenance run.

pointInTimeDataDiskCloneTimestamp String

The point in time for a cloned database system when the data disks were cloned from the source database system, as described in RFC 3339.

scanDnsName String

The FQDN of the DNS record for the SCAN IP addresses that are associated with the DB system.

scanDnsRecordId String

The OCID of the DNS record for the SCAN IP addresses that are associated with the DB system.

scanIpIds List<String>

The OCID of the Single Client Access Name (SCAN) IP addresses associated with the DB system. SCAN IP addresses are typically used for load balancing and are not assigned to any interface. Oracle Clusterware directs the requests to the appropriate nodes in the cluster.

state String

The current state of the DB system.

timeCreated String

The date and time the DB system was created.

version String

The Oracle Database version of the DB system.

vipIds List<String>

The OCID of the virtual IP (VIP) addresses associated with the DB system. The Cluster Ready Services (CRS) creates and maintains one VIP address for each node in the DB system to enable failover. If one node fails, the VIP is reassigned to another active node in the cluster.

zoneId String

The OCID of the zone the DB system is associated with.

Look up Existing DbSystem Resource

Get an existing DbSystem resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

public static get(name: string, id: Input<ID>, state?: DbSystemState, opts?: CustomResourceOptions): DbSystem
@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        availability_domain: Optional[str] = None,
        backup_network_nsg_ids: Optional[Sequence[str]] = None,
        backup_subnet_id: Optional[str] = None,
        cluster_name: Optional[str] = None,
        compartment_id: Optional[str] = None,
        cpu_core_count: Optional[int] = None,
        data_collection_options: Optional[_database.DbSystemDataCollectionOptionsArgs] = None,
        data_storage_percentage: Optional[int] = None,
        data_storage_size_in_gb: Optional[int] = None,
        database_edition: Optional[str] = None,
        db_home: Optional[_database.DbSystemDbHomeArgs] = None,
        db_system_options: Optional[_database.DbSystemDbSystemOptionsArgs] = None,
        defined_tags: Optional[Mapping[str, Any]] = None,
        disk_redundancy: Optional[str] = None,
        display_name: Optional[str] = None,
        domain: Optional[str] = None,
        fault_domains: Optional[Sequence[str]] = None,
        freeform_tags: Optional[Mapping[str, Any]] = None,
        hostname: Optional[str] = None,
        iorm_config_caches: Optional[Sequence[_database.DbSystemIormConfigCachArgs]] = None,
        kms_key_id: Optional[str] = None,
        kms_key_version_id: Optional[str] = None,
        last_maintenance_run_id: Optional[str] = None,
        last_patch_history_entry_id: Optional[str] = None,
        license_model: Optional[str] = None,
        lifecycle_details: Optional[str] = None,
        listener_port: Optional[int] = None,
        maintenance_window_details: Optional[_database.DbSystemMaintenanceWindowDetailsArgs] = None,
        maintenance_windows: Optional[Sequence[_database.DbSystemMaintenanceWindowArgs]] = None,
        memory_size_in_gbs: Optional[int] = None,
        next_maintenance_run_id: Optional[str] = None,
        node_count: Optional[int] = None,
        nsg_ids: Optional[Sequence[str]] = None,
        point_in_time_data_disk_clone_timestamp: Optional[str] = None,
        private_ip: Optional[str] = None,
        reco_storage_size_in_gb: Optional[int] = None,
        scan_dns_name: Optional[str] = None,
        scan_dns_record_id: Optional[str] = None,
        scan_ip_ids: Optional[Sequence[str]] = None,
        shape: Optional[str] = None,
        source: Optional[str] = None,
        source_db_system_id: Optional[str] = None,
        sparse_diskgroup: Optional[bool] = None,
        ssh_public_keys: Optional[Sequence[str]] = None,
        state: Optional[str] = None,
        storage_volume_performance_mode: Optional[str] = None,
        subnet_id: Optional[str] = None,
        time_created: Optional[str] = None,
        time_zone: Optional[str] = None,
        version: Optional[str] = None,
        vip_ids: Optional[Sequence[str]] = None,
        zone_id: Optional[str] = None) -> DbSystem
func GetDbSystem(ctx *Context, name string, id IDInput, state *DbSystemState, opts ...ResourceOption) (*DbSystem, error)
public static DbSystem Get(string name, Input<string> id, DbSystemState? state, CustomResourceOptions? opts = null)
public static DbSystem get(String name, Output<String> id, DbSystemState state, CustomResourceOptions options)
Resource lookup is not supported in YAML
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
resource_name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
name
The unique name of the resulting resource.
id
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
The following state arguments are supported:
AvailabilityDomain string

The availability domain where the DB system is located.

BackupNetworkNsgIds List<string>

(Updatable) A list of the OCIDs of the network security groups (NSGs) that the backup network of this DB system belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. Applicable only to Exadata systems.

BackupSubnetId string

The OCID of the backup network subnet the DB system is associated with. Applicable only to Exadata DB systems.

ClusterName string

The cluster name for Exadata and 2-node RAC virtual machine DB systems. The cluster name must begin with an alphabetic character, and may contain hyphens (-). Underscores (_) are not permitted. The cluster name can be no longer than 11 characters and is not case sensitive.

CompartmentId string

(Updatable) The OCID of the compartment the DB system belongs in.

CpuCoreCount int

(Updatable) The number of CPU cores to enable for a bare metal or Exadata DB system or AMD VMDB Systems. The valid values depend on the specified shape:

  • BM.DenseIO1.36 - Specify a multiple of 2, from 2 to 36.
  • BM.DenseIO2.52 - Specify a multiple of 2, from 2 to 52.
  • Exadata.Base.48 - Specify a multiple of 2, from 0 to 48.
  • Exadata.Quarter1.84 - Specify a multiple of 2, from 22 to 84.
  • Exadata.Half1.168 - Specify a multiple of 4, from 44 to 168.
  • Exadata.Full1.336 - Specify a multiple of 8, from 88 to 336.
  • Exadata.Quarter2.92 - Specify a multiple of 2, from 0 to 92.
  • Exadata.Half2.184 - Specify a multiple of 4, from 0 to 184.
  • Exadata.Full2.368 - Specify a multiple of 8, from 0 to 368.
  • VM.Standard.E4.Flex - Specify any thing from 1 to 64.
DataCollectionOptions DbSystemDataCollectionOptionsArgs

(Updatable) Indicates user preferences for the various diagnostic collection options for the VM cluster/Cloud VM cluster/VMBM DBCS.

DataStoragePercentage int

The percentage assigned to DATA storage (user data and database files). The remaining percentage is assigned to RECO storage (database redo logs, archive logs, and recovery manager backups). Specify 80 or 40. The default is 80 percent assigned to DATA storage. Not applicable for virtual machine DB systems. Required for BMDBs.

DataStorageSizeInGb int

(Updatable) Size (in GB) of the initial data volume that will be created and attached to a virtual machine DB system. You can scale up storage after provisioning, as needed. Note that the total storage size attached will be more than the amount you specify to allow for REDO/RECO space and software volume. Required for VMDBs.

DatabaseEdition string

The Oracle Database Edition that applies to all the databases on the DB system. Exadata DB systems and 2-node RAC DB systems require ENTERPRISE_EDITION_EXTREME_PERFORMANCE.

DbHome DbSystemDbHomeArgs

(Updatable) Details for creating a Database Home if you are creating a database by restoring from a database backup.

DbSystemOptions DbSystemDbSystemOptionsArgs

The DB system options.

DefinedTags Dictionary<string, object>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

DiskRedundancy string

The type of redundancy configured for the DB system. Normal is 2-way redundancy, recommended for test and development systems. High is 3-way redundancy, recommended for production systems.

DisplayName string

The user-friendly name for the DB system. The name does not have to be unique.

Domain string

A domain name used for the DB system. If the Oracle-provided Internet and VCN Resolver is enabled for the specified subnet, the domain name for the subnet is used (do not provide one). Otherwise, provide a valid DNS domain name. Hyphens (-) are not permitted.

FaultDomains List<string>

A Fault Domain is a grouping of hardware and infrastructure within an availability domain. Fault Domains let you distribute your instances so that they are not on the same physical hardware within a single availability domain. A hardware failure or maintenance that affects one Fault Domain does not affect DB systems in other Fault Domains.

FreeformTags Dictionary<string, object>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

Hostname string

The hostname for the DB system. The hostname must begin with an alphabetic character, and can contain alphanumeric characters and hyphens (-). The maximum length of the hostname is 16 characters for bare metal and virtual machine DB systems, and 12 characters for Exadata DB systems.

IormConfigCaches List<DbSystemIormConfigCachArgs>

The IORM settings of the Exadata DB system.

KmsKeyId string

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

KmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

LastMaintenanceRunId string

The OCID of the last maintenance run.

LastPatchHistoryEntryId string

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

LicenseModel string

(Updatable) The Oracle license model that applies to all the databases on the DB system. The default is LICENSE_INCLUDED.

LifecycleDetails string

Additional information about the current lifecycle state.

ListenerPort int

The port number configured for the listener on the DB system.

MaintenanceWindowDetails DbSystemMaintenanceWindowDetailsArgs

(Updatable) The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

MaintenanceWindows List<DbSystemMaintenanceWindowArgs>

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

MemorySizeInGbs int

Memory allocated to the DB system, in gigabytes.

NextMaintenanceRunId string

The OCID of the next maintenance run.

NodeCount int

The number of nodes to launch for a 2-node RAC virtual machine DB system. Specify either 1 or 2.

NsgIds List<string>

(Updatable) The list of OCIDs for the network security groups (NSGs) to which this resource belongs. Setting this to an empty list removes all resources from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.
PointInTimeDataDiskCloneTimestamp string

The point in time for a cloned database system when the data disks were cloned from the source database system, as described in RFC 3339.

PrivateIp string

A private IP address of your choice. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. Supported for VM BM shape.

RecoStorageSizeInGb int

The RECO/REDO storage size, in gigabytes, that is currently allocated to the DB system. Applies only for virtual machine DB systems.

ScanDnsName string

The FQDN of the DNS record for the SCAN IP addresses that are associated with the DB system.

ScanDnsRecordId string

The OCID of the DNS record for the SCAN IP addresses that are associated with the DB system.

ScanIpIds List<string>

The OCID of the Single Client Access Name (SCAN) IP addresses associated with the DB system. SCAN IP addresses are typically used for load balancing and are not assigned to any interface. Oracle Clusterware directs the requests to the appropriate nodes in the cluster.

Shape string

(Updatable) The shape of the DB system. The shape determines resources allocated to the DB system.

  • For virtual machine shapes, the number of CPU cores and memory
  • For bare metal and Exadata shapes, the number of CPU cores, memory, and storage
Source string

The source of the database: Use NONE for creating a new database. Use DB_BACKUP for creating a new database by restoring from a backup. Use DATABASE for creating a new database from an existing database, including archive redo log data. The default is NONE.

SourceDbSystemId string

The OCID of the DB system.

SparseDiskgroup bool

If true, Sparse Diskgroup is configured for Exadata dbsystem. If False, Sparse diskgroup is not configured. Only applied for Exadata shape.

SshPublicKeys List<string>

(Updatable) The public key portion of the key pair to use for SSH access to the DB system. Multiple public keys can be provided. The length of the combined keys cannot exceed 40,000 characters.

State string

The current state of the DB system.

StorageVolumePerformanceMode string

The block storage volume performance level. Valid values are BALANCED and HIGH_PERFORMANCE. See Block Volume Performance for more information.

SubnetId string

The OCID of the subnet the DB system is associated with.

TimeCreated string

The date and time the DB system was created.

TimeZone string

The time zone to use for the DB system. For details, see DB System Time Zones.

Version string

The Oracle Database version of the DB system.

VipIds List<string>

The OCID of the virtual IP (VIP) addresses associated with the DB system. The Cluster Ready Services (CRS) creates and maintains one VIP address for each node in the DB system to enable failover. If one node fails, the VIP is reassigned to another active node in the cluster.

ZoneId string

The OCID of the zone the DB system is associated with.

AvailabilityDomain string

The availability domain where the DB system is located.

BackupNetworkNsgIds []string

(Updatable) A list of the OCIDs of the network security groups (NSGs) that the backup network of this DB system belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. Applicable only to Exadata systems.

BackupSubnetId string

The OCID of the backup network subnet the DB system is associated with. Applicable only to Exadata DB systems.

ClusterName string

The cluster name for Exadata and 2-node RAC virtual machine DB systems. The cluster name must begin with an alphabetic character, and may contain hyphens (-). Underscores (_) are not permitted. The cluster name can be no longer than 11 characters and is not case sensitive.

CompartmentId string

(Updatable) The OCID of the compartment the DB system belongs in.

CpuCoreCount int

(Updatable) The number of CPU cores to enable for a bare metal or Exadata DB system or AMD VMDB Systems. The valid values depend on the specified shape:

  • BM.DenseIO1.36 - Specify a multiple of 2, from 2 to 36.
  • BM.DenseIO2.52 - Specify a multiple of 2, from 2 to 52.
  • Exadata.Base.48 - Specify a multiple of 2, from 0 to 48.
  • Exadata.Quarter1.84 - Specify a multiple of 2, from 22 to 84.
  • Exadata.Half1.168 - Specify a multiple of 4, from 44 to 168.
  • Exadata.Full1.336 - Specify a multiple of 8, from 88 to 336.
  • Exadata.Quarter2.92 - Specify a multiple of 2, from 0 to 92.
  • Exadata.Half2.184 - Specify a multiple of 4, from 0 to 184.
  • Exadata.Full2.368 - Specify a multiple of 8, from 0 to 368.
  • VM.Standard.E4.Flex - Specify any thing from 1 to 64.
DataCollectionOptions DbSystemDataCollectionOptionsArgs

(Updatable) Indicates user preferences for the various diagnostic collection options for the VM cluster/Cloud VM cluster/VMBM DBCS.

DataStoragePercentage int

The percentage assigned to DATA storage (user data and database files). The remaining percentage is assigned to RECO storage (database redo logs, archive logs, and recovery manager backups). Specify 80 or 40. The default is 80 percent assigned to DATA storage. Not applicable for virtual machine DB systems. Required for BMDBs.

DataStorageSizeInGb int

(Updatable) Size (in GB) of the initial data volume that will be created and attached to a virtual machine DB system. You can scale up storage after provisioning, as needed. Note that the total storage size attached will be more than the amount you specify to allow for REDO/RECO space and software volume. Required for VMDBs.

DatabaseEdition string

The Oracle Database Edition that applies to all the databases on the DB system. Exadata DB systems and 2-node RAC DB systems require ENTERPRISE_EDITION_EXTREME_PERFORMANCE.

DbHome DbSystemDbHomeArgs

(Updatable) Details for creating a Database Home if you are creating a database by restoring from a database backup.

DbSystemOptions DbSystemDbSystemOptionsArgs

The DB system options.

DefinedTags map[string]interface{}

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

DiskRedundancy string

The type of redundancy configured for the DB system. Normal is 2-way redundancy, recommended for test and development systems. High is 3-way redundancy, recommended for production systems.

DisplayName string

The user-friendly name for the DB system. The name does not have to be unique.

Domain string

A domain name used for the DB system. If the Oracle-provided Internet and VCN Resolver is enabled for the specified subnet, the domain name for the subnet is used (do not provide one). Otherwise, provide a valid DNS domain name. Hyphens (-) are not permitted.

FaultDomains []string

A Fault Domain is a grouping of hardware and infrastructure within an availability domain. Fault Domains let you distribute your instances so that they are not on the same physical hardware within a single availability domain. A hardware failure or maintenance that affects one Fault Domain does not affect DB systems in other Fault Domains.

FreeformTags map[string]interface{}

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

Hostname string

The hostname for the DB system. The hostname must begin with an alphabetic character, and can contain alphanumeric characters and hyphens (-). The maximum length of the hostname is 16 characters for bare metal and virtual machine DB systems, and 12 characters for Exadata DB systems.

IormConfigCaches []DbSystemIormConfigCachArgs

The IORM settings of the Exadata DB system.

KmsKeyId string

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

KmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

LastMaintenanceRunId string

The OCID of the last maintenance run.

LastPatchHistoryEntryId string

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

LicenseModel string

(Updatable) The Oracle license model that applies to all the databases on the DB system. The default is LICENSE_INCLUDED.

LifecycleDetails string

Additional information about the current lifecycle state.

ListenerPort int

The port number configured for the listener on the DB system.

MaintenanceWindowDetails DbSystemMaintenanceWindowDetailsArgs

(Updatable) The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

MaintenanceWindows []DbSystemMaintenanceWindowArgs

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

MemorySizeInGbs int

Memory allocated to the DB system, in gigabytes.

NextMaintenanceRunId string

The OCID of the next maintenance run.

NodeCount int

The number of nodes to launch for a 2-node RAC virtual machine DB system. Specify either 1 or 2.

NsgIds []string

(Updatable) The list of OCIDs for the network security groups (NSGs) to which this resource belongs. Setting this to an empty list removes all resources from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.
PointInTimeDataDiskCloneTimestamp string

The point in time for a cloned database system when the data disks were cloned from the source database system, as described in RFC 3339.

PrivateIp string

A private IP address of your choice. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. Supported for VM BM shape.

RecoStorageSizeInGb int

The RECO/REDO storage size, in gigabytes, that is currently allocated to the DB system. Applies only for virtual machine DB systems.

ScanDnsName string

The FQDN of the DNS record for the SCAN IP addresses that are associated with the DB system.

ScanDnsRecordId string

The OCID of the DNS record for the SCAN IP addresses that are associated with the DB system.

ScanIpIds []string

The OCID of the Single Client Access Name (SCAN) IP addresses associated with the DB system. SCAN IP addresses are typically used for load balancing and are not assigned to any interface. Oracle Clusterware directs the requests to the appropriate nodes in the cluster.

Shape string

(Updatable) The shape of the DB system. The shape determines resources allocated to the DB system.

  • For virtual machine shapes, the number of CPU cores and memory
  • For bare metal and Exadata shapes, the number of CPU cores, memory, and storage
Source string

The source of the database: Use NONE for creating a new database. Use DB_BACKUP for creating a new database by restoring from a backup. Use DATABASE for creating a new database from an existing database, including archive redo log data. The default is NONE.

SourceDbSystemId string

The OCID of the DB system.

SparseDiskgroup bool

If true, Sparse Diskgroup is configured for Exadata dbsystem. If False, Sparse diskgroup is not configured. Only applied for Exadata shape.

SshPublicKeys []string

(Updatable) The public key portion of the key pair to use for SSH access to the DB system. Multiple public keys can be provided. The length of the combined keys cannot exceed 40,000 characters.

State string

The current state of the DB system.

StorageVolumePerformanceMode string

The block storage volume performance level. Valid values are BALANCED and HIGH_PERFORMANCE. See Block Volume Performance for more information.

SubnetId string

The OCID of the subnet the DB system is associated with.

TimeCreated string

The date and time the DB system was created.

TimeZone string

The time zone to use for the DB system. For details, see DB System Time Zones.

Version string

The Oracle Database version of the DB system.

VipIds []string

The OCID of the virtual IP (VIP) addresses associated with the DB system. The Cluster Ready Services (CRS) creates and maintains one VIP address for each node in the DB system to enable failover. If one node fails, the VIP is reassigned to another active node in the cluster.

ZoneId string

The OCID of the zone the DB system is associated with.

availabilityDomain String

The availability domain where the DB system is located.

backupNetworkNsgIds List<String>

(Updatable) A list of the OCIDs of the network security groups (NSGs) that the backup network of this DB system belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. Applicable only to Exadata systems.

backupSubnetId String

The OCID of the backup network subnet the DB system is associated with. Applicable only to Exadata DB systems.

clusterName String

The cluster name for Exadata and 2-node RAC virtual machine DB systems. The cluster name must begin with an alphabetic character, and may contain hyphens (-). Underscores (_) are not permitted. The cluster name can be no longer than 11 characters and is not case sensitive.

compartmentId String

(Updatable) The OCID of the compartment the DB system belongs in.

cpuCoreCount Integer

(Updatable) The number of CPU cores to enable for a bare metal or Exadata DB system or AMD VMDB Systems. The valid values depend on the specified shape:

  • BM.DenseIO1.36 - Specify a multiple of 2, from 2 to 36.
  • BM.DenseIO2.52 - Specify a multiple of 2, from 2 to 52.
  • Exadata.Base.48 - Specify a multiple of 2, from 0 to 48.
  • Exadata.Quarter1.84 - Specify a multiple of 2, from 22 to 84.
  • Exadata.Half1.168 - Specify a multiple of 4, from 44 to 168.
  • Exadata.Full1.336 - Specify a multiple of 8, from 88 to 336.
  • Exadata.Quarter2.92 - Specify a multiple of 2, from 0 to 92.
  • Exadata.Half2.184 - Specify a multiple of 4, from 0 to 184.
  • Exadata.Full2.368 - Specify a multiple of 8, from 0 to 368.
  • VM.Standard.E4.Flex - Specify any thing from 1 to 64.
dataCollectionOptions DbSystemDataCollectionOptionsArgs

(Updatable) Indicates user preferences for the various diagnostic collection options for the VM cluster/Cloud VM cluster/VMBM DBCS.

dataStoragePercentage Integer

The percentage assigned to DATA storage (user data and database files). The remaining percentage is assigned to RECO storage (database redo logs, archive logs, and recovery manager backups). Specify 80 or 40. The default is 80 percent assigned to DATA storage. Not applicable for virtual machine DB systems. Required for BMDBs.

dataStorageSizeInGb Integer

(Updatable) Size (in GB) of the initial data volume that will be created and attached to a virtual machine DB system. You can scale up storage after provisioning, as needed. Note that the total storage size attached will be more than the amount you specify to allow for REDO/RECO space and software volume. Required for VMDBs.

databaseEdition String

The Oracle Database Edition that applies to all the databases on the DB system. Exadata DB systems and 2-node RAC DB systems require ENTERPRISE_EDITION_EXTREME_PERFORMANCE.

dbHome DbSystemDbHomeArgs

(Updatable) Details for creating a Database Home if you are creating a database by restoring from a database backup.

dbSystemOptions DbSystemDbSystemOptionsArgs

The DB system options.

definedTags Map<String,Object>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

diskRedundancy String

The type of redundancy configured for the DB system. Normal is 2-way redundancy, recommended for test and development systems. High is 3-way redundancy, recommended for production systems.

displayName String

The user-friendly name for the DB system. The name does not have to be unique.

domain String

A domain name used for the DB system. If the Oracle-provided Internet and VCN Resolver is enabled for the specified subnet, the domain name for the subnet is used (do not provide one). Otherwise, provide a valid DNS domain name. Hyphens (-) are not permitted.

faultDomains List<String>

A Fault Domain is a grouping of hardware and infrastructure within an availability domain. Fault Domains let you distribute your instances so that they are not on the same physical hardware within a single availability domain. A hardware failure or maintenance that affects one Fault Domain does not affect DB systems in other Fault Domains.

freeformTags Map<String,Object>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

hostname String

The hostname for the DB system. The hostname must begin with an alphabetic character, and can contain alphanumeric characters and hyphens (-). The maximum length of the hostname is 16 characters for bare metal and virtual machine DB systems, and 12 characters for Exadata DB systems.

iormConfigCaches List<DbSystemIormConfigCachArgs>

The IORM settings of the Exadata DB system.

kmsKeyId String

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

kmsKeyVersionId String

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

lastMaintenanceRunId String

The OCID of the last maintenance run.

lastPatchHistoryEntryId String

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

licenseModel String

(Updatable) The Oracle license model that applies to all the databases on the DB system. The default is LICENSE_INCLUDED.

lifecycleDetails String

Additional information about the current lifecycle state.

listenerPort Integer

The port number configured for the listener on the DB system.

maintenanceWindowDetails DbSystemMaintenanceWindowDetailsArgs

(Updatable) The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

maintenanceWindows List<DbSystemMaintenanceWindowArgs>

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

memorySizeInGbs Integer

Memory allocated to the DB system, in gigabytes.

nextMaintenanceRunId String

The OCID of the next maintenance run.

nodeCount Integer

The number of nodes to launch for a 2-node RAC virtual machine DB system. Specify either 1 or 2.

nsgIds List<String>

(Updatable) The list of OCIDs for the network security groups (NSGs) to which this resource belongs. Setting this to an empty list removes all resources from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.
pointInTimeDataDiskCloneTimestamp String

The point in time for a cloned database system when the data disks were cloned from the source database system, as described in RFC 3339.

privateIp String

A private IP address of your choice. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. Supported for VM BM shape.

recoStorageSizeInGb Integer

The RECO/REDO storage size, in gigabytes, that is currently allocated to the DB system. Applies only for virtual machine DB systems.

scanDnsName String

The FQDN of the DNS record for the SCAN IP addresses that are associated with the DB system.

scanDnsRecordId String

The OCID of the DNS record for the SCAN IP addresses that are associated with the DB system.

scanIpIds List<String>

The OCID of the Single Client Access Name (SCAN) IP addresses associated with the DB system. SCAN IP addresses are typically used for load balancing and are not assigned to any interface. Oracle Clusterware directs the requests to the appropriate nodes in the cluster.

shape String

(Updatable) The shape of the DB system. The shape determines resources allocated to the DB system.

  • For virtual machine shapes, the number of CPU cores and memory
  • For bare metal and Exadata shapes, the number of CPU cores, memory, and storage
source String

The source of the database: Use NONE for creating a new database. Use DB_BACKUP for creating a new database by restoring from a backup. Use DATABASE for creating a new database from an existing database, including archive redo log data. The default is NONE.

sourceDbSystemId String

The OCID of the DB system.

sparseDiskgroup Boolean

If true, Sparse Diskgroup is configured for Exadata dbsystem. If False, Sparse diskgroup is not configured. Only applied for Exadata shape.

sshPublicKeys List<String>

(Updatable) The public key portion of the key pair to use for SSH access to the DB system. Multiple public keys can be provided. The length of the combined keys cannot exceed 40,000 characters.

state String

The current state of the DB system.

storageVolumePerformanceMode String

The block storage volume performance level. Valid values are BALANCED and HIGH_PERFORMANCE. See Block Volume Performance for more information.

subnetId String

The OCID of the subnet the DB system is associated with.

timeCreated String

The date and time the DB system was created.

timeZone String

The time zone to use for the DB system. For details, see DB System Time Zones.

version String

The Oracle Database version of the DB system.

vipIds List<String>

The OCID of the virtual IP (VIP) addresses associated with the DB system. The Cluster Ready Services (CRS) creates and maintains one VIP address for each node in the DB system to enable failover. If one node fails, the VIP is reassigned to another active node in the cluster.

zoneId String

The OCID of the zone the DB system is associated with.

availabilityDomain string

The availability domain where the DB system is located.

backupNetworkNsgIds string[]

(Updatable) A list of the OCIDs of the network security groups (NSGs) that the backup network of this DB system belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. Applicable only to Exadata systems.

backupSubnetId string

The OCID of the backup network subnet the DB system is associated with. Applicable only to Exadata DB systems.

clusterName string

The cluster name for Exadata and 2-node RAC virtual machine DB systems. The cluster name must begin with an alphabetic character, and may contain hyphens (-). Underscores (_) are not permitted. The cluster name can be no longer than 11 characters and is not case sensitive.

compartmentId string

(Updatable) The OCID of the compartment the DB system belongs in.

cpuCoreCount number

(Updatable) The number of CPU cores to enable for a bare metal or Exadata DB system or AMD VMDB Systems. The valid values depend on the specified shape:

  • BM.DenseIO1.36 - Specify a multiple of 2, from 2 to 36.
  • BM.DenseIO2.52 - Specify a multiple of 2, from 2 to 52.
  • Exadata.Base.48 - Specify a multiple of 2, from 0 to 48.
  • Exadata.Quarter1.84 - Specify a multiple of 2, from 22 to 84.
  • Exadata.Half1.168 - Specify a multiple of 4, from 44 to 168.
  • Exadata.Full1.336 - Specify a multiple of 8, from 88 to 336.
  • Exadata.Quarter2.92 - Specify a multiple of 2, from 0 to 92.
  • Exadata.Half2.184 - Specify a multiple of 4, from 0 to 184.
  • Exadata.Full2.368 - Specify a multiple of 8, from 0 to 368.
  • VM.Standard.E4.Flex - Specify any thing from 1 to 64.
dataCollectionOptions DbSystemDataCollectionOptionsArgs

(Updatable) Indicates user preferences for the various diagnostic collection options for the VM cluster/Cloud VM cluster/VMBM DBCS.

dataStoragePercentage number

The percentage assigned to DATA storage (user data and database files). The remaining percentage is assigned to RECO storage (database redo logs, archive logs, and recovery manager backups). Specify 80 or 40. The default is 80 percent assigned to DATA storage. Not applicable for virtual machine DB systems. Required for BMDBs.

dataStorageSizeInGb number

(Updatable) Size (in GB) of the initial data volume that will be created and attached to a virtual machine DB system. You can scale up storage after provisioning, as needed. Note that the total storage size attached will be more than the amount you specify to allow for REDO/RECO space and software volume. Required for VMDBs.

databaseEdition string

The Oracle Database Edition that applies to all the databases on the DB system. Exadata DB systems and 2-node RAC DB systems require ENTERPRISE_EDITION_EXTREME_PERFORMANCE.

dbHome DbSystemDbHomeArgs

(Updatable) Details for creating a Database Home if you are creating a database by restoring from a database backup.

dbSystemOptions DbSystemDbSystemOptionsArgs

The DB system options.

definedTags {[key: string]: any}

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

diskRedundancy string

The type of redundancy configured for the DB system. Normal is 2-way redundancy, recommended for test and development systems. High is 3-way redundancy, recommended for production systems.

displayName string

The user-friendly name for the DB system. The name does not have to be unique.

domain string

A domain name used for the DB system. If the Oracle-provided Internet and VCN Resolver is enabled for the specified subnet, the domain name for the subnet is used (do not provide one). Otherwise, provide a valid DNS domain name. Hyphens (-) are not permitted.

faultDomains string[]

A Fault Domain is a grouping of hardware and infrastructure within an availability domain. Fault Domains let you distribute your instances so that they are not on the same physical hardware within a single availability domain. A hardware failure or maintenance that affects one Fault Domain does not affect DB systems in other Fault Domains.

freeformTags {[key: string]: any}

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

hostname string

The hostname for the DB system. The hostname must begin with an alphabetic character, and can contain alphanumeric characters and hyphens (-). The maximum length of the hostname is 16 characters for bare metal and virtual machine DB systems, and 12 characters for Exadata DB systems.

iormConfigCaches DbSystemIormConfigCachArgs[]

The IORM settings of the Exadata DB system.

kmsKeyId string

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

kmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

lastMaintenanceRunId string

The OCID of the last maintenance run.

lastPatchHistoryEntryId string

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

licenseModel string

(Updatable) The Oracle license model that applies to all the databases on the DB system. The default is LICENSE_INCLUDED.

lifecycleDetails string

Additional information about the current lifecycle state.

listenerPort number

The port number configured for the listener on the DB system.

maintenanceWindowDetails DbSystemMaintenanceWindowDetailsArgs

(Updatable) The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

maintenanceWindows DbSystemMaintenanceWindowArgs[]

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

memorySizeInGbs number

Memory allocated to the DB system, in gigabytes.

nextMaintenanceRunId string

The OCID of the next maintenance run.

nodeCount number

The number of nodes to launch for a 2-node RAC virtual machine DB system. Specify either 1 or 2.

nsgIds string[]

(Updatable) The list of OCIDs for the network security groups (NSGs) to which this resource belongs. Setting this to an empty list removes all resources from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.
pointInTimeDataDiskCloneTimestamp string

The point in time for a cloned database system when the data disks were cloned from the source database system, as described in RFC 3339.

privateIp string

A private IP address of your choice. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. Supported for VM BM shape.

recoStorageSizeInGb number

The RECO/REDO storage size, in gigabytes, that is currently allocated to the DB system. Applies only for virtual machine DB systems.

scanDnsName string

The FQDN of the DNS record for the SCAN IP addresses that are associated with the DB system.

scanDnsRecordId string

The OCID of the DNS record for the SCAN IP addresses that are associated with the DB system.

scanIpIds string[]

The OCID of the Single Client Access Name (SCAN) IP addresses associated with the DB system. SCAN IP addresses are typically used for load balancing and are not assigned to any interface. Oracle Clusterware directs the requests to the appropriate nodes in the cluster.

shape string

(Updatable) The shape of the DB system. The shape determines resources allocated to the DB system.

  • For virtual machine shapes, the number of CPU cores and memory
  • For bare metal and Exadata shapes, the number of CPU cores, memory, and storage
source string

The source of the database: Use NONE for creating a new database. Use DB_BACKUP for creating a new database by restoring from a backup. Use DATABASE for creating a new database from an existing database, including archive redo log data. The default is NONE.

sourceDbSystemId string

The OCID of the DB system.

sparseDiskgroup boolean

If true, Sparse Diskgroup is configured for Exadata dbsystem. If False, Sparse diskgroup is not configured. Only applied for Exadata shape.

sshPublicKeys string[]

(Updatable) The public key portion of the key pair to use for SSH access to the DB system. Multiple public keys can be provided. The length of the combined keys cannot exceed 40,000 characters.

state string

The current state of the DB system.

storageVolumePerformanceMode string

The block storage volume performance level. Valid values are BALANCED and HIGH_PERFORMANCE. See Block Volume Performance for more information.

subnetId string

The OCID of the subnet the DB system is associated with.

timeCreated string

The date and time the DB system was created.

timeZone string

The time zone to use for the DB system. For details, see DB System Time Zones.

version string

The Oracle Database version of the DB system.

vipIds string[]

The OCID of the virtual IP (VIP) addresses associated with the DB system. The Cluster Ready Services (CRS) creates and maintains one VIP address for each node in the DB system to enable failover. If one node fails, the VIP is reassigned to another active node in the cluster.

zoneId string

The OCID of the zone the DB system is associated with.

availability_domain str

The availability domain where the DB system is located.

backup_network_nsg_ids Sequence[str]

(Updatable) A list of the OCIDs of the network security groups (NSGs) that the backup network of this DB system belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. Applicable only to Exadata systems.

backup_subnet_id str

The OCID of the backup network subnet the DB system is associated with. Applicable only to Exadata DB systems.

cluster_name str

The cluster name for Exadata and 2-node RAC virtual machine DB systems. The cluster name must begin with an alphabetic character, and may contain hyphens (-). Underscores (_) are not permitted. The cluster name can be no longer than 11 characters and is not case sensitive.

compartment_id str

(Updatable) The OCID of the compartment the DB system belongs in.

cpu_core_count int

(Updatable) The number of CPU cores to enable for a bare metal or Exadata DB system or AMD VMDB Systems. The valid values depend on the specified shape:

  • BM.DenseIO1.36 - Specify a multiple of 2, from 2 to 36.
  • BM.DenseIO2.52 - Specify a multiple of 2, from 2 to 52.
  • Exadata.Base.48 - Specify a multiple of 2, from 0 to 48.
  • Exadata.Quarter1.84 - Specify a multiple of 2, from 22 to 84.
  • Exadata.Half1.168 - Specify a multiple of 4, from 44 to 168.
  • Exadata.Full1.336 - Specify a multiple of 8, from 88 to 336.
  • Exadata.Quarter2.92 - Specify a multiple of 2, from 0 to 92.
  • Exadata.Half2.184 - Specify a multiple of 4, from 0 to 184.
  • Exadata.Full2.368 - Specify a multiple of 8, from 0 to 368.
  • VM.Standard.E4.Flex - Specify any thing from 1 to 64.
data_collection_options DbSystemDataCollectionOptionsArgs

(Updatable) Indicates user preferences for the various diagnostic collection options for the VM cluster/Cloud VM cluster/VMBM DBCS.

data_storage_percentage int

The percentage assigned to DATA storage (user data and database files). The remaining percentage is assigned to RECO storage (database redo logs, archive logs, and recovery manager backups). Specify 80 or 40. The default is 80 percent assigned to DATA storage. Not applicable for virtual machine DB systems. Required for BMDBs.

data_storage_size_in_gb int

(Updatable) Size (in GB) of the initial data volume that will be created and attached to a virtual machine DB system. You can scale up storage after provisioning, as needed. Note that the total storage size attached will be more than the amount you specify to allow for REDO/RECO space and software volume. Required for VMDBs.

database_edition str

The Oracle Database Edition that applies to all the databases on the DB system. Exadata DB systems and 2-node RAC DB systems require ENTERPRISE_EDITION_EXTREME_PERFORMANCE.

db_home DbSystemDbHomeArgs

(Updatable) Details for creating a Database Home if you are creating a database by restoring from a database backup.

db_system_options DbSystemDbSystemOptionsArgs

The DB system options.

defined_tags Mapping[str, Any]

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

disk_redundancy str

The type of redundancy configured for the DB system. Normal is 2-way redundancy, recommended for test and development systems. High is 3-way redundancy, recommended for production systems.

display_name str

The user-friendly name for the DB system. The name does not have to be unique.

domain str

A domain name used for the DB system. If the Oracle-provided Internet and VCN Resolver is enabled for the specified subnet, the domain name for the subnet is used (do not provide one). Otherwise, provide a valid DNS domain name. Hyphens (-) are not permitted.

fault_domains Sequence[str]

A Fault Domain is a grouping of hardware and infrastructure within an availability domain. Fault Domains let you distribute your instances so that they are not on the same physical hardware within a single availability domain. A hardware failure or maintenance that affects one Fault Domain does not affect DB systems in other Fault Domains.

freeform_tags Mapping[str, Any]

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

hostname str

The hostname for the DB system. The hostname must begin with an alphabetic character, and can contain alphanumeric characters and hyphens (-). The maximum length of the hostname is 16 characters for bare metal and virtual machine DB systems, and 12 characters for Exadata DB systems.

iorm_config_caches DbSystemIormConfigCachArgs]

The IORM settings of the Exadata DB system.

kms_key_id str

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

kms_key_version_id str

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

last_maintenance_run_id str

The OCID of the last maintenance run.

last_patch_history_entry_id str

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

license_model str

(Updatable) The Oracle license model that applies to all the databases on the DB system. The default is LICENSE_INCLUDED.

lifecycle_details str

Additional information about the current lifecycle state.

listener_port int

The port number configured for the listener on the DB system.

maintenance_window_details DbSystemMaintenanceWindowDetailsArgs

(Updatable) The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

maintenance_windows DbSystemMaintenanceWindowArgs]

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

memory_size_in_gbs int

Memory allocated to the DB system, in gigabytes.

next_maintenance_run_id str

The OCID of the next maintenance run.

node_count int

The number of nodes to launch for a 2-node RAC virtual machine DB system. Specify either 1 or 2.

nsg_ids Sequence[str]

(Updatable) The list of OCIDs for the network security groups (NSGs) to which this resource belongs. Setting this to an empty list removes all resources from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.
point_in_time_data_disk_clone_timestamp str

The point in time for a cloned database system when the data disks were cloned from the source database system, as described in RFC 3339.

private_ip str

A private IP address of your choice. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. Supported for VM BM shape.

reco_storage_size_in_gb int

The RECO/REDO storage size, in gigabytes, that is currently allocated to the DB system. Applies only for virtual machine DB systems.

scan_dns_name str

The FQDN of the DNS record for the SCAN IP addresses that are associated with the DB system.

scan_dns_record_id str

The OCID of the DNS record for the SCAN IP addresses that are associated with the DB system.

scan_ip_ids Sequence[str]

The OCID of the Single Client Access Name (SCAN) IP addresses associated with the DB system. SCAN IP addresses are typically used for load balancing and are not assigned to any interface. Oracle Clusterware directs the requests to the appropriate nodes in the cluster.

shape str

(Updatable) The shape of the DB system. The shape determines resources allocated to the DB system.

  • For virtual machine shapes, the number of CPU cores and memory
  • For bare metal and Exadata shapes, the number of CPU cores, memory, and storage
source str

The source of the database: Use NONE for creating a new database. Use DB_BACKUP for creating a new database by restoring from a backup. Use DATABASE for creating a new database from an existing database, including archive redo log data. The default is NONE.

source_db_system_id str

The OCID of the DB system.

sparse_diskgroup bool

If true, Sparse Diskgroup is configured for Exadata dbsystem. If False, Sparse diskgroup is not configured. Only applied for Exadata shape.

ssh_public_keys Sequence[str]

(Updatable) The public key portion of the key pair to use for SSH access to the DB system. Multiple public keys can be provided. The length of the combined keys cannot exceed 40,000 characters.

state str

The current state of the DB system.

storage_volume_performance_mode str

The block storage volume performance level. Valid values are BALANCED and HIGH_PERFORMANCE. See Block Volume Performance for more information.

subnet_id str

The OCID of the subnet the DB system is associated with.

time_created str

The date and time the DB system was created.

time_zone str

The time zone to use for the DB system. For details, see DB System Time Zones.

version str

The Oracle Database version of the DB system.

vip_ids Sequence[str]

The OCID of the virtual IP (VIP) addresses associated with the DB system. The Cluster Ready Services (CRS) creates and maintains one VIP address for each node in the DB system to enable failover. If one node fails, the VIP is reassigned to another active node in the cluster.

zone_id str

The OCID of the zone the DB system is associated with.

availabilityDomain String

The availability domain where the DB system is located.

backupNetworkNsgIds List<String>

(Updatable) A list of the OCIDs of the network security groups (NSGs) that the backup network of this DB system belongs to. Setting this to an empty array after the list is created removes the resource from all NSGs. For more information about NSGs, see Security Rules. Applicable only to Exadata systems.

backupSubnetId String

The OCID of the backup network subnet the DB system is associated with. Applicable only to Exadata DB systems.

clusterName String

The cluster name for Exadata and 2-node RAC virtual machine DB systems. The cluster name must begin with an alphabetic character, and may contain hyphens (-). Underscores (_) are not permitted. The cluster name can be no longer than 11 characters and is not case sensitive.

compartmentId String

(Updatable) The OCID of the compartment the DB system belongs in.

cpuCoreCount Number

(Updatable) The number of CPU cores to enable for a bare metal or Exadata DB system or AMD VMDB Systems. The valid values depend on the specified shape:

  • BM.DenseIO1.36 - Specify a multiple of 2, from 2 to 36.
  • BM.DenseIO2.52 - Specify a multiple of 2, from 2 to 52.
  • Exadata.Base.48 - Specify a multiple of 2, from 0 to 48.
  • Exadata.Quarter1.84 - Specify a multiple of 2, from 22 to 84.
  • Exadata.Half1.168 - Specify a multiple of 4, from 44 to 168.
  • Exadata.Full1.336 - Specify a multiple of 8, from 88 to 336.
  • Exadata.Quarter2.92 - Specify a multiple of 2, from 0 to 92.
  • Exadata.Half2.184 - Specify a multiple of 4, from 0 to 184.
  • Exadata.Full2.368 - Specify a multiple of 8, from 0 to 368.
  • VM.Standard.E4.Flex - Specify any thing from 1 to 64.
dataCollectionOptions Property Map

(Updatable) Indicates user preferences for the various diagnostic collection options for the VM cluster/Cloud VM cluster/VMBM DBCS.

dataStoragePercentage Number

The percentage assigned to DATA storage (user data and database files). The remaining percentage is assigned to RECO storage (database redo logs, archive logs, and recovery manager backups). Specify 80 or 40. The default is 80 percent assigned to DATA storage. Not applicable for virtual machine DB systems. Required for BMDBs.

dataStorageSizeInGb Number

(Updatable) Size (in GB) of the initial data volume that will be created and attached to a virtual machine DB system. You can scale up storage after provisioning, as needed. Note that the total storage size attached will be more than the amount you specify to allow for REDO/RECO space and software volume. Required for VMDBs.

databaseEdition String

The Oracle Database Edition that applies to all the databases on the DB system. Exadata DB systems and 2-node RAC DB systems require ENTERPRISE_EDITION_EXTREME_PERFORMANCE.

dbHome Property Map

(Updatable) Details for creating a Database Home if you are creating a database by restoring from a database backup.

dbSystemOptions Property Map

The DB system options.

definedTags Map<Any>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

diskRedundancy String

The type of redundancy configured for the DB system. Normal is 2-way redundancy, recommended for test and development systems. High is 3-way redundancy, recommended for production systems.

displayName String

The user-friendly name for the DB system. The name does not have to be unique.

domain String

A domain name used for the DB system. If the Oracle-provided Internet and VCN Resolver is enabled for the specified subnet, the domain name for the subnet is used (do not provide one). Otherwise, provide a valid DNS domain name. Hyphens (-) are not permitted.

faultDomains List<String>

A Fault Domain is a grouping of hardware and infrastructure within an availability domain. Fault Domains let you distribute your instances so that they are not on the same physical hardware within a single availability domain. A hardware failure or maintenance that affects one Fault Domain does not affect DB systems in other Fault Domains.

freeformTags Map<Any>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

hostname String

The hostname for the DB system. The hostname must begin with an alphabetic character, and can contain alphanumeric characters and hyphens (-). The maximum length of the hostname is 16 characters for bare metal and virtual machine DB systems, and 12 characters for Exadata DB systems.

iormConfigCaches List<Property Map>

The IORM settings of the Exadata DB system.

kmsKeyId String

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

kmsKeyVersionId String

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

lastMaintenanceRunId String

The OCID of the last maintenance run.

lastPatchHistoryEntryId String

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

licenseModel String

(Updatable) The Oracle license model that applies to all the databases on the DB system. The default is LICENSE_INCLUDED.

lifecycleDetails String

Additional information about the current lifecycle state.

listenerPort Number

The port number configured for the listener on the DB system.

maintenanceWindowDetails Property Map

(Updatable) The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

maintenanceWindows List<Property Map>

The scheduling details for the quarterly maintenance window. Patching and system updates take place during the maintenance window.

memorySizeInGbs Number

Memory allocated to the DB system, in gigabytes.

nextMaintenanceRunId String

The OCID of the next maintenance run.

nodeCount Number

The number of nodes to launch for a 2-node RAC virtual machine DB system. Specify either 1 or 2.

nsgIds List<String>

(Updatable) The list of OCIDs for the network security groups (NSGs) to which this resource belongs. Setting this to an empty list removes all resources from all NSGs. For more information about NSGs, see Security Rules. NsgIds restrictions:

  • A network security group (NSG) is optional for Autonomous Databases with private access. The nsgIds list can be empty.
pointInTimeDataDiskCloneTimestamp String

The point in time for a cloned database system when the data disks were cloned from the source database system, as described in RFC 3339.

privateIp String

A private IP address of your choice. Must be an available IP address within the subnet's CIDR. If you don't specify a value, Oracle automatically assigns a private IP address from the subnet. Supported for VM BM shape.

recoStorageSizeInGb Number

The RECO/REDO storage size, in gigabytes, that is currently allocated to the DB system. Applies only for virtual machine DB systems.

scanDnsName String

The FQDN of the DNS record for the SCAN IP addresses that are associated with the DB system.

scanDnsRecordId String

The OCID of the DNS record for the SCAN IP addresses that are associated with the DB system.

scanIpIds List<String>

The OCID of the Single Client Access Name (SCAN) IP addresses associated with the DB system. SCAN IP addresses are typically used for load balancing and are not assigned to any interface. Oracle Clusterware directs the requests to the appropriate nodes in the cluster.

shape String

(Updatable) The shape of the DB system. The shape determines resources allocated to the DB system.

  • For virtual machine shapes, the number of CPU cores and memory
  • For bare metal and Exadata shapes, the number of CPU cores, memory, and storage
source String

The source of the database: Use NONE for creating a new database. Use DB_BACKUP for creating a new database by restoring from a backup. Use DATABASE for creating a new database from an existing database, including archive redo log data. The default is NONE.

sourceDbSystemId String

The OCID of the DB system.

sparseDiskgroup Boolean

If true, Sparse Diskgroup is configured for Exadata dbsystem. If False, Sparse diskgroup is not configured. Only applied for Exadata shape.

sshPublicKeys List<String>

(Updatable) The public key portion of the key pair to use for SSH access to the DB system. Multiple public keys can be provided. The length of the combined keys cannot exceed 40,000 characters.

state String

The current state of the DB system.

storageVolumePerformanceMode String

The block storage volume performance level. Valid values are BALANCED and HIGH_PERFORMANCE. See Block Volume Performance for more information.

subnetId String

The OCID of the subnet the DB system is associated with.

timeCreated String

The date and time the DB system was created.

timeZone String

The time zone to use for the DB system. For details, see DB System Time Zones.

version String

The Oracle Database version of the DB system.

vipIds List<String>

The OCID of the virtual IP (VIP) addresses associated with the DB system. The Cluster Ready Services (CRS) creates and maintains one VIP address for each node in the DB system to enable failover. If one node fails, the VIP is reassigned to another active node in the cluster.

zoneId String

The OCID of the zone the DB system is associated with.

Supporting Types

DbSystemDataCollectionOptions

IsDiagnosticsEventsEnabled bool

(Updatable) Indicates whether diagnostic collection is enabled for the VM cluster/Cloud VM cluster/VMBM DBCS. Enabling diagnostic collection allows you to receive Events service notifications for guest VM issues. Diagnostic collection also allows Oracle to provide enhanced service and proactive support for your Exadata system. You can enable diagnostic collection during VM cluster/Cloud VM cluster provisioning. You can also disable or enable it at any time using the UpdateVmCluster or updateCloudVmCluster API.

IsHealthMonitoringEnabled bool

(Updatable) Indicates whether health monitoring is enabled for the VM cluster / Cloud VM cluster / VMBM DBCS. Enabling health monitoring allows Oracle to collect diagnostic data and share it with its operations and support personnel. You may also receive notifications for some events. Collecting health diagnostics enables Oracle to provide proactive support and enhanced service for your system. Optionally enable health monitoring while provisioning a system. You can also disable or enable health monitoring anytime using the UpdateVmCluster, UpdateCloudVmCluster or updateDbsystem API.

IsIncidentLogsEnabled bool

(Updatable) Indicates whether incident logs and trace collection are enabled for the VM cluster / Cloud VM cluster / VMBM DBCS. Enabling incident logs collection allows Oracle to receive Events service notifications for guest VM issues, collect incident logs and traces, and use them to diagnose issues and resolve them. Optionally enable incident logs collection while provisioning a system. You can also disable or enable incident logs collection anytime using the UpdateVmCluster, updateCloudVmCluster or updateDbsystem API.

IsDiagnosticsEventsEnabled bool

(Updatable) Indicates whether diagnostic collection is enabled for the VM cluster/Cloud VM cluster/VMBM DBCS. Enabling diagnostic collection allows you to receive Events service notifications for guest VM issues. Diagnostic collection also allows Oracle to provide enhanced service and proactive support for your Exadata system. You can enable diagnostic collection during VM cluster/Cloud VM cluster provisioning. You can also disable or enable it at any time using the UpdateVmCluster or updateCloudVmCluster API.

IsHealthMonitoringEnabled bool

(Updatable) Indicates whether health monitoring is enabled for the VM cluster / Cloud VM cluster / VMBM DBCS. Enabling health monitoring allows Oracle to collect diagnostic data and share it with its operations and support personnel. You may also receive notifications for some events. Collecting health diagnostics enables Oracle to provide proactive support and enhanced service for your system. Optionally enable health monitoring while provisioning a system. You can also disable or enable health monitoring anytime using the UpdateVmCluster, UpdateCloudVmCluster or updateDbsystem API.

IsIncidentLogsEnabled bool

(Updatable) Indicates whether incident logs and trace collection are enabled for the VM cluster / Cloud VM cluster / VMBM DBCS. Enabling incident logs collection allows Oracle to receive Events service notifications for guest VM issues, collect incident logs and traces, and use them to diagnose issues and resolve them. Optionally enable incident logs collection while provisioning a system. You can also disable or enable incident logs collection anytime using the UpdateVmCluster, updateCloudVmCluster or updateDbsystem API.

isDiagnosticsEventsEnabled Boolean

(Updatable) Indicates whether diagnostic collection is enabled for the VM cluster/Cloud VM cluster/VMBM DBCS. Enabling diagnostic collection allows you to receive Events service notifications for guest VM issues. Diagnostic collection also allows Oracle to provide enhanced service and proactive support for your Exadata system. You can enable diagnostic collection during VM cluster/Cloud VM cluster provisioning. You can also disable or enable it at any time using the UpdateVmCluster or updateCloudVmCluster API.

isHealthMonitoringEnabled Boolean

(Updatable) Indicates whether health monitoring is enabled for the VM cluster / Cloud VM cluster / VMBM DBCS. Enabling health monitoring allows Oracle to collect diagnostic data and share it with its operations and support personnel. You may also receive notifications for some events. Collecting health diagnostics enables Oracle to provide proactive support and enhanced service for your system. Optionally enable health monitoring while provisioning a system. You can also disable or enable health monitoring anytime using the UpdateVmCluster, UpdateCloudVmCluster or updateDbsystem API.

isIncidentLogsEnabled Boolean

(Updatable) Indicates whether incident logs and trace collection are enabled for the VM cluster / Cloud VM cluster / VMBM DBCS. Enabling incident logs collection allows Oracle to receive Events service notifications for guest VM issues, collect incident logs and traces, and use them to diagnose issues and resolve them. Optionally enable incident logs collection while provisioning a system. You can also disable or enable incident logs collection anytime using the UpdateVmCluster, updateCloudVmCluster or updateDbsystem API.

isDiagnosticsEventsEnabled boolean

(Updatable) Indicates whether diagnostic collection is enabled for the VM cluster/Cloud VM cluster/VMBM DBCS. Enabling diagnostic collection allows you to receive Events service notifications for guest VM issues. Diagnostic collection also allows Oracle to provide enhanced service and proactive support for your Exadata system. You can enable diagnostic collection during VM cluster/Cloud VM cluster provisioning. You can also disable or enable it at any time using the UpdateVmCluster or updateCloudVmCluster API.

isHealthMonitoringEnabled boolean

(Updatable) Indicates whether health monitoring is enabled for the VM cluster / Cloud VM cluster / VMBM DBCS. Enabling health monitoring allows Oracle to collect diagnostic data and share it with its operations and support personnel. You may also receive notifications for some events. Collecting health diagnostics enables Oracle to provide proactive support and enhanced service for your system. Optionally enable health monitoring while provisioning a system. You can also disable or enable health monitoring anytime using the UpdateVmCluster, UpdateCloudVmCluster or updateDbsystem API.

isIncidentLogsEnabled boolean

(Updatable) Indicates whether incident logs and trace collection are enabled for the VM cluster / Cloud VM cluster / VMBM DBCS. Enabling incident logs collection allows Oracle to receive Events service notifications for guest VM issues, collect incident logs and traces, and use them to diagnose issues and resolve them. Optionally enable incident logs collection while provisioning a system. You can also disable or enable incident logs collection anytime using the UpdateVmCluster, updateCloudVmCluster or updateDbsystem API.

is_diagnostics_events_enabled bool

(Updatable) Indicates whether diagnostic collection is enabled for the VM cluster/Cloud VM cluster/VMBM DBCS. Enabling diagnostic collection allows you to receive Events service notifications for guest VM issues. Diagnostic collection also allows Oracle to provide enhanced service and proactive support for your Exadata system. You can enable diagnostic collection during VM cluster/Cloud VM cluster provisioning. You can also disable or enable it at any time using the UpdateVmCluster or updateCloudVmCluster API.

is_health_monitoring_enabled bool

(Updatable) Indicates whether health monitoring is enabled for the VM cluster / Cloud VM cluster / VMBM DBCS. Enabling health monitoring allows Oracle to collect diagnostic data and share it with its operations and support personnel. You may also receive notifications for some events. Collecting health diagnostics enables Oracle to provide proactive support and enhanced service for your system. Optionally enable health monitoring while provisioning a system. You can also disable or enable health monitoring anytime using the UpdateVmCluster, UpdateCloudVmCluster or updateDbsystem API.

is_incident_logs_enabled bool

(Updatable) Indicates whether incident logs and trace collection are enabled for the VM cluster / Cloud VM cluster / VMBM DBCS. Enabling incident logs collection allows Oracle to receive Events service notifications for guest VM issues, collect incident logs and traces, and use them to diagnose issues and resolve them. Optionally enable incident logs collection while provisioning a system. You can also disable or enable incident logs collection anytime using the UpdateVmCluster, updateCloudVmCluster or updateDbsystem API.

isDiagnosticsEventsEnabled Boolean

(Updatable) Indicates whether diagnostic collection is enabled for the VM cluster/Cloud VM cluster/VMBM DBCS. Enabling diagnostic collection allows you to receive Events service notifications for guest VM issues. Diagnostic collection also allows Oracle to provide enhanced service and proactive support for your Exadata system. You can enable diagnostic collection during VM cluster/Cloud VM cluster provisioning. You can also disable or enable it at any time using the UpdateVmCluster or updateCloudVmCluster API.

isHealthMonitoringEnabled Boolean

(Updatable) Indicates whether health monitoring is enabled for the VM cluster / Cloud VM cluster / VMBM DBCS. Enabling health monitoring allows Oracle to collect diagnostic data and share it with its operations and support personnel. You may also receive notifications for some events. Collecting health diagnostics enables Oracle to provide proactive support and enhanced service for your system. Optionally enable health monitoring while provisioning a system. You can also disable or enable health monitoring anytime using the UpdateVmCluster, UpdateCloudVmCluster or updateDbsystem API.

isIncidentLogsEnabled Boolean

(Updatable) Indicates whether incident logs and trace collection are enabled for the VM cluster / Cloud VM cluster / VMBM DBCS. Enabling incident logs collection allows Oracle to receive Events service notifications for guest VM issues, collect incident logs and traces, and use them to diagnose issues and resolve them. Optionally enable incident logs collection while provisioning a system. You can also disable or enable incident logs collection anytime using the UpdateVmCluster, updateCloudVmCluster or updateDbsystem API.

DbSystemDbHome

Database DbSystemDbHomeDatabase

(Updatable) Details for creating a database by restoring from a source database system.

CreateAsync bool
DatabaseSoftwareImageId string

The database software image OCID of the image to be used to restore a database.

DbHomeLocation string
DbVersion string

A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.

DefinedTags Dictionary<string, object>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

DisplayName string

The user-friendly name for the DB system. The name does not have to be unique.

FreeformTags Dictionary<string, object>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

Id string

The OCID of the backup destination.

LastPatchHistoryEntryId string

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

LifecycleDetails string

Additional information about the current lifecycle state.

State string

The current state of the DB system.

TimeCreated string

The date and time the DB system was created.

Database DbSystemDbHomeDatabase

(Updatable) Details for creating a database by restoring from a source database system.

CreateAsync bool
DatabaseSoftwareImageId string

The database software image OCID of the image to be used to restore a database.

DbHomeLocation string
DbVersion string

A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.

DefinedTags map[string]interface{}

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

DisplayName string

The user-friendly name for the DB system. The name does not have to be unique.

FreeformTags map[string]interface{}

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

Id string

The OCID of the backup destination.

LastPatchHistoryEntryId string

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

LifecycleDetails string

Additional information about the current lifecycle state.

State string

The current state of the DB system.

TimeCreated string

The date and time the DB system was created.

database DbSystemDbHome

(Updatable) Details for creating a database by restoring from a source database system.

createAsync Boolean
databaseSoftwareImageId String

The database software image OCID of the image to be used to restore a database.

dbHomeLocation String
dbVersion String

A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.

definedTags Map<String,Object>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

displayName String

The user-friendly name for the DB system. The name does not have to be unique.

freeformTags Map<String,Object>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

id String

The OCID of the backup destination.

lastPatchHistoryEntryId String

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

lifecycleDetails String

Additional information about the current lifecycle state.

state String

The current state of the DB system.

timeCreated String

The date and time the DB system was created.

database DbSystemDbHomeDatabase

(Updatable) Details for creating a database by restoring from a source database system.

createAsync boolean
databaseSoftwareImageId string

The database software image OCID of the image to be used to restore a database.

dbHomeLocation string
dbVersion string

A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.

definedTags {[key: string]: any}

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

displayName string

The user-friendly name for the DB system. The name does not have to be unique.

freeformTags {[key: string]: any}

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

id string

The OCID of the backup destination.

lastPatchHistoryEntryId string

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

lifecycleDetails string

Additional information about the current lifecycle state.

state string

The current state of the DB system.

timeCreated string

The date and time the DB system was created.

database DbSystemDbHomeDatabase

(Updatable) Details for creating a database by restoring from a source database system.

create_async bool
database_software_image_id str

The database software image OCID of the image to be used to restore a database.

db_home_location str
db_version str

A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.

defined_tags Mapping[str, Any]

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

display_name str

The user-friendly name for the DB system. The name does not have to be unique.

freeform_tags Mapping[str, Any]

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

id str

The OCID of the backup destination.

last_patch_history_entry_id str

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

lifecycle_details str

Additional information about the current lifecycle state.

state str

The current state of the DB system.

time_created str

The date and time the DB system was created.

database Property Map

(Updatable) Details for creating a database by restoring from a source database system.

createAsync Boolean
databaseSoftwareImageId String

The database software image OCID of the image to be used to restore a database.

dbHomeLocation String
dbVersion String

A valid Oracle Database version. To get a list of supported versions, use the ListDbVersions operation.

definedTags Map<Any>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

displayName String

The user-friendly name for the DB system. The name does not have to be unique.

freeformTags Map<Any>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

id String

The OCID of the backup destination.

lastPatchHistoryEntryId String

The OCID of the last patch history. This value is updated as soon as a patch operation starts.

lifecycleDetails String

Additional information about the current lifecycle state.

state String

The current state of the DB system.

timeCreated String

The date and time the DB system was created.

DbSystemDbHomeDatabase

AdminPassword string

A strong password for SYS, SYSTEM, PDB Admin and TDE Wallet. The password must be at least nine characters and contain at least two uppercase, two lowercase, two numbers, and two special characters. The special characters must be _, #, or -.

BackupId string

The backup OCID.

BackupTdePassword string

The password to open the TDE wallet.

CharacterSet string

The character set for the database. The default is AL32UTF8. Allowed values are:

ConnectionStrings List<DbSystemDbHomeDatabaseConnectionString>
DatabaseId string

The database OCID.

DatabaseSoftwareImageId string

The database software image OCID of the image to be used to restore a database.

DbBackupConfig DbSystemDbHomeDatabaseDbBackupConfig

(Updatable) Backup Options To use any of the API operations, you must be authorized in an IAM policy. If you're not authorized, talk to an administrator. If you're an administrator who needs to write policies to give users access, see Getting Started with Policies.

DbDomain string

The database domain. In a distributed database system, DB_DOMAIN specifies the logical location of the database within the network structure.

DbName string

The display name of the database to be created from the backup. It must begin with an alphabetic character and can contain a maximum of eight alphanumeric characters. Special characters are not permitted.

DbUniqueName string
DbWorkload string

The database workload type.

DefinedTags Dictionary<string, object>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

FreeformTags Dictionary<string, object>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

Id string

The OCID of the backup destination.

KmsKeyId string

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

KmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

LifecycleDetails string

Additional information about the current lifecycle state.

NcharacterSet string

The national character set for the database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

PdbName string

The name of the pluggable database. The name must begin with an alphabetic character and can contain a maximum of thirty alphanumeric characters. Special characters are not permitted. Pluggable database should not be same as database name.

State string

The current state of the DB system.

TdeWalletPassword string

The optional password to open the TDE wallet. The password must be at least nine characters and contain at least two uppercase, two lowercase, two numeric, and two special characters. The special characters must be _, #, or -.

TimeCreated string

The date and time the DB system was created.

TimeStampForPointInTimeRecovery string

The point in time of the original database from which the new database is created. If not specifed, the latest backup is used to create the database.

VaultId string

The OCID of the Oracle Cloud Infrastructure vault.

AdminPassword string

A strong password for SYS, SYSTEM, PDB Admin and TDE Wallet. The password must be at least nine characters and contain at least two uppercase, two lowercase, two numbers, and two special characters. The special characters must be _, #, or -.

BackupId string

The backup OCID.

BackupTdePassword string

The password to open the TDE wallet.

CharacterSet string

The character set for the database. The default is AL32UTF8. Allowed values are:

ConnectionStrings []DbSystemDbHomeDatabaseConnectionString
DatabaseId string

The database OCID.

DatabaseSoftwareImageId string

The database software image OCID of the image to be used to restore a database.

DbBackupConfig DbSystemDbHomeDatabaseDbBackupConfig

(Updatable) Backup Options To use any of the API operations, you must be authorized in an IAM policy. If you're not authorized, talk to an administrator. If you're an administrator who needs to write policies to give users access, see Getting Started with Policies.

DbDomain string

The database domain. In a distributed database system, DB_DOMAIN specifies the logical location of the database within the network structure.

DbName string

The display name of the database to be created from the backup. It must begin with an alphabetic character and can contain a maximum of eight alphanumeric characters. Special characters are not permitted.

DbUniqueName string
DbWorkload string

The database workload type.

DefinedTags map[string]interface{}

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

FreeformTags map[string]interface{}

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

Id string

The OCID of the backup destination.

KmsKeyId string

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

KmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

LifecycleDetails string

Additional information about the current lifecycle state.

NcharacterSet string

The national character set for the database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

PdbName string

The name of the pluggable database. The name must begin with an alphabetic character and can contain a maximum of thirty alphanumeric characters. Special characters are not permitted. Pluggable database should not be same as database name.

State string

The current state of the DB system.

TdeWalletPassword string

The optional password to open the TDE wallet. The password must be at least nine characters and contain at least two uppercase, two lowercase, two numeric, and two special characters. The special characters must be _, #, or -.

TimeCreated string

The date and time the DB system was created.

TimeStampForPointInTimeRecovery string

The point in time of the original database from which the new database is created. If not specifed, the latest backup is used to create the database.

VaultId string

The OCID of the Oracle Cloud Infrastructure vault.

adminPassword String

A strong password for SYS, SYSTEM, PDB Admin and TDE Wallet. The password must be at least nine characters and contain at least two uppercase, two lowercase, two numbers, and two special characters. The special characters must be _, #, or -.

backupId String

The backup OCID.

backupTdePassword String

The password to open the TDE wallet.

characterSet String

The character set for the database. The default is AL32UTF8. Allowed values are:

connectionStrings List<DbSystemDbHomeConnectionString>
databaseId String

The database OCID.

databaseSoftwareImageId String

The database software image OCID of the image to be used to restore a database.

dbBackupConfig DbSystemDbHomeDbBackupConfig

(Updatable) Backup Options To use any of the API operations, you must be authorized in an IAM policy. If you're not authorized, talk to an administrator. If you're an administrator who needs to write policies to give users access, see Getting Started with Policies.

dbDomain String

The database domain. In a distributed database system, DB_DOMAIN specifies the logical location of the database within the network structure.

dbName String

The display name of the database to be created from the backup. It must begin with an alphabetic character and can contain a maximum of eight alphanumeric characters. Special characters are not permitted.

dbUniqueName String
dbWorkload String

The database workload type.

definedTags Map<String,Object>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

freeformTags Map<String,Object>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

id String

The OCID of the backup destination.

kmsKeyId String

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

kmsKeyVersionId String

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

lifecycleDetails String

Additional information about the current lifecycle state.

ncharacterSet String

The national character set for the database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

pdbName String

The name of the pluggable database. The name must begin with an alphabetic character and can contain a maximum of thirty alphanumeric characters. Special characters are not permitted. Pluggable database should not be same as database name.

state String

The current state of the DB system.

tdeWalletPassword String

The optional password to open the TDE wallet. The password must be at least nine characters and contain at least two uppercase, two lowercase, two numeric, and two special characters. The special characters must be _, #, or -.

timeCreated String

The date and time the DB system was created.

timeStampForPointInTimeRecovery String

The point in time of the original database from which the new database is created. If not specifed, the latest backup is used to create the database.

vaultId String

The OCID of the Oracle Cloud Infrastructure vault.

adminPassword string

A strong password for SYS, SYSTEM, PDB Admin and TDE Wallet. The password must be at least nine characters and contain at least two uppercase, two lowercase, two numbers, and two special characters. The special characters must be _, #, or -.

backupId string

The backup OCID.

backupTdePassword string

The password to open the TDE wallet.

characterSet string

The character set for the database. The default is AL32UTF8. Allowed values are:

connectionStrings DbSystemDbHomeDatabaseConnectionString[]
databaseId string

The database OCID.

databaseSoftwareImageId string

The database software image OCID of the image to be used to restore a database.

dbBackupConfig DbSystemDbHomeDatabaseDbBackupConfig

(Updatable) Backup Options To use any of the API operations, you must be authorized in an IAM policy. If you're not authorized, talk to an administrator. If you're an administrator who needs to write policies to give users access, see Getting Started with Policies.

dbDomain string

The database domain. In a distributed database system, DB_DOMAIN specifies the logical location of the database within the network structure.

dbName string

The display name of the database to be created from the backup. It must begin with an alphabetic character and can contain a maximum of eight alphanumeric characters. Special characters are not permitted.

dbUniqueName string
dbWorkload string

The database workload type.

definedTags {[key: string]: any}

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

freeformTags {[key: string]: any}

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

id string

The OCID of the backup destination.

kmsKeyId string

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

kmsKeyVersionId string

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

lifecycleDetails string

Additional information about the current lifecycle state.

ncharacterSet string

The national character set for the database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

pdbName string

The name of the pluggable database. The name must begin with an alphabetic character and can contain a maximum of thirty alphanumeric characters. Special characters are not permitted. Pluggable database should not be same as database name.

state string

The current state of the DB system.

tdeWalletPassword string

The optional password to open the TDE wallet. The password must be at least nine characters and contain at least two uppercase, two lowercase, two numeric, and two special characters. The special characters must be _, #, or -.

timeCreated string

The date and time the DB system was created.

timeStampForPointInTimeRecovery string

The point in time of the original database from which the new database is created. If not specifed, the latest backup is used to create the database.

vaultId string

The OCID of the Oracle Cloud Infrastructure vault.

admin_password str

A strong password for SYS, SYSTEM, PDB Admin and TDE Wallet. The password must be at least nine characters and contain at least two uppercase, two lowercase, two numbers, and two special characters. The special characters must be _, #, or -.

backup_id str

The backup OCID.

backup_tde_password str

The password to open the TDE wallet.

character_set str

The character set for the database. The default is AL32UTF8. Allowed values are:

connection_strings DbSystemDbHomeDatabaseConnectionString]
database_id str

The database OCID.

database_software_image_id str

The database software image OCID of the image to be used to restore a database.

db_backup_config DbSystemDbHomeDatabaseDbBackupConfig

(Updatable) Backup Options To use any of the API operations, you must be authorized in an IAM policy. If you're not authorized, talk to an administrator. If you're an administrator who needs to write policies to give users access, see Getting Started with Policies.

db_domain str

The database domain. In a distributed database system, DB_DOMAIN specifies the logical location of the database within the network structure.

db_name str

The display name of the database to be created from the backup. It must begin with an alphabetic character and can contain a maximum of eight alphanumeric characters. Special characters are not permitted.

db_unique_name str
db_workload str

The database workload type.

defined_tags Mapping[str, Any]

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

freeform_tags Mapping[str, Any]

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

id str

The OCID of the backup destination.

kms_key_id str

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

kms_key_version_id str

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

lifecycle_details str

Additional information about the current lifecycle state.

ncharacter_set str

The national character set for the database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

pdb_name str

The name of the pluggable database. The name must begin with an alphabetic character and can contain a maximum of thirty alphanumeric characters. Special characters are not permitted. Pluggable database should not be same as database name.

state str

The current state of the DB system.

tde_wallet_password str

The optional password to open the TDE wallet. The password must be at least nine characters and contain at least two uppercase, two lowercase, two numeric, and two special characters. The special characters must be _, #, or -.

time_created str

The date and time the DB system was created.

time_stamp_for_point_in_time_recovery str

The point in time of the original database from which the new database is created. If not specifed, the latest backup is used to create the database.

vault_id str

The OCID of the Oracle Cloud Infrastructure vault.

adminPassword String

A strong password for SYS, SYSTEM, PDB Admin and TDE Wallet. The password must be at least nine characters and contain at least two uppercase, two lowercase, two numbers, and two special characters. The special characters must be _, #, or -.

backupId String

The backup OCID.

backupTdePassword String

The password to open the TDE wallet.

characterSet String

The character set for the database. The default is AL32UTF8. Allowed values are:

connectionStrings List<Property Map>
databaseId String

The database OCID.

databaseSoftwareImageId String

The database software image OCID of the image to be used to restore a database.

dbBackupConfig Property Map

(Updatable) Backup Options To use any of the API operations, you must be authorized in an IAM policy. If you're not authorized, talk to an administrator. If you're an administrator who needs to write policies to give users access, see Getting Started with Policies.

dbDomain String

The database domain. In a distributed database system, DB_DOMAIN specifies the logical location of the database within the network structure.

dbName String

The display name of the database to be created from the backup. It must begin with an alphabetic character and can contain a maximum of eight alphanumeric characters. Special characters are not permitted.

dbUniqueName String
dbWorkload String

The database workload type.

definedTags Map<Any>

(Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

freeformTags Map<Any>

(Updatable) Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags. Example: {"Department": "Finance"}

id String

The OCID of the backup destination.

kmsKeyId String

The OCID of the key container that is used as the master encryption key in database transparent data encryption (TDE) operations.

kmsKeyVersionId String

The OCID of the key container version that is used in database transparent data encryption (TDE) operations KMS Key can have multiple key versions. If none is specified, the current key version (latest) of the Key Id is used for the operation.

lifecycleDetails String

Additional information about the current lifecycle state.

ncharacterSet String

The national character set for the database. The default is AL16UTF16. Allowed values are: AL16UTF16 or UTF8.

pdbName String

The name of the pluggable database. The name must begin with an alphabetic character and can contain a maximum of thirty alphanumeric characters. Special characters are not permitted. Pluggable database should not be same as database name.

state String

The current state of the DB system.

tdeWalletPassword String

The optional password to open the TDE wallet. The password must be at least nine characters and contain at least two uppercase, two lowercase, two numeric, and two special characters. The special characters must be _, #, or -.

timeCreated String

The date and time the DB system was created.

timeStampForPointInTimeRecovery String

The point in time of the original database from which the new database is created. If not specifed, the latest backup is used to create the database.

vaultId String

The OCID of the Oracle Cloud Infrastructure vault.

DbSystemDbHomeDatabaseConnectionString

AllConnectionStrings Dictionary<string, object>
CdbDefault string
CdbIpDefault string
AllConnectionStrings map[string]interface{}
CdbDefault string
CdbIpDefault string
allConnectionStrings Map<String,Object>
cdbDefault String
cdbIpDefault String
allConnectionStrings {[key: string]: any}
cdbDefault string
cdbIpDefault string

DbSystemDbHomeDatabaseDbBackupConfig

AutoBackupEnabled bool

(Updatable) If set to true, configures automatic backups. If you previously used RMAN or dbcli to configure backups and then you switch to using the Console or the API for backups, a new backup configuration is created and associated with your database. This means that you can no longer rely on your previously configured unmanaged backups to work.

AutoBackupWindow string

(Updatable) Time window selected for initiating automatic backup for the database system. There are twelve available two-hour time windows. If no option is selected, a start time between 12:00 AM to 7:00 AM in the region of the database is automatically chosen. For example, if the user selects SLOT_TWO from the enum list, the automatic backup job will start in between 2:00 AM (inclusive) to 4:00 AM (exclusive). Example: SLOT_TWO

BackupDestinationDetails List<DbSystemDbHomeDatabaseDbBackupConfigBackupDestinationDetail>

(Updatable) Backup destination details.

RecoveryWindowInDays int

(Updatable) Number of days between the current and the earliest point of recoverability covered by automatic backups. This value applies to automatic backups only. After a new automatic backup has been created, Oracle removes old automatic backups that are created before the window. When the value is updated, it is applied to all existing automatic backups.

AutoBackupEnabled bool

(Updatable) If set to true, configures automatic backups. If you previously used RMAN or dbcli to configure backups and then you switch to using the Console or the API for backups, a new backup configuration is created and associated with your database. This means that you can no longer rely on your previously configured unmanaged backups to work.

AutoBackupWindow string

(Updatable) Time window selected for initiating automatic backup for the database system. There are twelve available two-hour time windows. If no option is selected, a start time between 12:00 AM to 7:00 AM in the region of the database is automatically chosen. For example, if the user selects SLOT_TWO from the enum list, the automatic backup job will start in between 2:00 AM (inclusive) to 4:00 AM (exclusive). Example: SLOT_TWO

BackupDestinationDetails []DbSystemDbHomeDatabaseDbBackupConfigBackupDestinationDetail

(Updatable) Backup destination details.

RecoveryWindowInDays int

(Updatable) Number of days between the current and the earliest point of recoverability covered by automatic backups. This value applies to automatic backups only. After a new automatic backup has been created, Oracle removes old automatic backups that are created before the window. When the value is updated, it is applied to all existing automatic backups.

autoBackupEnabled Boolean

(Updatable) If set to true, configures automatic backups. If you previously used RMAN or dbcli to configure backups and then you switch to using the Console or the API for backups, a new backup configuration is created and associated with your database. This means that you can no longer rely on your previously configured unmanaged backups to work.

autoBackupWindow String

(Updatable) Time window selected for initiating automatic backup for the database system. There are twelve available two-hour time windows. If no option is selected, a start time between 12:00 AM to 7:00 AM in the region of the database is automatically chosen. For example, if the user selects SLOT_TWO from the enum list, the automatic backup job will start in between 2:00 AM (inclusive) to 4:00 AM (exclusive). Example: SLOT_TWO

backupDestinationDetails List<DbSystemDbHomeDbBackupConfigBackupDestinationDetail>

(Updatable) Backup destination details.

recoveryWindowInDays Integer

(Updatable) Number of days between the current and the earliest point of recoverability covered by automatic backups. This value applies to automatic backups only. After a new automatic backup has been created, Oracle removes old automatic backups that are created before the window. When the value is updated, it is applied to all existing automatic backups.

autoBackupEnabled boolean

(Updatable) If set to true, configures automatic backups. If you previously used RMAN or dbcli to configure backups and then you switch to using the Console or the API for backups, a new backup configuration is created and associated with your database. This means that you can no longer rely on your previously configured unmanaged backups to work.

autoBackupWindow string

(Updatable) Time window selected for initiating automatic backup for the database system. There are twelve available two-hour time windows. If no option is selected, a start time between 12:00 AM to 7:00 AM in the region of the database is automatically chosen. For example, if the user selects SLOT_TWO from the enum list, the automatic backup job will start in between 2:00 AM (inclusive) to 4:00 AM (exclusive). Example: SLOT_TWO

backupDestinationDetails DbSystemDbHomeDatabaseDbBackupConfigBackupDestinationDetail[]

(Updatable) Backup destination details.

recoveryWindowInDays number

(Updatable) Number of days between the current and the earliest point of recoverability covered by automatic backups. This value applies to automatic backups only. After a new automatic backup has been created, Oracle removes old automatic backups that are created before the window. When the value is updated, it is applied to all existing automatic backups.

auto_backup_enabled bool

(Updatable) If set to true, configures automatic backups. If you previously used RMAN or dbcli to configure backups and then you switch to using the Console or the API for backups, a new backup configuration is created and associated with your database. This means that you can no longer rely on your previously configured unmanaged backups to work.

auto_backup_window str

(Updatable) Time window selected for initiating automatic backup for the database system. There are twelve available two-hour time windows. If no option is selected, a start time between 12:00 AM to 7:00 AM in the region of the database is automatically chosen. For example, if the user selects SLOT_TWO from the enum list, the automatic backup job will start in between 2:00 AM (inclusive) to 4:00 AM (exclusive). Example: SLOT_TWO

backup_destination_details DbSystemDbHomeDatabaseDbBackupConfigBackupDestinationDetail]

(Updatable) Backup destination details.

recovery_window_in_days int

(Updatable) Number of days between the current and the earliest point of recoverability covered by automatic backups. This value applies to automatic backups only. After a new automatic backup has been created, Oracle removes old automatic backups that are created before the window. When the value is updated, it is applied to all existing automatic backups.

autoBackupEnabled Boolean

(Updatable) If set to true, configures automatic backups. If you previously used RMAN or dbcli to configure backups and then you switch to using the Console or the API for backups, a new backup configuration is created and associated with your database. This means that you can no longer rely on your previously configured unmanaged backups to work.

autoBackupWindow String

(Updatable) Time window selected for initiating automatic backup for the database system. There are twelve available two-hour time windows. If no option is selected, a start time between 12:00 AM to 7:00 AM in the region of the database is automatically chosen. For example, if the user selects SLOT_TWO from the enum list, the automatic backup job will start in between 2:00 AM (inclusive) to 4:00 AM (exclusive). Example: SLOT_TWO

backupDestinationDetails List<Property Map>

(Updatable) Backup destination details.

recoveryWindowInDays Number

(Updatable) Number of days between the current and the earliest point of recoverability covered by automatic backups. This value applies to automatic backups only. After a new automatic backup has been created, Oracle removes old automatic backups that are created before the window. When the value is updated, it is applied to all existing automatic backups.

DbSystemDbHomeDatabaseDbBackupConfigBackupDestinationDetail

Id string

The OCID of the backup destination.

Type string

Type of the database backup destination.

Id string

The OCID of the backup destination.

Type string

Type of the database backup destination.

id String

The OCID of the backup destination.

type String

Type of the database backup destination.

id string

The OCID of the backup destination.

type string

Type of the database backup destination.

id str

The OCID of the backup destination.

type str

Type of the database backup destination.

id String

The OCID of the backup destination.

type String

Type of the database backup destination.

DbSystemDbSystemOptions

StorageManagement string

The storage option used in DB system. ASM - Automatic storage management LVM - Logical Volume management

StorageManagement string

The storage option used in DB system. ASM - Automatic storage management LVM - Logical Volume management

storageManagement String

The storage option used in DB system. ASM - Automatic storage management LVM - Logical Volume management

storageManagement string

The storage option used in DB system. ASM - Automatic storage management LVM - Logical Volume management

storage_management str

The storage option used in DB system. ASM - Automatic storage management LVM - Logical Volume management

storageManagement String

The storage option used in DB system. ASM - Automatic storage management LVM - Logical Volume management

DbSystemIormConfigCach

DbPlans List<DbSystemIormConfigCachDbPlan>

An array of IORM settings for all the database in the Exadata DB system.

DbSystemId string
LifecycleDetails string

Additional information about the current lifecycle state.

Objective string

The current value for the IORM objective. The default is AUTO.

State string

The current state of the DB system.

DbPlans []DbSystemIormConfigCachDbPlan

An array of IORM settings for all the database in the Exadata DB system.

DbSystemId string
LifecycleDetails string

Additional information about the current lifecycle state.

Objective string

The current value for the IORM objective. The default is AUTO.

State string

The current state of the DB system.

dbPlans List<DbSystemIormConfigCachDbPlan>

An array of IORM settings for all the database in the Exadata DB system.

dbSystemId String
lifecycleDetails String

Additional information about the current lifecycle state.

objective String

The current value for the IORM objective. The default is AUTO.

state String

The current state of the DB system.

dbPlans DbSystemIormConfigCachDbPlan[]

An array of IORM settings for all the database in the Exadata DB system.

dbSystemId string
lifecycleDetails string

Additional information about the current lifecycle state.

objective string

The current value for the IORM objective. The default is AUTO.

state string

The current state of the DB system.

db_plans DbSystemIormConfigCachDbPlan]

An array of IORM settings for all the database in the Exadata DB system.

db_system_id str
lifecycle_details str

Additional information about the current lifecycle state.

objective str

The current value for the IORM objective. The default is AUTO.

state str

The current state of the DB system.

dbPlans List<Property Map>

An array of IORM settings for all the database in the Exadata DB system.

dbSystemId String
lifecycleDetails String

Additional information about the current lifecycle state.

objective String

The current value for the IORM objective. The default is AUTO.

state String

The current state of the DB system.

DbSystemIormConfigCachDbPlan

DbName string

The display name of the database to be created from the backup. It must begin with an alphabetic character and can contain a maximum of eight alphanumeric characters. Special characters are not permitted.

FlashCacheLimit string

The flash cache limit for this database. This value is internally configured based on the share value assigned to the database.

Share int

The relative priority of this database.

DbName string

The display name of the database to be created from the backup. It must begin with an alphabetic character and can contain a maximum of eight alphanumeric characters. Special characters are not permitted.

FlashCacheLimit string

The flash cache limit for this database. This value is internally configured based on the share value assigned to the database.

Share int

The relative priority of this database.

dbName String

The display name of the database to be created from the backup. It must begin with an alphabetic character and can contain a maximum of eight alphanumeric characters. Special characters are not permitted.

flashCacheLimit String

The flash cache limit for this database. This value is internally configured based on the share value assigned to the database.

share Integer

The relative priority of this database.

dbName string

The display name of the database to be created from the backup. It must begin with an alphabetic character and can contain a maximum of eight alphanumeric characters. Special characters are not permitted.

flashCacheLimit string

The flash cache limit for this database. This value is internally configured based on the share value assigned to the database.

share number

The relative priority of this database.

db_name str

The display name of the database to be created from the backup. It must begin with an alphabetic character and can contain a maximum of eight alphanumeric characters. Special characters are not permitted.

flash_cache_limit str

The flash cache limit for this database. This value is internally configured based on the share value assigned to the database.

share int

The relative priority of this database.

dbName String

The display name of the database to be created from the backup. It must begin with an alphabetic character and can contain a maximum of eight alphanumeric characters. Special characters are not permitted.

flashCacheLimit String

The flash cache limit for this database. This value is internally configured based on the share value assigned to the database.

share Number

The relative priority of this database.

DbSystemMaintenanceWindow

CustomActionTimeoutInMins int

(Updatable) Determines the amount of time the system will wait before the start of each database server patching operation. Custom action timeout is in minutes and valid value is between 15 to 120 (inclusive).

DaysOfWeeks List<DbSystemMaintenanceWindowDaysOfWeek>

(Updatable) Days during the week when maintenance should be performed.

HoursOfDays List<int>

(Updatable) The window of hours during the day when maintenance should be performed. The window is a 4 hour slot. Valid values are

  • 0 - represents time slot 0:00 - 3:59 UTC - 4 - represents time slot 4:00 - 7:59 UTC - 8 - represents time slot 8:00 - 11:59 UTC - 12 - represents time slot 12:00 - 15:59 UTC - 16 - represents time slot 16:00 - 19:59 UTC - 20 - represents time slot 20:00 - 23:59 UTC
IsCustomActionTimeoutEnabled bool

(Updatable) If true, enables the configuration of a custom action timeout (waiting period) between database server patching operations.

IsMonthlyPatchingEnabled bool

(Updatable) If true, enables the monthly patching option.

LeadTimeInWeeks int

(Updatable) Lead time window allows user to set a lead time to prepare for a down time. The lead time is in weeks and valid value is between 1 to 4.

Months List<DbSystemMaintenanceWindowMonth>

(Updatable) Months during the year when maintenance should be performed.

PatchingMode string

(Updatable) Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.

Preference string

(Updatable) The maintenance window scheduling preference.

WeeksOfMonths List<int>

(Updatable) Weeks during the month when maintenance should be performed. Weeks start on the 1st, 8th, 15th, and 22nd days of the month, and have a duration of 7 days. Weeks start and end based on calendar dates, not days of the week. For example, to allow maintenance during the 2nd week of the month (from the 8th day to the 14th day of the month), use the value 2. Maintenance cannot be scheduled for the fifth week of months that contain more than 28 days. Note that this parameter works in conjunction with the daysOfWeek and hoursOfDay parameters to allow you to specify specific days of the week and hours that maintenance will be performed.

CustomActionTimeoutInMins int

(Updatable) Determines the amount of time the system will wait before the start of each database server patching operation. Custom action timeout is in minutes and valid value is between 15 to 120 (inclusive).

DaysOfWeeks []DbSystemMaintenanceWindowDaysOfWeek

(Updatable) Days during the week when maintenance should be performed.

HoursOfDays []int

(Updatable) The window of hours during the day when maintenance should be performed. The window is a 4 hour slot. Valid values are

  • 0 - represents time slot 0:00 - 3:59 UTC - 4 - represents time slot 4:00 - 7:59 UTC - 8 - represents time slot 8:00 - 11:59 UTC - 12 - represents time slot 12:00 - 15:59 UTC - 16 - represents time slot 16:00 - 19:59 UTC - 20 - represents time slot 20:00 - 23:59 UTC
IsCustomActionTimeoutEnabled bool

(Updatable) If true, enables the configuration of a custom action timeout (waiting period) between database server patching operations.

IsMonthlyPatchingEnabled bool

(Updatable) If true, enables the monthly patching option.

LeadTimeInWeeks int

(Updatable) Lead time window allows user to set a lead time to prepare for a down time. The lead time is in weeks and valid value is between 1 to 4.

Months []DbSystemMaintenanceWindowMonth

(Updatable) Months during the year when maintenance should be performed.

PatchingMode string

(Updatable) Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.

Preference string

(Updatable) The maintenance window scheduling preference.

WeeksOfMonths []int

(Updatable) Weeks during the month when maintenance should be performed. Weeks start on the 1st, 8th, 15th, and 22nd days of the month, and have a duration of 7 days. Weeks start and end based on calendar dates, not days of the week. For example, to allow maintenance during the 2nd week of the month (from the 8th day to the 14th day of the month), use the value 2. Maintenance cannot be scheduled for the fifth week of months that contain more than 28 days. Note that this parameter works in conjunction with the daysOfWeek and hoursOfDay parameters to allow you to specify specific days of the week and hours that maintenance will be performed.

customActionTimeoutInMins Integer

(Updatable) Determines the amount of time the system will wait before the start of each database server patching operation. Custom action timeout is in minutes and valid value is between 15 to 120 (inclusive).

daysOfWeeks List<DbSystemMaintenanceWindowDaysOfWeek>

(Updatable) Days during the week when maintenance should be performed.

hoursOfDays List<Integer>

(Updatable) The window of hours during the day when maintenance should be performed. The window is a 4 hour slot. Valid values are

  • 0 - represents time slot 0:00 - 3:59 UTC - 4 - represents time slot 4:00 - 7:59 UTC - 8 - represents time slot 8:00 - 11:59 UTC - 12 - represents time slot 12:00 - 15:59 UTC - 16 - represents time slot 16:00 - 19:59 UTC - 20 - represents time slot 20:00 - 23:59 UTC
isCustomActionTimeoutEnabled Boolean

(Updatable) If true, enables the configuration of a custom action timeout (waiting period) between database server patching operations.

isMonthlyPatchingEnabled Boolean

(Updatable) If true, enables the monthly patching option.

leadTimeInWeeks Integer

(Updatable) Lead time window allows user to set a lead time to prepare for a down time. The lead time is in weeks and valid value is between 1 to 4.

months List<DbSystemMaintenanceWindowMonth>

(Updatable) Months during the year when maintenance should be performed.

patchingMode String

(Updatable) Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.

preference String

(Updatable) The maintenance window scheduling preference.

weeksOfMonths List<Integer>

(Updatable) Weeks during the month when maintenance should be performed. Weeks start on the 1st, 8th, 15th, and 22nd days of the month, and have a duration of 7 days. Weeks start and end based on calendar dates, not days of the week. For example, to allow maintenance during the 2nd week of the month (from the 8th day to the 14th day of the month), use the value 2. Maintenance cannot be scheduled for the fifth week of months that contain more than 28 days. Note that this parameter works in conjunction with the daysOfWeek and hoursOfDay parameters to allow you to specify specific days of the week and hours that maintenance will be performed.

customActionTimeoutInMins number

(Updatable) Determines the amount of time the system will wait before the start of each database server patching operation. Custom action timeout is in minutes and valid value is between 15 to 120 (inclusive).

daysOfWeeks DbSystemMaintenanceWindowDaysOfWeek[]

(Updatable) Days during the week when maintenance should be performed.

hoursOfDays number[]

(Updatable) The window of hours during the day when maintenance should be performed. The window is a 4 hour slot. Valid values are

  • 0 - represents time slot 0:00 - 3:59 UTC - 4 - represents time slot 4:00 - 7:59 UTC - 8 - represents time slot 8:00 - 11:59 UTC - 12 - represents time slot 12:00 - 15:59 UTC - 16 - represents time slot 16:00 - 19:59 UTC - 20 - represents time slot 20:00 - 23:59 UTC
isCustomActionTimeoutEnabled boolean

(Updatable) If true, enables the configuration of a custom action timeout (waiting period) between database server patching operations.

isMonthlyPatchingEnabled boolean

(Updatable) If true, enables the monthly patching option.

leadTimeInWeeks number

(Updatable) Lead time window allows user to set a lead time to prepare for a down time. The lead time is in weeks and valid value is between 1 to 4.

months DbSystemMaintenanceWindowMonth[]

(Updatable) Months during the year when maintenance should be performed.

patchingMode string

(Updatable) Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.

preference string

(Updatable) The maintenance window scheduling preference.

weeksOfMonths number[]

(Updatable) Weeks during the month when maintenance should be performed. Weeks start on the 1st, 8th, 15th, and 22nd days of the month, and have a duration of 7 days. Weeks start and end based on calendar dates, not days of the week. For example, to allow maintenance during the 2nd week of the month (from the 8th day to the 14th day of the month), use the value 2. Maintenance cannot be scheduled for the fifth week of months that contain more than 28 days. Note that this parameter works in conjunction with the daysOfWeek and hoursOfDay parameters to allow you to specify specific days of the week and hours that maintenance will be performed.

custom_action_timeout_in_mins int

(Updatable) Determines the amount of time the system will wait before the start of each database server patching operation. Custom action timeout is in minutes and valid value is between 15 to 120 (inclusive).

days_of_weeks DbSystemMaintenanceWindowDaysOfWeek]

(Updatable) Days during the week when maintenance should be performed.

hours_of_days Sequence[int]

(Updatable) The window of hours during the day when maintenance should be performed. The window is a 4 hour slot. Valid values are

  • 0 - represents time slot 0:00 - 3:59 UTC - 4 - represents time slot 4:00 - 7:59 UTC - 8 - represents time slot 8:00 - 11:59 UTC - 12 - represents time slot 12:00 - 15:59 UTC - 16 - represents time slot 16:00 - 19:59 UTC - 20 - represents time slot 20:00 - 23:59 UTC
is_custom_action_timeout_enabled bool

(Updatable) If true, enables the configuration of a custom action timeout (waiting period) between database server patching operations.

is_monthly_patching_enabled bool

(Updatable) If true, enables the monthly patching option.

lead_time_in_weeks int

(Updatable) Lead time window allows user to set a lead time to prepare for a down time. The lead time is in weeks and valid value is between 1 to 4.

months DbSystemMaintenanceWindowMonth]

(Updatable) Months during the year when maintenance should be performed.

patching_mode str

(Updatable) Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.

preference str

(Updatable) The maintenance window scheduling preference.

weeks_of_months Sequence[int]

(Updatable) Weeks during the month when maintenance should be performed. Weeks start on the 1st, 8th, 15th, and 22nd days of the month, and have a duration of 7 days. Weeks start and end based on calendar dates, not days of the week. For example, to allow maintenance during the 2nd week of the month (from the 8th day to the 14th day of the month), use the value 2. Maintenance cannot be scheduled for the fifth week of months that contain more than 28 days. Note that this parameter works in conjunction with the daysOfWeek and hoursOfDay parameters to allow you to specify specific days of the week and hours that maintenance will be performed.

customActionTimeoutInMins Number

(Updatable) Determines the amount of time the system will wait before the start of each database server patching operation. Custom action timeout is in minutes and valid value is between 15 to 120 (inclusive).

daysOfWeeks List<Property Map>

(Updatable) Days during the week when maintenance should be performed.

hoursOfDays List<Number>

(Updatable) The window of hours during the day when maintenance should be performed. The window is a 4 hour slot. Valid values are

  • 0 - represents time slot 0:00 - 3:59 UTC - 4 - represents time slot 4:00 - 7:59 UTC - 8 - represents time slot 8:00 - 11:59 UTC - 12 - represents time slot 12:00 - 15:59 UTC - 16 - represents time slot 16:00 - 19:59 UTC - 20 - represents time slot 20:00 - 23:59 UTC
isCustomActionTimeoutEnabled Boolean

(Updatable) If true, enables the configuration of a custom action timeout (waiting period) between database server patching operations.

isMonthlyPatchingEnabled Boolean

(Updatable) If true, enables the monthly patching option.

leadTimeInWeeks Number

(Updatable) Lead time window allows user to set a lead time to prepare for a down time. The lead time is in weeks and valid value is between 1 to 4.

months List<Property Map>

(Updatable) Months during the year when maintenance should be performed.

patchingMode String

(Updatable) Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.

preference String

(Updatable) The maintenance window scheduling preference.

weeksOfMonths List<Number>

(Updatable) Weeks during the month when maintenance should be performed. Weeks start on the 1st, 8th, 15th, and 22nd days of the month, and have a duration of 7 days. Weeks start and end based on calendar dates, not days of the week. For example, to allow maintenance during the 2nd week of the month (from the 8th day to the 14th day of the month), use the value 2. Maintenance cannot be scheduled for the fifth week of months that contain more than 28 days. Note that this parameter works in conjunction with the daysOfWeek and hoursOfDay parameters to allow you to specify specific days of the week and hours that maintenance will be performed.

DbSystemMaintenanceWindowDaysOfWeek

Name string

(Updatable) Name of the month of the year.

Name string

(Updatable) Name of the month of the year.

name String

(Updatable) Name of the month of the year.

name string

(Updatable) Name of the month of the year.

name str

(Updatable) Name of the month of the year.

name String

(Updatable) Name of the month of the year.

DbSystemMaintenanceWindowDetails

CustomActionTimeoutInMins int

(Updatable) Determines the amount of time the system will wait before the start of each database server patching operation. Custom action timeout is in minutes and valid value is between 15 to 120 (inclusive).

DaysOfWeeks List<DbSystemMaintenanceWindowDetailsDaysOfWeek>

(Updatable) Days during the week when maintenance should be performed.

HoursOfDays List<int>

(Updatable) The window of hours during the day when maintenance should be performed. The window is a 4 hour slot. Valid values are

  • 0 - represents time slot 0:00 - 3:59 UTC - 4 - represents time slot 4:00 - 7:59 UTC - 8 - represents time slot 8:00 - 11:59 UTC - 12 - represents time slot 12:00 - 15:59 UTC - 16 - represents time slot 16:00 - 19:59 UTC - 20 - represents time slot 20:00 - 23:59 UTC
IsCustomActionTimeoutEnabled bool

(Updatable) If true, enables the configuration of a custom action timeout (waiting period) between database server patching operations.

IsMonthlyPatchingEnabled bool

(Updatable) If true, enables the monthly patching option.

LeadTimeInWeeks int

(Updatable) Lead time window allows user to set a lead time to prepare for a down time. The lead time is in weeks and valid value is between 1 to 4.

Months List<DbSystemMaintenanceWindowDetailsMonth>

(Updatable) Months during the year when maintenance should be performed.

PatchingMode string

(Updatable) Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.

Preference string

(Updatable) The maintenance window scheduling preference.

WeeksOfMonths List<int>

(Updatable) Weeks during the month when maintenance should be performed. Weeks start on the 1st, 8th, 15th, and 22nd days of the month, and have a duration of 7 days. Weeks start and end based on calendar dates, not days of the week. For example, to allow maintenance during the 2nd week of the month (from the 8th day to the 14th day of the month), use the value 2. Maintenance cannot be scheduled for the fifth week of months that contain more than 28 days. Note that this parameter works in conjunction with the daysOfWeek and hoursOfDay parameters to allow you to specify specific days of the week and hours that maintenance will be performed.

CustomActionTimeoutInMins int

(Updatable) Determines the amount of time the system will wait before the start of each database server patching operation. Custom action timeout is in minutes and valid value is between 15 to 120 (inclusive).

DaysOfWeeks []DbSystemMaintenanceWindowDetailsDaysOfWeek

(Updatable) Days during the week when maintenance should be performed.

HoursOfDays []int

(Updatable) The window of hours during the day when maintenance should be performed. The window is a 4 hour slot. Valid values are

  • 0 - represents time slot 0:00 - 3:59 UTC - 4 - represents time slot 4:00 - 7:59 UTC - 8 - represents time slot 8:00 - 11:59 UTC - 12 - represents time slot 12:00 - 15:59 UTC - 16 - represents time slot 16:00 - 19:59 UTC - 20 - represents time slot 20:00 - 23:59 UTC
IsCustomActionTimeoutEnabled bool

(Updatable) If true, enables the configuration of a custom action timeout (waiting period) between database server patching operations.

IsMonthlyPatchingEnabled bool

(Updatable) If true, enables the monthly patching option.

LeadTimeInWeeks int

(Updatable) Lead time window allows user to set a lead time to prepare for a down time. The lead time is in weeks and valid value is between 1 to 4.

Months []DbSystemMaintenanceWindowDetailsMonth

(Updatable) Months during the year when maintenance should be performed.

PatchingMode string

(Updatable) Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.

Preference string

(Updatable) The maintenance window scheduling preference.

WeeksOfMonths []int

(Updatable) Weeks during the month when maintenance should be performed. Weeks start on the 1st, 8th, 15th, and 22nd days of the month, and have a duration of 7 days. Weeks start and end based on calendar dates, not days of the week. For example, to allow maintenance during the 2nd week of the month (from the 8th day to the 14th day of the month), use the value 2. Maintenance cannot be scheduled for the fifth week of months that contain more than 28 days. Note that this parameter works in conjunction with the daysOfWeek and hoursOfDay parameters to allow you to specify specific days of the week and hours that maintenance will be performed.

customActionTimeoutInMins Integer

(Updatable) Determines the amount of time the system will wait before the start of each database server patching operation. Custom action timeout is in minutes and valid value is between 15 to 120 (inclusive).

daysOfWeeks List<DbSystemMaintenanceWindowDetailsDaysOfWeek>

(Updatable) Days during the week when maintenance should be performed.

hoursOfDays List<Integer>

(Updatable) The window of hours during the day when maintenance should be performed. The window is a 4 hour slot. Valid values are

  • 0 - represents time slot 0:00 - 3:59 UTC - 4 - represents time slot 4:00 - 7:59 UTC - 8 - represents time slot 8:00 - 11:59 UTC - 12 - represents time slot 12:00 - 15:59 UTC - 16 - represents time slot 16:00 - 19:59 UTC - 20 - represents time slot 20:00 - 23:59 UTC
isCustomActionTimeoutEnabled Boolean

(Updatable) If true, enables the configuration of a custom action timeout (waiting period) between database server patching operations.

isMonthlyPatchingEnabled Boolean

(Updatable) If true, enables the monthly patching option.

leadTimeInWeeks Integer

(Updatable) Lead time window allows user to set a lead time to prepare for a down time. The lead time is in weeks and valid value is between 1 to 4.

months List<DbSystemMaintenanceWindowDetailsMonth>

(Updatable) Months during the year when maintenance should be performed.

patchingMode String

(Updatable) Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.

preference String

(Updatable) The maintenance window scheduling preference.

weeksOfMonths List<Integer>

(Updatable) Weeks during the month when maintenance should be performed. Weeks start on the 1st, 8th, 15th, and 22nd days of the month, and have a duration of 7 days. Weeks start and end based on calendar dates, not days of the week. For example, to allow maintenance during the 2nd week of the month (from the 8th day to the 14th day of the month), use the value 2. Maintenance cannot be scheduled for the fifth week of months that contain more than 28 days. Note that this parameter works in conjunction with the daysOfWeek and hoursOfDay parameters to allow you to specify specific days of the week and hours that maintenance will be performed.

customActionTimeoutInMins number

(Updatable) Determines the amount of time the system will wait before the start of each database server patching operation. Custom action timeout is in minutes and valid value is between 15 to 120 (inclusive).

daysOfWeeks DbSystemMaintenanceWindowDetailsDaysOfWeek[]

(Updatable) Days during the week when maintenance should be performed.

hoursOfDays number[]

(Updatable) The window of hours during the day when maintenance should be performed. The window is a 4 hour slot. Valid values are

  • 0 - represents time slot 0:00 - 3:59 UTC - 4 - represents time slot 4:00 - 7:59 UTC - 8 - represents time slot 8:00 - 11:59 UTC - 12 - represents time slot 12:00 - 15:59 UTC - 16 - represents time slot 16:00 - 19:59 UTC - 20 - represents time slot 20:00 - 23:59 UTC
isCustomActionTimeoutEnabled boolean

(Updatable) If true, enables the configuration of a custom action timeout (waiting period) between database server patching operations.

isMonthlyPatchingEnabled boolean

(Updatable) If true, enables the monthly patching option.

leadTimeInWeeks number

(Updatable) Lead time window allows user to set a lead time to prepare for a down time. The lead time is in weeks and valid value is between 1 to 4.

months DbSystemMaintenanceWindowDetailsMonth[]

(Updatable) Months during the year when maintenance should be performed.

patchingMode string

(Updatable) Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.

preference string

(Updatable) The maintenance window scheduling preference.

weeksOfMonths number[]

(Updatable) Weeks during the month when maintenance should be performed. Weeks start on the 1st, 8th, 15th, and 22nd days of the month, and have a duration of 7 days. Weeks start and end based on calendar dates, not days of the week. For example, to allow maintenance during the 2nd week of the month (from the 8th day to the 14th day of the month), use the value 2. Maintenance cannot be scheduled for the fifth week of months that contain more than 28 days. Note that this parameter works in conjunction with the daysOfWeek and hoursOfDay parameters to allow you to specify specific days of the week and hours that maintenance will be performed.

custom_action_timeout_in_mins int

(Updatable) Determines the amount of time the system will wait before the start of each database server patching operation. Custom action timeout is in minutes and valid value is between 15 to 120 (inclusive).

days_of_weeks DbSystemMaintenanceWindowDetailsDaysOfWeek]

(Updatable) Days during the week when maintenance should be performed.

hours_of_days Sequence[int]

(Updatable) The window of hours during the day when maintenance should be performed. The window is a 4 hour slot. Valid values are

  • 0 - represents time slot 0:00 - 3:59 UTC - 4 - represents time slot 4:00 - 7:59 UTC - 8 - represents time slot 8:00 - 11:59 UTC - 12 - represents time slot 12:00 - 15:59 UTC - 16 - represents time slot 16:00 - 19:59 UTC - 20 - represents time slot 20:00 - 23:59 UTC
is_custom_action_timeout_enabled bool

(Updatable) If true, enables the configuration of a custom action timeout (waiting period) between database server patching operations.

is_monthly_patching_enabled bool

(Updatable) If true, enables the monthly patching option.

lead_time_in_weeks int

(Updatable) Lead time window allows user to set a lead time to prepare for a down time. The lead time is in weeks and valid value is between 1 to 4.

months DbSystemMaintenanceWindowDetailsMonth]

(Updatable) Months during the year when maintenance should be performed.

patching_mode str

(Updatable) Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.

preference str

(Updatable) The maintenance window scheduling preference.

weeks_of_months Sequence[int]

(Updatable) Weeks during the month when maintenance should be performed. Weeks start on the 1st, 8th, 15th, and 22nd days of the month, and have a duration of 7 days. Weeks start and end based on calendar dates, not days of the week. For example, to allow maintenance during the 2nd week of the month (from the 8th day to the 14th day of the month), use the value 2. Maintenance cannot be scheduled for the fifth week of months that contain more than 28 days. Note that this parameter works in conjunction with the daysOfWeek and hoursOfDay parameters to allow you to specify specific days of the week and hours that maintenance will be performed.

customActionTimeoutInMins Number

(Updatable) Determines the amount of time the system will wait before the start of each database server patching operation. Custom action timeout is in minutes and valid value is between 15 to 120 (inclusive).

daysOfWeeks List<Property Map>

(Updatable) Days during the week when maintenance should be performed.

hoursOfDays List<Number>

(Updatable) The window of hours during the day when maintenance should be performed. The window is a 4 hour slot. Valid values are

  • 0 - represents time slot 0:00 - 3:59 UTC - 4 - represents time slot 4:00 - 7:59 UTC - 8 - represents time slot 8:00 - 11:59 UTC - 12 - represents time slot 12:00 - 15:59 UTC - 16 - represents time slot 16:00 - 19:59 UTC - 20 - represents time slot 20:00 - 23:59 UTC
isCustomActionTimeoutEnabled Boolean

(Updatable) If true, enables the configuration of a custom action timeout (waiting period) between database server patching operations.

isMonthlyPatchingEnabled Boolean

(Updatable) If true, enables the monthly patching option.

leadTimeInWeeks Number

(Updatable) Lead time window allows user to set a lead time to prepare for a down time. The lead time is in weeks and valid value is between 1 to 4.

months List<Property Map>

(Updatable) Months during the year when maintenance should be performed.

patchingMode String

(Updatable) Cloud Exadata infrastructure node patching method, either "ROLLING" or "NONROLLING". Default value is ROLLING.

preference String

(Updatable) The maintenance window scheduling preference.

weeksOfMonths List<Number>

(Updatable) Weeks during the month when maintenance should be performed. Weeks start on the 1st, 8th, 15th, and 22nd days of the month, and have a duration of 7 days. Weeks start and end based on calendar dates, not days of the week. For example, to allow maintenance during the 2nd week of the month (from the 8th day to the 14th day of the month), use the value 2. Maintenance cannot be scheduled for the fifth week of months that contain more than 28 days. Note that this parameter works in conjunction with the daysOfWeek and hoursOfDay parameters to allow you to specify specific days of the week and hours that maintenance will be performed.

DbSystemMaintenanceWindowDetailsDaysOfWeek

Name string

(Updatable) Name of the month of the year.

Name string

(Updatable) Name of the month of the year.

name String

(Updatable) Name of the month of the year.

name string

(Updatable) Name of the month of the year.

name str

(Updatable) Name of the month of the year.

name String

(Updatable) Name of the month of the year.

DbSystemMaintenanceWindowDetailsMonth

Name string

(Updatable) Name of the month of the year.

Name string

(Updatable) Name of the month of the year.

name String

(Updatable) Name of the month of the year.

name string

(Updatable) Name of the month of the year.

name str

(Updatable) Name of the month of the year.

name String

(Updatable) Name of the month of the year.

DbSystemMaintenanceWindowMonth

Name string

(Updatable) Name of the month of the year.

Name string

(Updatable) Name of the month of the year.

name String

(Updatable) Name of the month of the year.

name string

(Updatable) Name of the month of the year.

name str

(Updatable) Name of the month of the year.

name String

(Updatable) Name of the month of the year.

Import

DbSystems can be imported using the id, e.g.

 $ pulumi import oci:Database/dbSystem:DbSystem test_db_system "id"

Import is only supported for source=NONE db_home.0.database.0.admin_password is not returned by the service for security reasons. To avoid a force new of the db_home on the next apply, add the following to the resource:

lifecycle {

ignore_changes = [“db_home.0.database.0.admin_password”]

} You may also need to add hostname to the ignore_changes list if you see a diff on a subsequent apply If the oci_database_db_system being imported is missing a primary db_home, an empty placeholder for db_home will be set in the Terraform state. To keep configurations consistent with the imported state, add an empty placeholder for db_home to your configuration like this:

Add this placeholder into your oci_database_db_system configuration to indicate that the primary db home is empty.

db_home {

database {

admin_password = ""

}

}

Package Details

Repository
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.