Database¶

class oci.database.models.Database(**kwargs)¶

Bases: object

Database model.

Attributes

`LIFECYCLE_STATE_AVAILABLE`	A constant which can be used with the lifecycle_state property of a Database.
`LIFECYCLE_STATE_BACKUP_IN_PROGRESS`	A constant which can be used with the lifecycle_state property of a Database.
`LIFECYCLE_STATE_CONVERTING`	A constant which can be used with the lifecycle_state property of a Database.
`LIFECYCLE_STATE_FAILED`	A constant which can be used with the lifecycle_state property of a Database.
`LIFECYCLE_STATE_PROVISIONING`	A constant which can be used with the lifecycle_state property of a Database.
`LIFECYCLE_STATE_RESTORE_FAILED`	A constant which can be used with the lifecycle_state property of a Database.
`LIFECYCLE_STATE_TERMINATED`	A constant which can be used with the lifecycle_state property of a Database.
`LIFECYCLE_STATE_TERMINATING`	A constant which can be used with the lifecycle_state property of a Database.
`LIFECYCLE_STATE_UPDATING`	A constant which can be used with the lifecycle_state property of a Database.
`LIFECYCLE_STATE_UPGRADING`	A constant which can be used with the lifecycle_state property of a Database.
`character_set`	Gets the character_set of this Database.
`compartment_id`	[Required] Gets the compartment_id of this Database.
`connection_strings`	Gets the connection_strings of this Database.
`database_management_config`	Gets the database_management_config of this Database.
`database_software_image_id`	Gets the database_software_image_id of this Database.
`db_backup_config`	Gets the db_backup_config of this Database.
`db_home_id`	Gets the db_home_id of this Database.
`db_name`	[Required] Gets the db_name of this Database.
`db_system_id`	Gets the db_system_id of this Database.
`db_unique_name`	[Required] Gets the db_unique_name of this Database.
`db_workload`	Gets the db_workload of this Database.
`defined_tags`	Gets the defined_tags of this Database.
`freeform_tags`	Gets the freeform_tags of this Database.
`id`	[Required] Gets the id of this Database.
`is_cdb`	Gets the is_cdb of this Database.
`key_store_id`	Gets the key_store_id of this Database.
`key_store_wallet_name`	Gets the key_store_wallet_name of this Database.
`kms_key_id`	Gets the kms_key_id of this Database.
`kms_key_version_id`	Gets the kms_key_version_id of this Database.
`last_backup_duration_in_seconds`	Gets the last_backup_duration_in_seconds of this Database.
`last_backup_timestamp`	Gets the last_backup_timestamp of this Database.
`last_failed_backup_timestamp`	Gets the last_failed_backup_timestamp of this Database.
`lifecycle_details`	Gets the lifecycle_details of this Database.
`lifecycle_state`	[Required] Gets the lifecycle_state of this Database.
`ncharacter_set`	Gets the ncharacter_set of this Database.
`pdb_name`	Gets the pdb_name of this Database.
`sid_prefix`	Gets the sid_prefix of this Database.
`source_database_point_in_time_recovery_timestamp`	Gets the source_database_point_in_time_recovery_timestamp of this Database.
`time_created`	Gets the time_created of this Database.
`vault_id`	Gets the vault_id of this Database.
`vm_cluster_id`	Gets the vm_cluster_id of this Database.

Methods

__init__(**kwargs) Initializes a new Database object with values from keyword arguments.

LIFECYCLE_STATE_AVAILABLE = 'AVAILABLE'¶: A constant which can be used with the lifecycle_state property of a Database. This constant has a value of “AVAILABLE”

LIFECYCLE_STATE_BACKUP_IN_PROGRESS = 'BACKUP_IN_PROGRESS'¶: A constant which can be used with the lifecycle_state property of a Database. This constant has a value of “BACKUP_IN_PROGRESS”

LIFECYCLE_STATE_CONVERTING = 'CONVERTING'¶: A constant which can be used with the lifecycle_state property of a Database. This constant has a value of “CONVERTING”

LIFECYCLE_STATE_FAILED = 'FAILED'¶: A constant which can be used with the lifecycle_state property of a Database. This constant has a value of “FAILED”

LIFECYCLE_STATE_PROVISIONING = 'PROVISIONING'¶: A constant which can be used with the lifecycle_state property of a Database. This constant has a value of “PROVISIONING”

LIFECYCLE_STATE_RESTORE_FAILED = 'RESTORE_FAILED'¶: A constant which can be used with the lifecycle_state property of a Database. This constant has a value of “RESTORE_FAILED”

LIFECYCLE_STATE_TERMINATED = 'TERMINATED'¶: A constant which can be used with the lifecycle_state property of a Database. This constant has a value of “TERMINATED”

