# This is an automatically generated code sample.
# To make this code sample work in your Oracle Cloud tenancy,
# please replace the values for any parameters whose current values do not fit
# your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and
# boolean, number, and enum parameters with values not fitting your use case).
import oci
from datetime import datetime
# Create a default config using DEFAULT profile in default location
# Refer to
# https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File
# for more info
config = oci.config.from_file()
# Initialize service client with default config file
database_client = oci.database.DatabaseClient(config)
# Send the request to service, some parameters are not required, see API
# doc for more info
create_autonomous_database_response = database_client.create_autonomous_database(
create_autonomous_database_details=oci.database.models.CreateRefreshableAutonomousDatabaseCloneDetails(
source="CLONE_TO_REFRESHABLE",
compartment_id="ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value",
source_id="ocid1.test.oc1..<unique_ID>EXAMPLE-sourceId-Value",
subscription_id="ocid1.test.oc1..<unique_ID>EXAMPLE-subscriptionId-Value",
availability_domain="EXAMPLE-availabilityDomain-Value",
character_set="EXAMPLE-characterSet-Value",
ncharacter_set="EXAMPLE-ncharacterSet-Value",
db_name="EXAMPLE-dbName-Value",
cpu_core_count=85,
backup_retention_period_in_days=1565,
compute_model="ECPU",
compute_count=202.52539,
ocpu_count=3493.84,
db_workload="APEX",
data_storage_size_in_tbs=135,
data_storage_size_in_gbs=105665,
is_free_tier=True,
kms_key_id="ocid1.test.oc1..<unique_ID>EXAMPLE-kmsKeyId-Value",
vault_id="ocid1.test.oc1..<unique_ID>EXAMPLE-vaultId-Value",
encryption_key=oci.database.models.OciKeyDetails(
provider="OCI",
kms_key_id="ocid1.test.oc1..<unique_ID>EXAMPLE-kmsKeyId-Value",
vault_id="ocid1.test.oc1..<unique_ID>EXAMPLE-vaultId-Value"),
admin_password="EXAMPLE-adminPassword-Value",
display_name="EXAMPLE-displayName-Value",
license_model="LICENSE_INCLUDED",
byol_compute_count_limit=1035.8185,
is_preview_version_with_service_terms_accepted=False,
is_auto_scaling_enabled=False,
is_dev_tier=True,
is_dedicated=True,
autonomous_container_database_id="ocid1.test.oc1..<unique_ID>EXAMPLE-autonomousContainerDatabaseId-Value",
in_memory_percentage=676,
is_access_control_enabled=True,
whitelisted_ips=["EXAMPLE--Value"],
are_primary_whitelisted_ips_used=False,
standby_whitelisted_ips=["EXAMPLE--Value"],
is_data_guard_enabled=False,
is_local_data_guard_enabled=True,
subnet_id="ocid1.test.oc1..<unique_ID>EXAMPLE-subnetId-Value",
nsg_ids=["EXAMPLE--Value"],
private_endpoint_label="EXAMPLE-privateEndpointLabel-Value",
freeform_tags={
'EXAMPLE_KEY_GE0bh': 'EXAMPLE_VALUE_wlsrnLoaW8K0leTAEfSY'},
defined_tags={
'EXAMPLE_KEY_y4xmt': {
'EXAMPLE_KEY_nK8VW': 'EXAMPLE--Value'}},
security_attributes={
'EXAMPLE_KEY_Gqt1m': {
'EXAMPLE_KEY_cwEcW': 'EXAMPLE--Value'}},
private_endpoint_ip="EXAMPLE-privateEndpointIp-Value",
db_version="EXAMPLE-dbVersion-Value",
customer_contacts=[
oci.database.models.CustomerContact(
email="EXAMPLE-email-Value")],
is_mtls_connection_required=False,
resource_pool_leader_id="ocid1.test.oc1..<unique_ID>EXAMPLE-resourcePoolLeaderId-Value",
resource_pool_summary=oci.database.models.ResourcePoolSummary(
pool_size=451,
pool_storage_size_in_tbs=494,
available_storage_capacity_in_tbs=3465.06,
total_compute_capacity=114,
available_compute_capacity=196,
is_disabled=True),
autonomous_maintenance_schedule_type="EARLY",
autonomous_database_maintenance_window=oci.database.models.AutonomousDatabaseMaintenanceWindowSummary(
day_of_week=oci.database.models.DayOfWeek(
name="TUESDAY"),
maintenance_start_time="EXAMPLE-maintenanceStartTime-Value",
maintenance_end_time="EXAMPLE-maintenanceEndTime-Value",
availability_domain="EXAMPLE-availabilityDomain-Value",
is_maintenance_window_change_scheduled=True),
scheduled_operations=[
oci.database.models.ScheduledOperationDetails(
day_of_week=oci.database.models.DayOfWeek(
name="TUESDAY"),
scheduled_start_time="EXAMPLE-scheduledStartTime-Value",
scheduled_stop_time="EXAMPLE-scheduledStopTime-Value")],
is_auto_scaling_for_storage_enabled=False,
database_edition="ENTERPRISE_EDITION",
db_tools_details=[
oci.database.models.DatabaseTool(
name="GRAPH_STUDIO",
is_enabled=False,
compute_count=9556.631,
max_idle_time_in_minutes=565)],
is_backup_retention_locked=False,
secret_id="ocid1.test.oc1..<unique_ID>EXAMPLE-secretId-Value",
secret_version_number=23,
transportable_tablespace=oci.database.models.ImportTransportableTablespaceDetails(
tts_bundle_url="EXAMPLE-ttsBundleUrl-Value"),
refreshable_mode="AUTOMATIC",
auto_refresh_frequency_in_seconds=93481,
auto_refresh_point_lag_in_seconds=412133,
time_of_auto_refresh_start=datetime.strptime(
"2000-12-18T07:38:32.694Z",
"%Y-%m-%dT%H:%M:%S.%fZ"),
open_mode="READ_ONLY",
clone_type="FULL"),
opc_retry_token="EXAMPLE-opcRetryToken-Value",
opc_request_id="PQE9J3DJVNCPCTV0EIPZ<unique_ID>",
opc_dry_run=True)
# Get the data from response
print(create_autonomous_database_response.data)