Skip to main content

vw_autonomous_database_backups

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

Overview​

Namevw_autonomous_database_backups
TypeView
Idazure_isv.oracle.vw_autonomous_database_backups

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.autonomousDatabaseOcid') as "autonomous_database_ocid",
JSON_EXTRACT(properties, '$.databaseSizeInTbs') as "database_size_in_tbs",
JSON_EXTRACT(properties, '$.dbVersion') as "db_version",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.ocid') as "ocid",
JSON_EXTRACT(properties, '$.isAutomatic') as "is_automatic",
JSON_EXTRACT(properties, '$.isRestorable') as "is_restorable",
JSON_EXTRACT(properties, '$.lifecycleDetails') as "lifecycle_details",
JSON_EXTRACT(properties, '$.lifecycleState') as "lifecycle_state",
JSON_EXTRACT(properties, '$.retentionPeriodInDays') as "retention_period_in_days",
JSON_EXTRACT(properties, '$.sizeInTbs') as "size_in_tbs",
JSON_EXTRACT(properties, '$.timeAvailableTil') as "time_available_til",
JSON_EXTRACT(properties, '$.timeStarted') as "time_started",
JSON_EXTRACT(properties, '$.timeEnded') as "time_ended",
JSON_EXTRACT(properties, '$.backupType') as "backup_type",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
autonomousdatabasename,
adbbackupid
FROM azure_isv.oracle.autonomous_database_backups
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND autonomousdatabasename = 'replace-me';