--- title: "POST /v1/{+parent}/autonomousDatabases" method: POST path: "/v1/{+parent}/autonomousDatabases" tags: ["projects"] --- # POST /v1/{+parent}/autonomousDatabases `POST /v1/{+parent}/autonomousDatabases` Creates a new Autonomous Database in a given project and location. ## Path parameters - `parent` string, required ## Query parameters - `autonomousDatabaseId` string - `requestId` string ## Request body - AutonomousDatabase — Details of the Autonomous Database resource. https://docs.oracle.com/en-us/iaas/api/#/en/database/20160918/AutonomousDatabase/ - `network` string — Optional. Immutable. The name of the VPC network used by the Autonomous Database in the following format: projects/{project}/global/networks/{network} - `peerAutonomousDatabases` string[] — Output only. The peer Autonomous Database names of the given Autonomous Database. - `odbSubnet` string — Optional. Immutable. The name of the OdbSubnet associated with the Autonomous Database. Format: projects/{project}/locations/{location}/odbNetworks/{odb_network}/odbSubnets/{odb_subnet} - `database` string — Optional. Immutable. The name of the Autonomous Database. The database name must be unique in the project. The name must begin with a letter and can contain a maximum of 30 alphanumeric characters. - `sourceConfig` SourceConfig — The source configuration for the standby Autonomous Database. - `refreshableMode` 'REFRESHABLE_MODE_UNSPECIFIED' | 'AUTOMATIC' | 'MANUAL' — Optional. The refresh mode of the clone. - `cloneType` 'CLONE_TYPE_UNSPECIFIED' | 'FULL' | 'METADATA' — Optional. The clone type of the Autonomous Database. This field is only applicable in case of cloning - `autonomousDatabase` string — Optional. The name of the primary Autonomous Database that is used to create a Peer Autonomous Database from a source. - `autoRefreshPointLagSeconds` integer — Optional. The time, in seconds, the data of the automatic refreshable clone lags the primary database at the point of refresh. - `useLatestAvailableBackup` boolean — Optional. Clone from latest available backup timestamp. This field is only applicable in case of BACKUP_FROM_TIMESTAMP source type. - `backupTime` string, google-datetime — Optional. The timestamp specified for the point-in-time clone of the source Autonomous Database. This field is only applicable in case of BACKUP_FROM_TIMESTAMP source type and when use_latest_available_backup is false. - `automaticBackupsReplicationEnabled` boolean — Optional. This field specifies if the replication of automatic backups is enabled when creating a Data Guard. - `autonomousDatabaseBackup` string — Optional. The name of the Autonomous Database Backup resource with the format: projects/{project}/locations/{region}/autonomousDatabaseBackups/{autonomous_database_backup} Required when source_type is BACKUP_FROM_ID. - `autoRefreshStartTime` string, google-datetime — Optional. The date and time that auto-refreshing will begin for an Autonomous Database refreshable clone. This value controls only the start time for the first refresh operation. - `autoRefreshFrequencySeconds` integer — Optional. The frequency in seconds a refreshable clone is refreshed after auto-refresh is enabled. - `sourceType` 'SOURCE_TYPE_UNSPECIFIED' | 'CLONE_DATABASE' | 'CROSS_REGION_DISASTER_RECOVERY' | 'CLONE_TO_REFRESHABLE' | 'BACKUP_FROM_ID' | 'BACKUP_FROM_TIMESTAMP' — Optional. The source type of the Autonomous Database. - `odbNetwork` string — Optional. Immutable. The name of the OdbNetwork associated with the Autonomous Database. Format: projects/{project}/locations/{location}/odbNetworks/{odb_network} It is optional but if specified, this should match the parent ODBNetwork of the OdbSubnet. - `createTime` string, google-datetime — Output only. The date and time that the Autonomous Database was created. - `adminPassword` string — Optional. Immutable. The password for the default ADMIN user. Note: Only one of `admin_password_secret_version` or `admin_password` can be populated. - `cidr` string — Optional. Immutable. The subnet CIDR range for the Autonomous Database. - `disasterRecoverySupportedLocations` string[] — Output only. List of supported GCP region to clone the Autonomous Database for disaster recovery. Format: `project/{project}/locations/{location}`. - `adminPasswordSecretVersion` string — Optional. Immutable. The resource name of a secret version in Secret Manager which contains the database admin user's password. Format: projects/{project}/secrets/{secret}/versions/{version}. Note: Only one of `admin_password_secret_version` or `admin_password` can be populated. - `displayName` string — Optional. Immutable. The display name for the Autonomous Database. The name does not have to be unique within your project. - `properties` AutonomousDatabaseProperties — The properties of an Autonomous Database. - `dbVersion` string — Optional. Immutable. The Oracle Database version for the Autonomous Database. - `refreshableState` 'REFRESHABLE_STATE_UNSPECIFIED' | 'REFRESHING' | 'NOT_REFRESHING' — Output only. The refresh State of the clone. - `connectionUrls` AutonomousDatabaseConnectionUrls — The URLs for accessing Oracle Application Express (APEX) and SQL Developer Web with a browser from a Compute instance. https://docs.oracle.com/en-us/iaas/api/#/en/database/20160918/datatypes/AutonomousDatabaseConnectionUrls - `apexUri` string — Output only. Oracle Application Express (APEX) URL. - `graphStudioUri` string — Output only. The URL of the Graph Studio for the Autonomous Database. - `machineLearningUserManagementUri` string — Output only. The URL of Machine Learning user management the Autonomous Database. - `mongoDbUri` string — Output only. The URL of the MongoDB API for the Autonomous Database. - `machineLearningNotebookUri` string — Output only. The URL of the Oracle Machine Learning (OML) Notebook for the Autonomous Database. - `ordsUri` string — Output only. The Oracle REST Data Services (ORDS) URL of the Web Access for the Autonomous Database. - `sqlDevWebUri` string — Output only. The URL of the Oracle SQL Developer Web for the Autonomous Database. - `databaseTransformsUri` string — Output only. The URL of the Database Transforms for the Autonomous Database. - `autonomousContainerDatabaseId` string — Output only. The Autonomous Container Database OCID. - `connectionStrings` AutonomousDatabaseConnectionStrings — The connection string used to connect to the Autonomous Database. https://docs.oracle.com/en-us/iaas/api/#/en/database/20160918/datatypes/AutonomousDatabaseConnectionStrings - `profiles` DatabaseConnectionStringProfile[] — Output only. A list of connection string profiles to allow clients to group, filter, and select values based on the structured metadata. - `displayName` string — Output only. The display name for the database connection. - `sessionMode` 'SESSION_MODE_UNSPECIFIED' | 'DIRECT' | 'INDIRECT' — Output only. The current session mode of the connection. - `syntaxFormat` 'SYNTAX_FORMAT_UNSPECIFIED' | 'LONG' | 'EZCONNECT' | 'EZCONNECTPLUS' — Output only. The syntax of the connection string. - `hostFormat` 'HOST_FORMAT_UNSPECIFIED' | 'FQDN' | 'IP' — Output only. The host name format being currently used in connection string. - `consumerGroup` 'CONSUMER_GROUP_UNSPECIFIED' | 'HIGH' | 'MEDIUM' | 'LOW' | 'TP' | 'TPURGENT' — Output only. The current consumer group being used by the connection. - `tlsAuthentication` 'TLS_AUTHENTICATION_UNSPECIFIED' | 'SERVER' | 'MUTUAL' — Output only. This field indicates the TLS authentication type of the connection. - `protocol` 'PROTOCOL_UNSPECIFIED' | 'TCP' | 'TCPS' — Output only. The protocol being used by the connection. - `value` string — Output only. The value of the connection string. - `isRegional` boolean — Output only. This field indicates if the connection string is regional and is only applicable for cross-region Data Guard. - `allConnectionStrings` AllConnectionStrings — A list of all connection strings that can be used to connect to the Autonomous Database. - `high` string — Output only. The database service provides the highest level of resources to each SQL statement. - `low` string — Output only. The database service provides the least level of resources to each SQL statement. - `medium` string — Output only. The database service provides a lower level of resources to each SQL statement. - `high` string — Output only. The database service provides the highest level of resources to each SQL statement. - `low` string — Output only. The database service provides the least level of resources to each SQL statement. - `medium` string — Output only. The database service provides a lower level of resources to each SQL statement. - `dedicated` string — Output only. The database service provides the least level of resources to each SQL statement, but supports the most number of concurrent SQL statements. - `dbEdition` 'DATABASE_EDITION_UNSPECIFIED' | 'STANDARD_EDITION' | 'ENTERPRISE_EDITION' — Optional. Immutable. The edition of the Autonomous Databases. - `lifecycleDetails` string — Output only. The details of the current lifestyle state of the Autonomous Database. - `allocatedStorageSizeTb` number, double — Output only. The amount of storage currently allocated for the database tables and billed for, rounded up in terabytes. - `permissionLevel` 'PERMISSION_LEVEL_UNSPECIFIED' | 'RESTRICTED' | 'UNRESTRICTED' — Output only. The permission level of the Autonomous Database. - `memoryPerOracleComputeUnitGbs` integer — Output only. The amount of memory enabled per ECPU, in gigabytes. - `localStandbyDb` AutonomousDatabaseStandbySummary — Autonomous Data Guard standby database details. https://docs.oracle.com/en-us/iaas/api/#/en/database/20160918/datatypes/AutonomousDatabaseStandbySummary - `disasterRecoveryRoleChangedTime` string, google-datetime — Output only. The date and time the Disaster Recovery role was switched for the standby Autonomous Database. - `dataGuardRoleChangedTime` string, google-datetime — Output only. The date and time the Autonomous Data Guard role was switched for the standby Autonomous Database. - `lifecycleDetails` string — Output only. The additional details about the current lifecycle state of the Autonomous Database. - `lagTimeDuration` string, google-duration — Output only. The amount of time, in seconds, that the data of the standby database lags in comparison to the data of the primary database. - `state` 'STATE_UNSPECIFIED' | 'PROVISIONING' | 'AVAILABLE' | 'STOPPING' | 'STOPPED' | 'STARTING' | 'TERMINATING' | 'TERMINATED' | 'UNAVAILABLE' | 'RESTORE_IN_PROGRESS' | 'RESTORE_FAILED' | 'BACKUP_IN_PROGRESS' | 'SCALE_IN_PROGRESS' | 'AVAILABLE_NEEDS_ATTENTION' | 'UPDATING' | 'MAINTENANCE_IN_PROGRESS' | 'RESTARTING' | 'RECREATING' | 'ROLE_CHANGE_IN_PROGRESS' | 'UPGRADING' | 'INACCESSIBLE' | 'STANDBY' — Output only. The current lifecycle state of the Autonomous Database. - `supportedCloneRegions` string[] — Output only. The list of available regions that can be used to create a clone for the Autonomous Database. - `isStorageAutoScalingEnabled` boolean — Optional. Immutable. This field indicates if auto scaling is enabled for the Autonomous Database storage. - `disasterRecoveryRoleChangedTime` string, google-datetime — Output only. The date and time the Disaster Recovery role was changed for the standby Autonomous Database. - `localAdgAutoFailoverMaxDataLossLimitDuration` integer — Optional. This field indicates the maximum data loss limit for an Autonomous Database, in seconds. - `memoryTableGbs` integer — Output only. The memory assigned to in-memory tables in an Autonomous Database. - `dbWorkload` 'DB_WORKLOAD_UNSPECIFIED' | 'OLTP' | 'DW' | 'AJD' | 'APEX' — Required. Immutable. The workload type of the Autonomous Database. - `serviceAgentEmail` string — Output only. An Oracle-managed Google Cloud service account on which customers can grant roles to access resources in the customer project. - `dataGuardRoleChangedTime` string, google-datetime — Output only. The date and time the Autonomous Data Guard role was changed for the standby Autonomous Database. - `localDisasterRecoveryType` 'LOCAL_DISASTER_RECOVERY_TYPE_UNSPECIFIED' | 'ADG' | 'BACKUP_BASED' | 'NOT_AVAILABLE' — Output only. This field indicates the local disaster recovery (DR) type of an Autonomous Database. - `secretId` string — Optional. Immutable. The ID of the Oracle Cloud Infrastructure vault secret. - `ocid` string — Output only. OCID of the Autonomous Database. https://docs.oracle.com/en-us/iaas/Content/General/Concepts/identifiers.htm#Oracle - `operationsInsightsState` 'OPERATIONS_INSIGHTS_STATE_UNSPECIFIED' | 'ENABLING' | 'ENABLED' | 'DISABLING' | 'NOT_ENABLED' | 'FAILED_ENABLING' | 'FAILED_DISABLING' — Output only. This field indicates the state of Operations Insights for the Autonomous Database. - `characterSet` string — Optional. Immutable. The character set for the Autonomous Database. The default is AL32UTF8. - `vaultId` string — Optional. Immutable. The ID of the Oracle Cloud Infrastructure vault. - `refreshableClone` boolean — Optional. Indicates if the Autonomous Database is a refreshable clone. This field is used in update flow to connect / disconnect a refreshable clone from its source database. - `scheduledOperationDetails` ScheduledOperationDetails[] — Output only. The list and details of the scheduled operations of the Autonomous Database. - `dayOfWeek` 'DAY_OF_WEEK_UNSPECIFIED' | 'MONDAY' | 'TUESDAY' | 'WEDNESDAY' | 'THURSDAY' | 'FRIDAY' | 'SATURDAY' | 'SUNDAY' — Output only. Day of week. - `stopTime` TimeOfDay — Represents a time of day. The date and time zone are either not significant or are specified elsewhere. An API may choose to allow leap seconds. Related types are google.type.Date and `google.protobuf.Timestamp`. - `minutes` integer — Minutes of an hour. Must be greater than or equal to 0 and less than or equal to 59. - `nanos` integer — Fractions of seconds, in nanoseconds. Must be greater than or equal to 0 and less than or equal to 999,999,999. - `hours` integer — Hours of a day in 24 hour format. Must be greater than or equal to 0 and typically must be less than or equal to 23. An API may choose to allow the value "24:00:00" for scenarios like business closing time. - `seconds` integer — Seconds of a minute. Must be greater than or equal to 0 and typically must be less than or equal to 59. An API may allow the value 60 if it allows leap-seconds. - `startTime` TimeOfDay — Represents a time of day. The date and time zone are either not significant or are specified elsewhere. An API may choose to allow leap seconds. Related types are google.type.Date and `google.protobuf.Timestamp`. - `minutes` integer — Minutes of an hour. Must be greater than or equal to 0 and less than or equal to 59. - `nanos` integer — Fractions of seconds, in nanoseconds. Must be greater than or equal to 0 and less than or equal to 999,999,999. - `hours` integer — Hours of a day in 24 hour format. Must be greater than or equal to 0 and typically must be less than or equal to 23. An API may choose to allow the value "24:00:00" for scenarios like business closing time. - `seconds` integer — Seconds of a minute. Must be greater than or equal to 0 and typically must be less than or equal to 59. An API may allow the value 60 if it allows leap-seconds. - `nextLongTermBackupTime` string, google-datetime — Output only. The long term backup schedule of the Autonomous Database. - `actualUsedDataStorageSizeTb` number, double — Output only. The amount of storage currently being used for user and system data, in terabytes. - `localAdgAutoFailoverMaxDataLossLimit` integer — Output only. Deprecated: Please use `local_adg_auto_failover_max_data_loss_limit_duration` instead. This field indicates the maximum data loss limit for an Autonomous Database, in seconds. - `maintenanceBeginTime` string, google-datetime — Output only. The date and time when maintenance will begin. - `customerContacts` CustomerContact[] — Optional. Immutable. The list of customer contacts. - `email` string — Required. The email address used by Oracle to send notifications regarding databases and infrastructure. - `isLocalDataGuardEnabled` boolean — Output only. Deprecated: Please use `local_data_guard_enabled` instead. This field indicates whether the Autonomous Database has local (in-region) Data Guard enabled. - `maintenanceEndTime` string, google-datetime — Output only. The date and time when maintenance will end. - `encryptionKeyHistoryEntries` EncryptionKeyHistoryEntry[] — Output only. The history of the encryption keys used to encrypt the Autonomous Database. - `encryptionKey` EncryptionKey — The encryption key used to encrypt the Autonomous Database. - `provider` 'PROVIDER_UNSPECIFIED' | 'GOOGLE_MANAGED' | 'ORACLE_MANAGED' — Optional. The provider of the encryption key. - `kmsKey` string — Optional. The KMS key used to encrypt the Autonomous Database. This field is required if the provider is GOOGLE_MANAGED. The name of the KMS key resource in the following format: `projects/{project}/locations/{location}/keyRings/{key_ring}/cryptoKeys/{crypto_key}`. - `activationTime` string, google-datetime — Output only. The date and time when the encryption key was activated on the Autonomous Database.. - `state` 'STATE_UNSPECIFIED' | 'PROVISIONING' | 'AVAILABLE' | 'STOPPING' | 'STOPPED' | 'STARTING' | 'TERMINATING' | 'TERMINATED' | 'UNAVAILABLE' | 'RESTORE_IN_PROGRESS' | 'RESTORE_FAILED' | 'BACKUP_IN_PROGRESS' | 'SCALE_IN_PROGRESS' | 'AVAILABLE_NEEDS_ATTENTION' | 'UPDATING' | 'MAINTENANCE_IN_PROGRESS' | 'RESTARTING' | 'RECREATING' | 'ROLE_CHANGE_IN_PROGRESS' | 'UPGRADING' | 'INACCESSIBLE' | 'STANDBY' — Output only. The current lifecycle state of the Autonomous Database. - `sqlWebDeveloperUrl` string — Output only. The SQL Web Developer URL for the Autonomous Database. - `mtlsConnectionRequired` boolean — Optional. Immutable. This field specifies if the Autonomous Database requires mTLS connections. - `isAutoScalingEnabled` boolean — Optional. Immutable. This field indicates if auto scaling is enabled for the Autonomous Database CPU core count. - `totalAutoBackupStorageSizeGbs` number, float — Output only. The storage space used by automatic backups of Autonomous Database, in gigabytes. - `allowlistedIps` string[] — Optional. Immutable. The list of allowlisted IP addresses for the Autonomous Database. - `databaseManagementState` 'DATABASE_MANAGEMENT_STATE_UNSPECIFIED' | 'ENABLING' | 'ENABLED' | 'DISABLING' | 'NOT_ENABLED' | 'FAILED_ENABLING' | 'FAILED_DISABLING' — Output only. The current state of database management for the Autonomous Database. - `refreshableMode` 'REFRESHABLE_MODE_UNSPECIFIED' | 'AUTOMATIC' | 'MANUAL' — Output only. The refresh mode of the cloned Autonomous Database. - `cpuCoreCount` integer — Optional. Immutable. The number of CPU cores to be made available to the database. - `dataSafeState` 'DATA_SAFE_STATE_UNSPECIFIED' | 'REGISTERING' | 'REGISTERED' | 'DEREGISTERING' | 'NOT_REGISTERED' | 'FAILED' — Output only. The current state of the Data Safe registration for the Autonomous Database. - `arePrimaryAllowlistedIpsUsed` boolean — Output only. This field indicates the status of Data Guard and Access control for the Autonomous Database. The field's value is null if Data Guard is disabled or Access Control is disabled. The field's value is TRUE if both Data Guard and Access Control are enabled, and the Autonomous Database is using primary IP access control list (ACL) for standby. The field's value is FALSE if both Data Guard and Access Control are enabled, and the Autonomous Database is using a different IP access control list (ACL) for standby compared to primary. - `failedDataRecoveryDuration` string, google-duration — Output only. This field indicates the number of seconds of data loss during a Data Guard failover. - `privateEndpoint` string — Output only. The private endpoint for the Autonomous Database. - `backupRetentionPeriodDays` integer — Optional. Immutable. The retention period for the Autonomous Database. This field is specified in days, can range from 1 day to 60 days, and has a default value of 60 days. - `encryptionKey` EncryptionKey — The encryption key used to encrypt the Autonomous Database. - `provider` 'PROVIDER_UNSPECIFIED' | 'GOOGLE_MANAGED' | 'ORACLE_MANAGED' — Optional. The provider of the encryption key. - `kmsKey` string — Optional. The KMS key used to encrypt the Autonomous Database. This field is required if the provider is GOOGLE_MANAGED. The name of the KMS key resource in the following format: `projects/{project}/locations/{location}/keyRings/{key_ring}/cryptoKeys/{crypto_key}`. - `ociUrl` string — Output only. The Oracle Cloud Infrastructure link for the Autonomous Database. - `licenseType` 'LICENSE_TYPE_UNSPECIFIED' | 'LICENSE_INCLUDED' | 'BRING_YOUR_OWN_LICENSE' — Required. Immutable. The license type used for the Autonomous Database. - `computeCount` number, float — Optional. Immutable. The number of compute servers for the Autonomous Database. - `nCharacterSet` string — Optional. Immutable. The national character set for the Autonomous Database. The default is AL16UTF16. - `dataStorageSizeTb` integer — Optional. Immutable. The size of the data stored in the database, in terabytes. - `usedDataStorageSizeTbs` integer — Output only. The storage space used by Autonomous Database, in gigabytes. - `maintenanceScheduleType` 'MAINTENANCE_SCHEDULE_TYPE_UNSPECIFIED' | 'EARLY' | 'REGULAR' — Optional. Immutable. The maintenance schedule of the Autonomous Database. - `privateEndpointIp` string — Optional. Immutable. The private endpoint IP address for the Autonomous Database. - `availableUpgradeVersions` string[] — Output only. The list of available Oracle Database upgrade versions for an Autonomous Database. - `role` 'ROLE_UNSPECIFIED' | 'PRIMARY' | 'STANDBY' | 'DISABLED_STANDBY' | 'BACKUP_COPY' | 'SNAPSHOT_STANDBY' — Output only. The Data Guard role of the Autonomous Database. - `openMode` 'OPEN_MODE_UNSPECIFIED' | 'READ_ONLY' | 'READ_WRITE' — Output only. This field indicates the current mode of the Autonomous Database. - `peerDbIds` string[] — Output only. The list of OCIDs of standby databases located in Autonomous Data Guard remote regions that are associated with the source database. - `dataStorageSizeGb` integer — Optional. Immutable. The size of the data stored in the database, in gigabytes. - `privateEndpointLabel` string — Optional. Immutable. The private endpoint label for the Autonomous Database. - `localDataGuardEnabled` boolean — Optional. Indicates whether the Autonomous Database has a local (in-region) standby database. Not applicable to cross-region Data Guard or dedicated Exadata infrastructure. - `apexDetails` AutonomousDatabaseApex — Oracle APEX Application Development. https://docs.oracle.com/en-us/iaas/api/#/en/database/20160918/datatypes/AutonomousDatabaseApex - `apexVersion` string — Output only. The Oracle APEX Application Development version. - `ordsVersion` string — Output only. The Oracle REST Data Services (ORDS) version. - `entitlementId` string — Output only. The ID of the subscription entitlement associated with the Autonomous Database. - `labels` object — Optional. The labels or tags associated with the Autonomous Database. - `name` string — Identifier. The name of the Autonomous Database resource in the following format: projects/{project}/locations/{region}/autonomousDatabases/{autonomous_database} ## Response `200` Successful response --- [API](https://skmtc.net/google/apis/oracledatabase.md) · [All operations](https://skmtc.net/google/apis/oracledatabase/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/google/oracledatabase/versions/120ce7891e09/schema)