2d.63. Incremental BV Backups without a prior Full (OCI360_BV_BACKUPS)

#: click on a column heading to sort on it
 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 BOOT_VOLUME_ID                                                                               VARCHAR2(1)
 COMPARTMENT_ID                                                                               VARCHAR2(1)
 DISPLAY_NAME                                                                                 VARCHAR2(1)
 EXPIRATION_TIME                                                                              VARCHAR2(1)
 IMAGE_ID                                                                                     VARCHAR2(1)
 LIFECYCLE_STATE                                                                              VARCHAR2(1)
 SIZE_IN_GBS                                                                                  NUMBER(1)
 SOURCE_TYPE                                                                                  VARCHAR2(1)
 TIME_CREATED                                                                                 VARCHAR2(1)
 TIME_REQUEST_RECEIVED                                                                        VARCHAR2(1)
 UNIQUE_SIZE_IN_GBS                                                                           NUMBER(1)
 ID                                                                                           VARCHAR2(1)
 TYPE                                                                                         VARCHAR2(1)


SELECT t1.display_name BACKUP_NAME,
       t2.display_name ASSET_NAME,
       t1.type,
       t1.boot_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_BV_BACKUPS t1, OCI360_BVOLUMES t2
WHERE  t1.type='INCREMENTAL'
AND    t1.lifecycle_state='AVAILABLE'
AND    t1.boot_volume_id = t2.id (+)
AND    NOT EXISTS (SELECT 1
                   FROM   OCI360_BV_BACKUPS t3
                   WHERE  t1.type='FULL'
                   AND    t1.lifecycle_state='AVAILABLE'
                   AND    t1.boot_volume_id=t3.boot_volume_id
                   AND    to_timestamp_tz(t1.time_created,'YYYY-MM-DD"T"HH24:MI:SS.FF6TZH:TZM') > to_timestamp_tz(t3.time_created,'YYYY-MM-DD"T"HH24:MI:SS.FF6TZH:TZM')
                  );


0 rows selected.