// 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 = 530,
ComputeModel = Oci.DatabaseService.Models.UpdateAutonomousDatabaseDetails.ComputeModelEnum.Ocpu,
InMemoryPercentage = 309,
LocalAdgAutoFailoverMaxDataLossLimit = 2546,
CpuCoreCount = 103,
LongTermBackupSchedule = new Oci.DatabaseService.Models.LongTermBackUpScheduleDetails
{
RepeatCadence = Oci.DatabaseService.Models.LongTermBackUpScheduleDetails.RepeatCadenceEnum.Weekly,
TimeOfBackup = DateTime.Parse("10/10/2031 05:33:05"),
RetentionPeriodInDays = 694,
IsDisabled = true
},
IsDevTier = false,
ComputeCount = (float)3758.6226,
OcpuCount = (float)5189.25,
DataStorageSizeInTBs = 74,
DataStorageSizeInGBs = 60042,
DisplayName = "EXAMPLE-displayName-Value",
IsFreeTier = true,
AvailabilityDomain = "EXAMPLE-availabilityDomain-Value",
TimeScheduledAdUpdate = DateTime.Parse("03/07/2022 17:33:26"),
IsDisableAdUpdateSchedule = true,
IsScheduleAdUpdateToEarliest = false,
AdminPassword = "EXAMPLE-adminPassword-Value",
DbName = "EXAMPLE-dbName-Value",
FreeformTags = new Dictionary<string, string>()
{
{
"EXAMPLE_KEY_0UWJo",
"EXAMPLE_VALUE_2I9L69AybWaPkVqOFvRu"
}
},
DefinedTags = new Dictionary<string, Dictionary<string, Object>>()
{
{
"EXAMPLE_KEY_Y1pGx",
new Dictionary<string, Object>()
{
{
"EXAMPLE_KEY_61yDA",
"EXAMPLE--Value"
}
}
}
},
SecurityAttributes = new Dictionary<string, Dictionary<string, Object>>()
{
{
"EXAMPLE_KEY_rfaBh",
new Dictionary<string, Object>()
{
{
"EXAMPLE_KEY_zMfP7",
"EXAMPLE--Value"
}
}
}
},
DbWorkload = Oci.DatabaseService.Models.UpdateAutonomousDatabaseDetails.DbWorkloadEnum.Lh,
LicenseModel = Oci.DatabaseService.Models.UpdateAutonomousDatabaseDetails.LicenseModelEnum.LicenseIncluded,
ByolComputeCountLimit = (float)3445.069,
IsAccessControlEnabled = true,
WhitelistedIps = new List<string>
{
"EXAMPLE--Value"
},
ArePrimaryWhitelistedIpsUsed = true,
StandbyWhitelistedIps = new List<string>
{
"EXAMPLE--Value"
},
IsAutoScalingEnabled = true,
IsRefreshableClone = false,
RefreshableMode = Oci.DatabaseService.Models.UpdateAutonomousDatabaseDetails.RefreshableModeEnum.Manual,
IsLocalDataGuardEnabled = true,
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.Unrestricted,
SubnetId = "ocid1.test.oc1..<unique_ID>EXAMPLE-subnetId-Value",
PrivateEndpointLabel = "EXAMPLE-privateEndpointLabel-Value",
PrivateEndpointIp = "EXAMPLE-privateEndpointIp-Value",
NsgIds = new List<string>
{
"EXAMPLE--Value"
},
AutoRefreshFrequencyInSeconds = 18909,
AutoRefreshPointLagInSeconds = 99921,
TimeOfAutoRefreshStart = DateTime.Parse("12/16/2018 05:00:20"),
CustomerContacts = new List<Oci.DatabaseService.Models.CustomerContact>
{
new Oci.DatabaseService.Models.CustomerContact
{
Email = "EXAMPLE-email-Value"
}
},
IsMtlsConnectionRequired = false,
ResourcePoolLeaderId = "ocid1.test.oc1..<unique_ID>EXAMPLE-resourcePoolLeaderId-Value",
ResourcePoolSummary = new Oci.DatabaseService.Models.ResourcePoolSummary
{
PoolSize = 20,
PoolStorageSizeInTBs = 512,
AvailableStorageCapacityInTBs = 1135.3403,
TotalComputeCapacity = 876,
AvailableComputeCapacity = 176,
IsDisabled = false
},
AutonomousMaintenanceScheduleType = Oci.DatabaseService.Models.UpdateAutonomousDatabaseDetails.AutonomousMaintenanceScheduleTypeEnum.Early,
AutonomousDatabaseMaintenanceWindow = new Oci.DatabaseService.Models.AutonomousDatabaseMaintenanceWindowSummary
{
DayOfWeek = new Oci.DatabaseService.Models.DayOfWeek
{
Name = Oci.DatabaseService.Models.DayOfWeek.NameEnum.Friday
},
MaintenanceStartTime = "EXAMPLE-maintenanceStartTime-Value",
MaintenanceEndTime = "EXAMPLE-maintenanceEndTime-Value",
AvailabilityDomain = "EXAMPLE-availabilityDomain-Value",
IsMaintenanceWindowChangeScheduled = true
},
TimeMaintenancePauseUntil = DateTime.Parse("07/26/2014 22:51:23"),
ScheduledMaintenanceWindow = new Oci.DatabaseService.Models.AutonomousDatabaseMaintenanceWindowSummary
{
DayOfWeek = new Oci.DatabaseService.Models.DayOfWeek
{
Name = Oci.DatabaseService.Models.DayOfWeek.NameEnum.Tuesday
},
MaintenanceStartTime = "EXAMPLE-maintenanceStartTime-Value",
MaintenanceEndTime = "EXAMPLE-maintenanceEndTime-Value",
AvailabilityDomain = "EXAMPLE-availabilityDomain-Value",
IsMaintenanceWindowChangeScheduled = false
},
TimeScheduledMaintenanceWindowUpdate = DateTime.Parse("04/24/2019 01:40:36"),
IsBackupRetentionLocked = false,
TimeScheduledDbVersionUpgrade = DateTime.Parse("11/03/2024 08:49:09"),
IsDisableDbVersionUpgradeSchedule = false,
IsScheduleDbVersionUpgradeToEarliest = false,
ScheduledOperations = new List<Oci.DatabaseService.Models.ScheduledOperationDetails>
{
new Oci.DatabaseService.Models.ScheduledOperationDetails
{
DayOfWeek = new Oci.DatabaseService.Models.DayOfWeek
{
Name = Oci.DatabaseService.Models.DayOfWeek.NameEnum.Sunday
},
ScheduledStartTime = "EXAMPLE-scheduledStartTime-Value",
ScheduledStopTime = "EXAMPLE-scheduledStopTime-Value"
}
},
IsAutoScalingForStorageEnabled = false,
DatabaseEdition = Oci.DatabaseService.Models.AutonomousDatabaseSummary.DatabaseEditionEnum.StandardEdition,
DbToolsDetails = new List<Oci.DatabaseService.Models.DatabaseTool>
{
new Oci.DatabaseService.Models.DatabaseTool
{
Name = Oci.DatabaseService.Models.DatabaseTool.NameEnum.DataTransforms,
IsEnabled = true,
ComputeCount = (float)4246.434,
MaxIdleTimeInMinutes = 304
}
},
VanityUrlDetails = new Oci.DatabaseService.Models.VanityUrlDetails
{
IsDisabled = true,
ApiGatewayId = "ocid1.test.oc1..<unique_ID>EXAMPLE-apiGatewayId-Value",
VanityUrlHostName = "EXAMPLE-vanityUrlHostName-Value"
},
SecretId = "ocid1.test.oc1..<unique_ID>EXAMPLE-secretId-Value",
SecretVersionNumber = 30,
EncryptionKey = new Oci.DatabaseService.Models.OracleManagedKeyDetails
{
},
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 = "58WKDNBGOXY0AFW0KLJT<unique_ID>",
OpcDryRun = false
};
// 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;
}
}
}
}