autonomous_databases

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

Overview

Name	autonomous_databases
Type	Resource
Id	azure_isv.oracle.autonomous_databases

Fields

The following fields are returned by SELECT queries:

get

Azure operation completed successfully.

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	The resource-specific properties for this resource.
tags	object	Resource tags.

list_by_resource_group

Azure operation completed successfully.

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	The resource-specific properties for this resource.
tags	object	Resource tags.

list_by_subscription

Azure operation completed successfully.

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	The resource-specific properties for this resource.
tags	object	Resource tags.

Methods

The following methods are available for this resource:

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

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.

Name	Datatype	Description
autonomousdatabasename	string	The database name.
resourceGroupName	string	The name of the resource group. The name is case insensitive.
subscriptionId	string (uuid)	The ID of the target subscription. The value must be an UUID.

SELECT examples

get

Get a AutonomousDatabase

SELECT
location,
properties,
tags
FROM azure_isv.oracle.autonomous_databases
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND autonomousdatabasename = '{{ autonomousdatabasename }}' -- required
;

list_by_resource_group

List AutonomousDatabase resources by resource group

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

list_by_subscription

List AutonomousDatabase resources by subscription ID

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

INSERT examples

create_or_update

Create a AutonomousDatabase

INSERT INTO azure_isv.oracle.autonomous_databases (
data__properties,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
autonomousdatabasename
)
SELECT 
'{{ properties }}',
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ autonomousdatabasename }}'
RETURNING
location,
properties,
tags
;

Manifest

# Description fields are for documentation purposes
- name: autonomous_databases
  props:
    - name: subscriptionId
      value: string (uuid)
      description: Required parameter for the autonomous_databases resource.
    - name: resourceGroupName
      value: string
      description: Required parameter for the autonomous_databases resource.
    - name: autonomousdatabasename
      value: string
      description: Required parameter for the autonomous_databases resource.
    - name: properties
      value: object
      description: |
        The resource-specific properties for this resource.
    - name: tags
      value: object
      description: |
        Resource tags.
    - name: location
      value: string
      description: |
        The geo-location where the resource lives

UPDATE examples

update

Update a AutonomousDatabase

UPDATE azure_isv.oracle.autonomous_databases
SET 
data__tags = '{{ tags }}',
data__properties = '{{ properties }}'
WHERE 
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND autonomousdatabasename = '{{ autonomousdatabasename }}' --required
RETURNING
location,
properties,
tags;

DELETE examples

delete

Delete a AutonomousDatabase

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

Lifecycle Methods

failover

Perform failover action on Autonomous Database

EXEC azure_isv.oracle.autonomous_databases.failover 
@subscriptionId='{{ subscriptionId }}' --required, 
@resourceGroupName='{{ resourceGroupName }}' --required, 
@autonomousdatabasename='{{ autonomousdatabasename }}' --required 
@@json=
'{
"peerDbId": "{{ peerDbId }}"
}'
;

generate_wallet

Generate wallet action on Autonomous Database

EXEC azure_isv.oracle.autonomous_databases.generate_wallet 
@subscriptionId='{{ subscriptionId }}' --required, 
@resourceGroupName='{{ resourceGroupName }}' --required, 
@autonomousdatabasename='{{ autonomousdatabasename }}' --required 
@@json=
'{
"generateType": "{{ generateType }}", 
"isRegional": {{ isRegional }}, 
"password": "{{ password }}"
}'
;

restore

Restores an Autonomous Database based on the provided request parameters.

EXEC azure_isv.oracle.autonomous_databases.restore 
@subscriptionId='{{ subscriptionId }}' --required, 
@resourceGroupName='{{ resourceGroupName }}' --required, 
@autonomousdatabasename='{{ autonomousdatabasename }}' --required 
@@json=
'{
"timestamp": "{{ timestamp }}"
}'
;

shrink

This operation shrinks the current allocated storage down to the current actual used data storage.

EXEC azure_isv.oracle.autonomous_databases.shrink 
@subscriptionId='{{ subscriptionId }}' --required, 
@resourceGroupName='{{ resourceGroupName }}' --required, 
@autonomousdatabasename='{{ autonomousdatabasename }}' --required
;

switchover

Perform switchover action on Autonomous Database

EXEC azure_isv.oracle.autonomous_databases.switchover 
@subscriptionId='{{ subscriptionId }}' --required, 
@resourceGroupName='{{ resourceGroupName }}' --required, 
@autonomousdatabasename='{{ autonomousdatabasename }}' --required 
@@json=
'{
"peerDbId": "{{ peerDbId }}"
}'
;