autonomous_databases

Creates, updates, deletes, gets or lists a autonomous_databases resource.

Overview

Name	autonomous_databases
Type	Resource
Id	azure_isv.oracle.autonomous_databases

Fields

vw_autonomous_databases

Name	Datatype	Description
actual_used_data_storage_size_in_tbs	text	field from the properties object
admin_password	text	field from the properties object
allocated_storage_size_in_tbs	text	field from the properties object
apex_details	text	field from the properties object
autonomous_database_id	text	field from the properties object
autonomous_maintenance_schedule_type	text	field from the properties object
autonomousdatabasename	text	field from the properties object
available_upgrade_versions	text	field from the properties object
backup_retention_period_in_days	text	field from the properties object
character_set	text	field from the properties object
compute_count	text	field from the properties object
compute_model	text	field from the properties object
connection_strings	text	field from the properties object
connection_urls	text	field from the properties object
cpu_core_count	text	field from the properties object
customer_contacts	text	field from the properties object
data_base_type	text	field from the properties object
data_safe_status	text	field from the properties object
data_storage_size_in_gbs	text	field from the properties object
data_storage_size_in_tbs	text	field from the properties object
database_edition	text	field from the properties object
db_version	text	field from the properties object
db_workload	text	field from the properties object
display_name	text	field from the properties object
failed_data_recovery_in_seconds	text	field from the properties object
in_memory_area_in_gbs	text	field from the properties object
is_auto_scaling_enabled	text	field from the properties object
is_auto_scaling_for_storage_enabled	text	field from the properties object
is_local_data_guard_enabled	text	field from the properties object
is_mtls_connection_required	text	field from the properties object
is_preview	text	field from the properties object
is_preview_version_with_service_terms_accepted	text	field from the properties object
is_remote_data_guard_enabled	text	field from the properties object
license_model	text	field from the properties object
lifecycle_details	text	field from the properties object
lifecycle_state	text	field from the properties object
local_adg_auto_failover_max_data_loss_limit	text	field from the properties object
local_disaster_recovery_type	text	field from the properties object
local_standby_db	text	field from the properties object
location	text	The geo-location where the resource lives
long_term_backup_schedule	text	field from the properties object
memory_per_oracle_compute_unit_in_gbs	text	field from the properties object
ncharacter_set	text	field from the properties object
next_long_term_backup_time_stamp	text	field from the properties object
oci_url	text	field from the properties object
ocid	text	field from the properties object
open_mode	text	field from the properties object
operations_insights_status	text	field from the properties object
peer_db_id	text	field from the properties object
peer_db_ids	text	field from the properties object
permission_level	text	field from the properties object
private_endpoint	text	field from the properties object
private_endpoint_ip	text	field from the properties object
private_endpoint_label	text	field from the properties object
provisionable_cpus	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
role	text	field from the properties object
scheduled_operations	text	field from the properties object
service_console_url	text	field from the properties object
sql_web_developer_url	text	field from the properties object
subnet_id	text	field from the properties object
subscriptionId	text	field from the properties object
supported_regions_to_clone_to	text	field from the properties object
tags	text	Resource tags.
time_created	text	field from the properties object
time_data_guard_role_changed	text	field from the properties object
time_deletion_of_free_autonomous_database	text	field from the properties object
time_local_data_guard_enabled	text	field from the properties object
time_maintenance_begin	text	field from the properties object
time_maintenance_end	text	field from the properties object
time_of_last_failover	text	field from the properties object
time_of_last_refresh	text	field from the properties object
time_of_last_refresh_point	text	field from the properties object
time_of_last_switchover	text	field from the properties object
time_reclamation_of_free_autonomous_database	text	field from the properties object
used_data_storage_size_in_gbs	text	field from the properties object
used_data_storage_size_in_tbs	text	field from the properties object
vnet_id	text	field from the properties object
whitelisted_ips	text	field from the properties object

autonomous_databases

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Autonomous Database base resource model.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	autonomousdatabasename, resourceGroupName, subscriptionId	Get a AutonomousDatabase
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List AutonomousDatabase resources by resource group
list_by_subscription	SELECT	subscriptionId	List AutonomousDatabase resources by subscription ID
create_or_update	INSERT	autonomousdatabasename, resourceGroupName, subscriptionId	Create a AutonomousDatabase
delete	DELETE	autonomousdatabasename, resourceGroupName, subscriptionId	Delete a AutonomousDatabase
update	UPDATE	autonomousdatabasename, resourceGroupName, subscriptionId	Update a AutonomousDatabase
failover	EXEC	autonomousdatabasename, resourceGroupName, subscriptionId	Perform failover action on Autonomous Database
generate_wallet	EXEC	autonomousdatabasename, resourceGroupName, subscriptionId, data__password	Generate wallet action on Autonomous Database
restore	EXEC	autonomousdatabasename, resourceGroupName, subscriptionId, data__timestamp	Restores an Autonomous Database based on the provided request parameters.
shrink	EXEC	autonomousdatabasename, resourceGroupName, subscriptionId	This operation shrinks the current allocated storage down to the current actual used data storage.
switchover	EXEC	autonomousdatabasename, resourceGroupName, subscriptionId	Perform switchover action on Autonomous Database