LIFECYCLE_STATE_TERMINATING = 'TERMINATING'¶: A constant which can be used with the lifecycle_state property of a Database. This constant has a value of “TERMINATING”

LIFECYCLE_STATE_UPDATING = 'UPDATING'¶: A constant which can be used with the lifecycle_state property of a Database. This constant has a value of “UPDATING”

LIFECYCLE_STATE_UPGRADING = 'UPGRADING'¶: A constant which can be used with the lifecycle_state property of a Database. This constant has a value of “UPGRADING”

__init__(**kwargs)¶

Initializes a new Database object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

id (str) – The value to assign to the id property of this Database.
compartment_id (str) – The value to assign to the compartment_id property of this Database.
character_set (str) – The value to assign to the character_set property of this Database.
ncharacter_set (str) – The value to assign to the ncharacter_set property of this Database.
db_home_id (str) – The value to assign to the db_home_id property of this Database.
db_system_id (str) – The value to assign to the db_system_id property of this Database.
vm_cluster_id (str) – The value to assign to the vm_cluster_id property of this Database.
db_name (str) – The value to assign to the db_name property of this Database.
pdb_name (str) – The value to assign to the pdb_name property of this Database.
db_workload (str) – The value to assign to the db_workload property of this Database.
db_unique_name (str) – The value to assign to the db_unique_name property of this Database.
lifecycle_details (str) – The value to assign to the lifecycle_details property of this Database.
lifecycle_state (str) – The value to assign to the lifecycle_state property of this Database. Allowed values for this property are: “PROVISIONING”, “AVAILABLE”, “UPDATING”, “BACKUP_IN_PROGRESS”, “UPGRADING”, “CONVERTING”, “TERMINATING”, “TERMINATED”, “RESTORE_FAILED”, “FAILED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
time_created (datetime) – The value to assign to the time_created property of this Database.
last_backup_timestamp (datetime) – The value to assign to the last_backup_timestamp property of this Database.
last_backup_duration_in_seconds (int) – The value to assign to the last_backup_duration_in_seconds property of this Database.
last_failed_backup_timestamp (datetime) – The value to assign to the last_failed_backup_timestamp property of this Database.
db_backup_config (oci.database.models.DbBackupConfig) – The value to assign to the db_backup_config property of this Database.
freeform_tags (dict(str, str)) – The value to assign to the freeform_tags property of this Database.
defined_tags (dict(str, dict(str, object))) – The value to assign to the defined_tags property of this Database.
connection_strings (oci.database.models.DatabaseConnectionStrings) – The value to assign to the connection_strings property of this Database.
kms_key_id (str) – The value to assign to the kms_key_id property of this Database.
kms_key_version_id (str) – The value to assign to the kms_key_version_id property of this Database.
vault_id (str) – The value to assign to the vault_id property of this Database.
source_database_point_in_time_recovery_timestamp (datetime) – The value to assign to the source_database_point_in_time_recovery_timestamp property of this Database.
database_software_image_id (str) – The value to assign to the database_software_image_id property of this Database.
is_cdb (bool) – The value to assign to the is_cdb property of this Database.
database_management_config (oci.database.models.CloudDatabaseManagementConfig) – The value to assign to the database_management_config property of this Database.
sid_prefix (str) – The value to assign to the sid_prefix property of this Database.
key_store_id (str) – The value to assign to the key_store_id property of this Database.
key_store_wallet_name (str) – The value to assign to the key_store_wallet_name property of this Database.

character_set¶

Gets the character_set of this Database. The character set for the database.

Returns:	The character_set of this Database.
Return type:	str

compartment_id¶

[Required] Gets the compartment_id of this Database. The OCID of the compartment.

Returns:	The compartment_id of this Database.
Return type:	str

connection_strings¶

Gets the connection_strings of this Database. The Connection strings used to connect to the Oracle Database.

Returns:	The connection_strings of this Database.
Return type:	oci.database.models.DatabaseConnectionStrings

database_management_config¶

Gets the database_management_config of this Database.

Returns:	The database_management_config of this Database.
Return type:	oci.database.models.CloudDatabaseManagementConfig

database_software_image_id¶

Gets the database_software_image_id of this Database. The database software image OCID

Returns:	The database_software_image_id of this Database.
Return type:	str

db_backup_config¶

Gets the db_backup_config of this Database.

Returns:	The db_backup_config of this Database.
Return type:	oci.database.models.DbBackupConfig

db_home_id¶

Gets the db_home_id of this Database. The OCID of the Database Home.

Returns:	The db_home_id of this Database.
Return type:	str

db_name¶

[Required] Gets the db_name of this Database. The database name.

