# 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).
require 'date'
require 'oci'
# 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::ConfigFileLoader.load_config
# Initialize service client with default config file
database_client = OCI::Database::DatabaseClient.new(config: config)
# Send the request to service, some parameters are not required, see API doc for more info
update_autonomous_database_response =
database_client.update_autonomous_database(
'ocid1.test.oc1..<unique_ID>EXAMPLE-autonomousDatabaseId-Value',
OCI::Database::Models::UpdateAutonomousDatabaseDetails.new(
backup_retention_period_in_days: 3354,
compute_model: 'ECPU',
in_memory_percentage: 437,
local_adg_auto_failover_max_data_loss_limit: 2544,
cpu_core_count: 100,
long_term_backup_schedule:
OCI::Database::Models::LongTermBackUpScheduleDetails.new(
repeat_cadence: 'ONE_TIME',
time_of_backup: DateTime.parse('2025-08-13T08:56:43.405Z'),
retention_period_in_days: 1767,
is_disabled: true
),
is_dev_tier: true,
compute_count: 162.34131,
ocpu_count: 1960.1918,
data_storage_size_in_tbs: 92,
data_storage_size_in_gbs: 20_998,
display_name: 'EXAMPLE-displayName-Value',
is_free_tier: false,
admin_password: 'EXAMPLE-adminPassword-Value',
db_name: 'EXAMPLE-dbName-Value',
freeform_tags: {
'EXAMPLE_KEY_BCspS' => 'EXAMPLE_VALUE_6pHKaGA7uXlklsEmCkMe'
},
defined_tags: {
'EXAMPLE_KEY_UCvjR' => { 'EXAMPLE_KEY_4FMSi' => 'EXAMPLE--Value' }
},
security_attributes: {
'EXAMPLE_KEY_xIuTa' => { 'EXAMPLE_KEY_drrEU' => 'EXAMPLE--Value' }
},
db_workload: 'OLTP',
license_model: 'LICENSE_INCLUDED',
byol_compute_count_limit: 8181.3164,
is_access_control_enabled: true,
whitelisted_ips: %w[EXAMPLE--Value],
are_primary_whitelisted_ips_used: false,
standby_whitelisted_ips: %w[EXAMPLE--Value],
is_auto_scaling_enabled: false,
is_refreshable_clone: true,
refreshable_mode: 'MANUAL',
is_local_data_guard_enabled: false,
is_data_guard_enabled: true,
peer_db_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-peerDbId-Value',
db_version: 'EXAMPLE-dbVersion-Value',
open_mode: 'READ_ONLY',
permission_level: 'RESTRICTED',
subnet_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-subnetId-Value',
private_endpoint_label: 'EXAMPLE-privateEndpointLabel-Value',
private_endpoint_ip: 'EXAMPLE-privateEndpointIp-Value',
nsg_ids: %w[EXAMPLE--Value],
auto_refresh_frequency_in_seconds: 449_464,
auto_refresh_point_lag_in_seconds: 475_786,
time_of_auto_refresh_start: DateTime.parse('2047-06-20T06:09:02.629Z'),
customer_contacts: [
OCI::Database::Models::CustomerContact.new(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.new(
pool_size: 931,
pool_storage_size_in_tbs: 894,
available_storage_capacity_in_tbs: 9243.229,
total_compute_capacity: 790,
available_compute_capacity: 907,
is_disabled: true
),
autonomous_maintenance_schedule_type: 'REGULAR',
autonomous_database_maintenance_window:
OCI::Database::Models::AutonomousDatabaseMaintenanceWindowSummary.new(
day_of_week: OCI::Database::Models::DayOfWeek.new(name: 'TUESDAY'),
maintenance_start_time: 'EXAMPLE-maintenanceStartTime-Value',
maintenance_end_time: 'EXAMPLE-maintenanceEndTime-Value'
),
time_maintenance_pause_until: DateTime.parse('2021-01-12T20:07:24.803Z'),
is_backup_retention_locked: false,
time_scheduled_db_version_upgrade:
DateTime.parse('2006-07-29T23:04:58.282Z'),
is_disable_db_version_upgrade_schedule: true,
is_schedule_db_version_upgrade_to_earliest: false,
scheduled_operations: [
OCI::Database::Models::ScheduledOperationDetails.new(
day_of_week: OCI::Database::Models::DayOfWeek.new(name: 'FRIDAY'),
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.new(
name: 'OML',
is_enabled: true,
compute_count: 8614.05,
max_idle_time_in_minutes: 730
)
],
vanity_url_details:
OCI::Database::Models::VanityUrlDetails.new(
is_disabled: true,
api_gateway_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-apiGatewayId-Value',
vanity_url_host_name: 'EXAMPLE-vanityUrlHostName-Value'
),
secret_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-secretId-Value',
secret_version_number: 18,
encryption_key:
OCI::Database::Models::OciKeyDetails.new(
provider: 'OCI',
kms_key_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-kmsKeyId-Value',
vault_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-vaultId-Value'
),
is_disconnect_peer: true,
local_adg_resource_pool_leader_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-localAdgResourcePoolLeaderId-Value'
)
)
# Get the data from response
puts "#{update_autonomous_database_response.data}"