2b.49. Backups for terminated Volumes (OCI360_BACKUPS)

#: click on a column heading to sort on it
 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 ID                                                                                           VARCHAR2(128)
 TYPE                                                                                         VARCHAR2(16)
 VOLUME_ID                                                                                    VARCHAR2(128)
 KMS_KEY_ID                                                                                   VARCHAR2(4)
 SIZE_IN_GBS                                                                                  NUMBER
 SIZE_IN_MBS                                                                                  NUMBER
 SOURCE_TYPE                                                                                  VARCHAR2(8)
 SYSTEM_TAGS$ORCL_CLOUD$FREE_TIER_RETAINED                                                    VARCHAR2(4)
 DEFINED_TAGS$ORACLE_TAGS$CREATEDBY                                                           VARCHAR2(64)
 DEFINED_TAGS$ORACLE_TAGS$CREATEDON                                                           VARCHAR2(32)
 DISPLAY_NAME                                                                                 VARCHAR2(16)
 TIME_CREATED                                                                                 VARCHAR2(32)
 FREEFORM_TAGS$BACKUP                                                                         VARCHAR2(16)
 COMPARTMENT_ID                                                                               VARCHAR2(128)
 EXPIRATION_TIME                                                                              VARCHAR2(4)
 LIFECYCLE_STATE                                                                              VARCHAR2(16)
 UNIQUE_SIZE_IN_GBS                                                                           NUMBER
 UNIQUE_SIZE_IN_MBS                                                                           NUMBER
 TIME_REQUEST_RECEIVED                                                                        VARCHAR2(32)
 SOURCE_VOLUME_BACKUP_ID                                                                      VARCHAR2(4)


SELECT t1.display_name BACKUP_NAME,
       t2.display_name ASSET_NAME,
       'Volume' ASSET_TYPE,
       t1.type,
       t1.volume_id asset_id,
       t1.size_in_gbs,
       t1.source_type,
       t1.time_created,
       t1.compartment_id,
       t1.expiration_time,
       t1.lifecycle_state,
       t1.unique_size_in_gbs,
       t1.time_request_received,
       t1.id
FROM   OCI360_BACKUPS t1, OCI360_VOLUMES t2
WHERE  t1.lifecycle_state='AVAILABLE'
AND    t1.volume_id = t2.id (+)
AND    t2.lifecycle_state (+) != 'TERMINATED'
AND    t2.id is null;


0 rows selected.