// 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).
using System;
using System.Collections.Generic;
using System.Threading.Tasks;
using Oci.DatabaseService;
using Oci.Common;
using Oci.Common.Auth;
namespace Oci.Sdk.DotNet.Example.Database
{
public class UpdateAutonomousDatabaseExample
{
public static async Task Main()
{
// Create a request and dependent object(s).
var updateAutonomousDatabaseDetails = new Oci.DatabaseService.Models.UpdateAutonomousDatabaseDetails
{
BackupRetentionPeriodInDays = 3163,
ComputeModel = Oci.DatabaseService.Models.UpdateAutonomousDatabaseDetails.ComputeModelEnum.Ocpu,
InMemoryPercentage = 687,
LocalAdgAutoFailoverMaxDataLossLimit = 2046,
CpuCoreCount = 64,
LongTermBackupSchedule = new Oci.DatabaseService.Models.LongTermBackUpScheduleDetails
{
RepeatCadence = Oci.DatabaseService.Models.LongTermBackUpScheduleDetails.RepeatCadenceEnum.Monthly,
TimeOfBackup = DateTime.Parse("02/26/2003 01:23:01"),
RetentionPeriodInDays = 1837,
IsDisabled = true
},
IsDevTier = true,
ComputeCount = (float)1939.2815,
OcpuCount = (float)9940.046,
DataStorageSizeInTBs = 102,
DataStorageSizeInGBs = 108423,
DisplayName = "EXAMPLE-displayName-Value",
IsFreeTier = true,
AvailabilityDomain = "EXAMPLE-availabilityDomain-Value",
TimeScheduledAdUpdate = DateTime.Parse("12/23/2020 14:13:03"),
IsDisableAdUpdateSchedule = false,
IsScheduleAdUpdateToEarliest = false,
AdminPassword = "EXAMPLE-adminPassword-Value",
DbName = "EXAMPLE-dbName-Value",
FreeformTags = new Dictionary<string, string>()
{
{
"EXAMPLE_KEY_xwEtb",
"EXAMPLE_VALUE_yT2Qqa0o7w7xZr6P2k48"
}
},
DefinedTags = new Dictionary<string, Dictionary<string, Object>>()
{
{
"EXAMPLE_KEY_AvuYS",
new Dictionary<string, Object>()
{
{
"EXAMPLE_KEY_iDWIv",
"EXAMPLE--Value"
}
}
}
},
SecurityAttributes = new Dictionary<string, Dictionary<string, Object>>()
{
{
"EXAMPLE_KEY_g1OWU",
new Dictionary<string, Object>()
{
{
"EXAMPLE_KEY_1Ye0D",
"EXAMPLE--Value"
}
}
}
},
DbWorkload = Oci.DatabaseService.Models.UpdateAutonomousDatabaseDetails.DbWorkloadEnum.Ajd,
LicenseModel = Oci.DatabaseService.Models.UpdateAutonomousDatabaseDetails.LicenseModelEnum.BringYourOwnLicense,
ByolComputeCountLimit = (float)4913.1914,
IsAccessControlEnabled = true,
WhitelistedIps = new List<string>
{
"EXAMPLE--Value"
},
ArePrimaryWhitelistedIpsUsed = false,
StandbyWhitelistedIps = new List<string>
{
"EXAMPLE--Value"
},
IsAutoScalingEnabled = false,
IsRefreshableClone = false,
RefreshableMode = Oci.DatabaseService.Models.UpdateAutonomousDatabaseDetails.RefreshableModeEnum.Manual,
IsLocalDataGuardEnabled = false,
IsDataGuardEnabled = true,
PeerDbId = "ocid1.test.oc1..<unique_ID>EXAMPLE-peerDbId-Value",
DbVersion = "EXAMPLE-dbVersion-Value",
OpenMode = Oci.DatabaseService.Models.UpdateAutonomousDatabaseDetails.OpenModeEnum.ReadWrite,
PermissionLevel = Oci.DatabaseService.Models.UpdateAutonomousDatabaseDetails.PermissionLevelEnum.Restricted,
SubnetId = "ocid1.test.oc1..<unique_ID>EXAMPLE-subnetId-Value",
PrivateEndpointLabel = "EXAMPLE-privateEndpointLabel-Value",
PrivateEndpointIp = "EXAMPLE-privateEndpointIp-Value",
NsgIds = new List<string>
{
"EXAMPLE--Value"
},
AutoRefreshFrequencyInSeconds = 314995,
AutoRefreshPointLagInSeconds = 270017,
TimeOfAutoRefreshStart = DateTime.Parse("12/31/2023 00:50:09"),
CustomerContacts = new List<Oci.DatabaseService.Models.CustomerContact>
{
new Oci.DatabaseService.Models.CustomerContact
{
Email = "EXAMPLE-email-Value"
}
},
IsMtlsConnectionRequired = true,
ResourcePoolLeaderId = "ocid1.test.oc1..<unique_ID>EXAMPLE-resourcePoolLeaderId-Value",
ResourcePoolSummary = new Oci.DatabaseService.Models.ResourcePoolSummary
{
PoolSize = 67,
PoolStorageSizeInTBs = 125,
AvailableStorageCapacityInTBs = 2700.4075,
TotalComputeCapacity = 806,
AvailableComputeCapacity = 249,
IsDisabled = false
},
AutonomousMaintenanceScheduleType = Oci.DatabaseService.Models.UpdateAutonomousDatabaseDetails.AutonomousMaintenanceScheduleTypeEnum.Regular,
AutonomousDatabaseMaintenanceWindow = new Oci.DatabaseService.Models.AutonomousDatabaseMaintenanceWindowSummary
{
DayOfWeek = new Oci.DatabaseService.Models.DayOfWeek
{
Name = Oci.DatabaseService.Models.DayOfWeek.NameEnum.Monday
},
MaintenanceStartTime = "EXAMPLE-maintenanceStartTime-Value",
MaintenanceEndTime = "EXAMPLE-maintenanceEndTime-Value",
AvailabilityDomain = "EXAMPLE-availabilityDomain-Value",
IsMaintenanceWindowChangeScheduled = false
},
TimeMaintenancePauseUntil = DateTime.Parse("02/13/2029 05:38:07"),
ScheduledMaintenanceWindow = new Oci.DatabaseService.Models.AutonomousDatabaseMaintenanceWindowSummary
{
DayOfWeek = new Oci.DatabaseService.Models.DayOfWeek
{
Name = Oci.DatabaseService.Models.DayOfWeek.NameEnum.Monday
},
MaintenanceStartTime = "EXAMPLE-maintenanceStartTime-Value",
MaintenanceEndTime = "EXAMPLE-maintenanceEndTime-Value",
AvailabilityDomain = "EXAMPLE-availabilityDomain-Value",
IsMaintenanceWindowChangeScheduled = false
},
TimeScheduledMaintenanceWindowUpdate = DateTime.Parse("01/12/2000 06:40:40"),
IsBackupRetentionLocked = true,
TimeScheduledDbVersionUpgrade = DateTime.Parse("10/17/2049 06:03:03"),
IsDisableDbVersionUpgradeSchedule = false,
IsScheduleDbVersionUpgradeToEarliest = true,
ScheduledOperations = new List<Oci.DatabaseService.Models.ScheduledOperationDetails>
{
new Oci.DatabaseService.Models.ScheduledOperationDetails
{
DayOfWeek = new Oci.DatabaseService.Models.DayOfWeek
{
Name = Oci.DatabaseService.Models.DayOfWeek.NameEnum.Tuesday
},
ScheduledStartTime = "EXAMPLE-scheduledStartTime-Value",
ScheduledStopTime = "EXAMPLE-scheduledStopTime-Value"
}
},
IsAutoScalingForStorageEnabled = false,
DatabaseEdition = Oci.DatabaseService.Models.AutonomousDatabaseSummary.DatabaseEditionEnum.EnterpriseEdition,
DbToolsDetails = new List<Oci.DatabaseService.Models.DatabaseTool>
{
new Oci.DatabaseService.Models.DatabaseTool
{
Name = Oci.DatabaseService.Models.DatabaseTool.NameEnum.SpatialStudio,
IsEnabled = false,
ComputeCount = (float)4060.3525,
MaxIdleTimeInMinutes = 648
}
},
VanityUrlDetails = new Oci.DatabaseService.Models.VanityUrlDetails
{
IsDisabled = false,
ApiGatewayId = "ocid1.test.oc1..<unique_ID>EXAMPLE-apiGatewayId-Value",
VanityUrlHostName = "EXAMPLE-vanityUrlHostName-Value"
},
SecretId = "ocid1.test.oc1..<unique_ID>EXAMPLE-secretId-Value",
SecretVersionNumber = 21,
EncryptionKey = new Oci.DatabaseService.Models.AzureKeyDetails
{
VaultUri = "EXAMPLE-vaultUri-Value",
KeyName = "EXAMPLE-keyName-Value"
},
IsDisconnectPeer = true,
LocalAdgResourcePoolLeaderId = "ocid1.test.oc1..<unique_ID>EXAMPLE-localAdgResourcePoolLeaderId-Value"
};
var updateAutonomousDatabaseRequest = new Oci.DatabaseService.Requests.UpdateAutonomousDatabaseRequest
{
AutonomousDatabaseId = "ocid1.test.oc1..<unique_ID>EXAMPLE-autonomousDatabaseId-Value",
UpdateAutonomousDatabaseDetails = updateAutonomousDatabaseDetails,
IfMatch = "EXAMPLE-ifMatch-Value",
OpcRequestId = "TMMLIIEU8EKNIG1PFL4L<unique_ID>",
OpcDryRun = true
};
// Create a default authentication provider that uses the DEFAULT
// profile in the configuration file.
// Refer to <see href="https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File>the public documentation</see> on how to prepare a configuration file.
var provider = new ConfigFileAuthenticationDetailsProvider("DEFAULT");
try
{
// Create a service client and send the request.
using (var client = new DatabaseClient(provider, new ClientConfiguration()))
{
var response = await client.UpdateAutonomousDatabase(updateAutonomousDatabaseRequest);
// Retrieve value from the response.
var id = response.AutonomousDatabase.Id;
}
}
catch (Exception e)
{
Console.WriteLine($"UpdateAutonomousDatabase Failed with {e.Message}");
throw e;
}
}
}
}