autonomous_database_backups

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

Overview

Name	autonomous_database_backups
Type	Resource
Id	azure_isv.oracle.autonomous_database_backups

Fields

vw_autonomous_database_backups

Name	Datatype	Description
adbbackupid	text	field from the properties object
autonomous_database_ocid	text	field from the properties object
autonomousdatabasename	text	field from the properties object
backup_type	text	field from the properties object
database_size_in_tbs	text	field from the properties object
db_version	text	field from the properties object
display_name	text	field from the properties object
is_automatic	text	field from the properties object
is_restorable	text	field from the properties object
lifecycle_details	text	field from the properties object
lifecycle_state	text	field from the properties object
ocid	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
retention_period_in_days	text	field from the properties object
size_in_tbs	text	field from the properties object
subscriptionId	text	field from the properties object
time_available_til	text	field from the properties object
time_ended	text	field from the properties object
time_started	text	field from the properties object

autonomous_database_backups

Name	Datatype	Description
properties	object	AutonomousDatabaseBackup resource model

Methods

Name	Accessible by	Required Params	Description
get	SELECT	adbbackupid, autonomousdatabasename, resourceGroupName, subscriptionId	Get a AutonomousDatabaseBackup
list_by_autonomous_database	SELECT	autonomousdatabasename, resourceGroupName, subscriptionId	List AutonomousDatabaseBackup resources by AutonomousDatabase
create_or_update	INSERT	adbbackupid, autonomousdatabasename, resourceGroupName, subscriptionId	Create a AutonomousDatabaseBackup
delete	DELETE	adbbackupid, autonomousdatabasename, resourceGroupName, subscriptionId	Delete a AutonomousDatabaseBackup
update	UPDATE	adbbackupid, autonomousdatabasename, resourceGroupName, subscriptionId	Update a AutonomousDatabaseBackup

SELECT examples

List AutonomousDatabaseBackup resources by AutonomousDatabase

vw_autonomous_database_backups

SELECT
adbbackupid,
autonomous_database_ocid,
autonomousdatabasename,
backup_type,
database_size_in_tbs,
db_version,
display_name,
is_automatic,
is_restorable,
lifecycle_details,
lifecycle_state,
ocid,
provisioning_state,
resourceGroupName,
retention_period_in_days,
size_in_tbs,
subscriptionId,
time_available_til,
time_ended,
time_started
FROM azure_isv.oracle.vw_autonomous_database_backups
WHERE autonomousdatabasename = '{{ autonomousdatabasename }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

autonomous_database_backups

SELECT
properties
FROM azure_isv.oracle.autonomous_database_backups
WHERE autonomousdatabasename = '{{ autonomousdatabasename }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: autonomousDatabaseOcid
          value: []
        - name: databaseSizeInTbs
          value: number
        - name: dbVersion
          value: string
        - name: displayName
          value: string
        - name: isAutomatic
          value: boolean
        - name: isRestorable
          value: boolean
        - name: lifecycleDetails
          value: string
        - name: lifecycleState
          value: []
        - name: retentionPeriodInDays
          value: integer
        - name: sizeInTbs
          value: number
        - name: timeAvailableTil
          value: string
        - name: timeStarted
          value: string
        - name: timeEnded
          value: string
        - name: backupType
          value: []
        - name: provisioningState
          value: []

UPDATE example

Updates a autonomous_database_backups resource.

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

DELETE example

Deletes the specified autonomous_database_backups resource.

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