SELECT examples

List AutonomousDatabase resources by subscription ID

vw_autonomous_databases

SELECT
actual_used_data_storage_size_in_tbs,
admin_password,
allocated_storage_size_in_tbs,
apex_details,
autonomous_database_id,
autonomous_maintenance_schedule_type,
autonomousdatabasename,
available_upgrade_versions,
backup_retention_period_in_days,
character_set,
compute_count,
compute_model,
connection_strings,
connection_urls,
cpu_core_count,
customer_contacts,
data_base_type,
data_safe_status,
data_storage_size_in_gbs,
data_storage_size_in_tbs,
database_edition,
db_version,
db_workload,
display_name,
failed_data_recovery_in_seconds,
in_memory_area_in_gbs,
is_auto_scaling_enabled,
is_auto_scaling_for_storage_enabled,
is_local_data_guard_enabled,
is_mtls_connection_required,
is_preview,
is_preview_version_with_service_terms_accepted,
is_remote_data_guard_enabled,
license_model,
lifecycle_details,
lifecycle_state,
local_adg_auto_failover_max_data_loss_limit,
local_disaster_recovery_type,
local_standby_db,
location,
long_term_backup_schedule,
memory_per_oracle_compute_unit_in_gbs,
ncharacter_set,
next_long_term_backup_time_stamp,
oci_url,
ocid,
open_mode,
operations_insights_status,
peer_db_id,
peer_db_ids,
permission_level,
private_endpoint,
private_endpoint_ip,
private_endpoint_label,
provisionable_cpus,
provisioning_state,
resourceGroupName,
role,
scheduled_operations,
service_console_url,
sql_web_developer_url,
subnet_id,
subscriptionId,
supported_regions_to_clone_to,
tags,
time_created,
time_data_guard_role_changed,
time_deletion_of_free_autonomous_database,
time_local_data_guard_enabled,
time_maintenance_begin,
time_maintenance_end,
time_of_last_failover,
time_of_last_refresh,
time_of_last_refresh_point,
time_of_last_switchover,
time_reclamation_of_free_autonomous_database,
used_data_storage_size_in_gbs,
used_data_storage_size_in_tbs,
vnet_id,
whitelisted_ips
FROM azure_isv.oracle.vw_autonomous_databases
WHERE subscriptionId = '{{ subscriptionId }}';

autonomous_databases

SELECT
location,
properties,
tags
FROM azure_isv.oracle.autonomous_databases
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new autonomous_databases resource.

All Properties