Returns:	The db_name of this Database.
Return type:	str

db_system_id¶

Gets the db_system_id of this Database. The OCID of the DB system.

Returns:	The db_system_id of this Database.
Return type:	str

db_unique_name¶

[Required] Gets the db_unique_name of this Database. A system-generated name for the database to ensure uniqueness within an Oracle Data Guard group (a primary database and its standby databases). The unique name cannot be changed.

Returns:	The db_unique_name of this Database.
Return type:	str

db_workload¶

Gets the db_workload of this Database. Deprecated. The dbWorkload field has been deprecated for Exadata Database Service on Dedicated Infrastructure, Exadata Database Service on Cloud@Customer, and Base Database Service. Support for this attribute will end in November 2023. You may choose to update your custom scripts to exclude the dbWorkload attribute. After November 2023 if you pass a value to the dbWorkload attribute, it will be ignored.

The database workload type.

Returns:	The db_workload of this Database.
Return type:	str

defined_tags¶

Gets the defined_tags of this Database. Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags.

Returns:	The defined_tags of this Database.
Return type:	dict(str, dict(str, object))

freeform_tags¶

Gets the freeform_tags of this Database. 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”}

Returns:	The freeform_tags of this Database.
Return type:	dict(str, str)

id¶

[Required] Gets the id of this Database. The OCID of the database.

Returns:	The id of this Database.
Return type:	str

is_cdb¶

Gets the is_cdb of this Database. True if the database is a container database.

Returns:	The is_cdb of this Database.
Return type:	bool

key_store_id¶

Gets the key_store_id of this Database. The OCID of the key store of Oracle Vault.

Returns:	The key_store_id of this Database.
Return type:	str

key_store_wallet_name¶

Gets the key_store_wallet_name of this Database. The wallet name for Oracle Key Vault.

Returns:	The key_store_wallet_name of this Database.
Return type:	str

kms_key_id¶

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

Returns:	The kms_key_id of this Database.
Return type:	str

kms_key_version_id¶

Gets the kms_key_version_id of this Database. 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. Autonomous Database Serverless does not use key versions, hence is not applicable for Autonomous Database Serverless instances.

Returns:	The kms_key_version_id of this Database.
Return type:	str

last_backup_duration_in_seconds¶

Gets the last_backup_duration_in_seconds of this Database. The duration when the latest database backup created.

Returns:	The last_backup_duration_in_seconds of this Database.
Return type:	int

last_backup_timestamp¶

Gets the last_backup_timestamp of this Database. The date and time when the latest database backup was created.

Returns:	The last_backup_timestamp of this Database.
Return type:	datetime

last_failed_backup_timestamp¶

Gets the last_failed_backup_timestamp of this Database. The date and time when the latest database backup failed.

Returns:	The last_failed_backup_timestamp of this Database.
Return type:	datetime

lifecycle_details¶

Gets the lifecycle_details of this Database. Additional information about the current lifecycle state.

Returns:	The lifecycle_details of this Database.
Return type:	str

lifecycle_state¶

[Required] Gets the lifecycle_state of this Database. The current state of the database.

Allowed values for this property are: “PROVISIONING”, “AVAILABLE”, “UPDATING”, “BACKUP_IN_PROGRESS”, “UPGRADING”, “CONVERTING”, “TERMINATING”, “TERMINATED”, “RESTORE_FAILED”, “FAILED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The lifecycle_state of this Database.
Return type:	str

ncharacter_set¶

Gets the ncharacter_set of this Database. The national character set for the database.

Returns:	The ncharacter_set of this Database.
Return type:	str

pdb_name¶

Gets the pdb_name of this Database. 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.

Returns:	The pdb_name of this Database.
Return type:	str

sid_prefix¶

Gets the sid_prefix of this Database. Specifies a prefix for the Oracle SID of the database to be created.

Returns:	The sid_prefix of this Database.
Return type:	str

source_database_point_in_time_recovery_timestamp¶

Gets the source_database_point_in_time_recovery_timestamp of this Database. Point in time recovery timeStamp of the source database at which cloned database system is cloned from the source database system, as described in RFC 3339

Returns:	The source_database_point_in_time_recovery_timestamp of this Database.
Return type:	datetime

time_created¶

Gets the time_created of this Database. The date and time the database was created.

Returns:	The time_created of this Database.
Return type:	datetime

vault_id¶

Gets the vault_id of this Database. The OCID of the Oracle Cloud Infrastructure vault. This parameter and secretId are required for Customer Managed Keys.

Returns:	The vault_id of this Database.
Return type:	str

vm_cluster_id¶

Gets the vm_cluster_id of this Database. The OCID of the VM cluster.

Returns:	The vm_cluster_id of this Database.
Return type:	str