Skip to main content

autonomous_database_backups

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

Overview

Nameautonomous_database_backups
TypeResource
Idazure_isv.oracle.autonomous_database_backups

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
propertiesobjectThe resource-specific properties for this resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, autonomousdatabasename, adbbackupidGet a AutonomousDatabaseBackup
list_by_autonomous_databaseselectsubscriptionId, resourceGroupName, autonomousdatabasenameList AutonomousDatabaseBackup resources by AutonomousDatabase
create_or_updateinsertsubscriptionId, resourceGroupName, autonomousdatabasename, adbbackupidCreate a AutonomousDatabaseBackup
updateupdatesubscriptionId, resourceGroupName, autonomousdatabasename, adbbackupidUpdate a AutonomousDatabaseBackup
deletedeletesubscriptionId, resourceGroupName, autonomousdatabasename, adbbackupidDelete a AutonomousDatabaseBackup

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
adbbackupidstringAutonomousDatabaseBackup id
autonomousdatabasenamestringThe database name.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Get a AutonomousDatabaseBackup

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

INSERT examples

Create a AutonomousDatabaseBackup

INSERT INTO azure_isv.oracle.autonomous_database_backups (
data__properties,
subscriptionId,
resourceGroupName,
autonomousdatabasename,
adbbackupid
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ autonomousdatabasename }}',
'{{ adbbackupid }}'
RETURNING
properties
;

UPDATE examples

Update a AutonomousDatabaseBackup

UPDATE azure_isv.oracle.autonomous_database_backups
SET
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND autonomousdatabasename = '{{ autonomousdatabasename }}' --required
AND adbbackupid = '{{ adbbackupid }}' --required
RETURNING
properties;

DELETE examples

Delete a AutonomousDatabaseBackup

DELETE FROM azure_isv.oracle.autonomous_database_backups
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND autonomousdatabasename = '{{ autonomousdatabasename }}' --required
AND adbbackupid = '{{ adbbackupid }}' --required
;