/*+ create */
INSERT INTO azure_isv.oracle.autonomous_databases (
autonomousdatabasename,
resourceGroupName,
subscriptionId,
properties,
tags,
location
)
SELECT 
'{{ autonomousdatabasename }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: adminPassword
          value: []
        - name: dataBaseType
          value: []
        - name: autonomousMaintenanceScheduleType
          value: []
        - name: characterSet
          value: string
        - name: computeCount
          value: number
        - name: computeModel
          value: []
        - name: cpuCoreCount
          value: integer
        - name: customerContacts
          value:
            - - name: email
                value: string
        - name: dataStorageSizeInTbs
          value: integer
        - name: dataStorageSizeInGbs
          value: integer
        - name: dbVersion
          value: string
        - name: dbWorkload
          value: []
        - name: displayName
          value: string
        - name: isAutoScalingEnabled
          value: boolean
        - name: isAutoScalingForStorageEnabled
          value: boolean
        - name: peerDbIds
          value:
            - string
        - name: peerDbId
          value: string
        - name: isLocalDataGuardEnabled
          value: boolean
        - name: isRemoteDataGuardEnabled
          value: boolean
        - name: localDisasterRecoveryType
          value: []
        - name: localStandbyDb
          value:
            - name: lagTimeInSeconds
              value: integer
            - name: lifecycleState
              value: []
            - name: lifecycleDetails
              value: string
            - name: timeDataGuardRoleChanged
              value: string
            - name: timeDisasterRecoveryRoleChanged
              value: string
        - name: failedDataRecoveryInSeconds
          value: integer
        - name: isMtlsConnectionRequired
          value: boolean
        - name: isPreviewVersionWithServiceTermsAccepted
          value: boolean
        - name: licenseModel
          value: []
        - name: ncharacterSet
          value: string
        - name: lifecycleDetails
          value: string
        - name: provisioningState
          value: []
        - name: scheduledOperations
          value:
            - name: dayOfWeek
              value:
                - name: name
                  value: []
            - name: scheduledStartTime
              value: string
            - name: scheduledStopTime
              value: string
        - name: privateEndpointIp
          value: string
        - name: privateEndpointLabel
          value: string
        - name: ociUrl
          value: string
        - name: subnetId
          value: []
        - name: vnetId
          value: []
        - name: timeCreated
          value: string
        - name: timeMaintenanceBegin
          value: string
        - name: timeMaintenanceEnd
          value: string
        - name: actualUsedDataStorageSizeInTbs
          value: number
        - name: allocatedStorageSizeInTbs
          value: number
        - name: apexDetails
          value:
            - name: apexVersion
              value: string
            - name: ordsVersion
              value: string
        - name: availableUpgradeVersions
          value:
            - string
        - name: connectionStrings
          value:
            - name: allConnectionStrings
              value:
                - name: high
                  value: string
                - name: low
                  value: string
                - name: medium
                  value: string
            - name: dedicated
              value: string
            - name: high
              value: string
            - name: low
              value: string
            - name: medium
              value: string
            - name: profiles
              value:
                - - name: consumerGroup
                    value: []
                  - name: displayName
                    value: string
                  - name: hostFormat
                    value: []
                  - name: isRegional
                    value: boolean
                  - name: protocol
                    value: []
                  - name: sessionMode
                    value: []
                  - name: syntaxFormat
                    value: []
                  - name: tlsAuthentication
                    value: []
                  - name: value
                    value: string
        - name: connectionUrls
          value:
            - name: apexUrl
              value: string
            - name: databaseTransformsUrl
              value: string
            - name: graphStudioUrl
              value: string
            - name: machineLearningNotebookUrl
              value: string
            - name: mongoDbUrl
              value: string
            - name: ordsUrl
              value: string
            - name: sqlDevWebUrl
              value: string
        - name: dataSafeStatus
          value: []
        - name: databaseEdition
          value: []
        - name: autonomousDatabaseId
          value: []
        - name: inMemoryAreaInGbs
          value: integer
        - name: nextLongTermBackupTimeStamp
          value: string
        - name: longTermBackupSchedule
          value:
            - name: repeatCadence
              value: []
            - name: timeOfBackup
              value: string
            - name: retentionPeriodInDays
              value: []
            - name: isDisabled
              value: boolean
        - name: isPreview
          value: boolean
        - name: localAdgAutoFailoverMaxDataLossLimit
          value: integer
        - name: memoryPerOracleComputeUnitInGbs
          value: integer
        - name: openMode
          value: []
        - name: operationsInsightsStatus
          value: []
        - name: permissionLevel
          value: []
        - name: privateEndpoint
          value: string
        - name: provisionableCpus
          value:
            - integer
        - name: role
          value: []
        - name: serviceConsoleUrl
          value: string
        - name: sqlWebDeveloperUrl
          value: string
        - name: supportedRegionsToCloneTo
          value:
            - string
        - name: timeDataGuardRoleChanged
          value: string
        - name: timeDeletionOfFreeAutonomousDatabase
          value: string
        - name: timeLocalDataGuardEnabled
          value: string
        - name: timeOfLastFailover
          value: string
        - name: timeOfLastRefresh
          value: string
        - name: timeOfLastRefreshPoint
          value: string
        - name: timeOfLastSwitchover
          value: string
        - name: timeReclamationOfFreeAutonomousDatabase
          value: string
        - name: usedDataStorageSizeInGbs
          value: integer
        - name: usedDataStorageSizeInTbs
          value: integer
        - name: ocid
          value: []
        - name: backupRetentionPeriodInDays
          value: integer
        - name: whitelistedIps
          value:
            - []
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a autonomous_databases resource.

/*+ update */
UPDATE azure_isv.oracle.autonomous_databases
SET 
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
autonomousdatabasename = '{{ autonomousdatabasename }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified autonomous_databases resource.

/*+ delete */
DELETE FROM azure_isv.oracle.autonomous_databases
WHERE autonomousdatabasename = '{{ autonomousdatabasename }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';