2b.48. Incremental Vol Backups without a prior Full (OCI360_BACKUPS) 2b.48. Incremental Vol Backups without a prior Full (OCI360_BACKUPS)
| # | BACKUP_NAME | ASSET_NAME | ASSET_ | TYPE | ASSET_ID | SIZE_IN_GBS | SOURCE_T | TIME_CREATED | COMPARTMENT_ID | EXPI | LIFECYCLE_STATE | UNIQUE_SIZE_IN_GBS | TIME_REQUEST_RECEIVED | ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | u01_Incr_3 | oci360_u01 | Volume | INCREMENTAL | ocid1.volume.oc1.iad.000000000000000000000000000000000000000000000000000000000712 | 50 | MANUAL | 2020-06-19T15:10:05.106000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000210 | AVAILABLE | 1 | 2020-06-19T15:09:58.482000+00:00 | ocid1.volumebackup.oc1.iad.000000000000000000000000000000000000000000000000000000000716 | |
| 2 | test_vol_incr_1 | test_vol | Volume | INCREMENTAL | ocid1.volume.oc1.iad.000000000000000000000000000000000000000000000000000000000710 | 50 | MANUAL | 2020-06-26T22:10:59.613000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000210 | AVAILABLE | 10 | 2020-06-26T22:10:56.172000+00:00 | ocid1.volumebackup.oc1.iad.000000000000000000000000000000000000000000000000000000000723 | |
| 3 | test_vol_incr_2 | test_vol | Volume | INCREMENTAL | ocid1.volume.oc1.iad.000000000000000000000000000000000000000000000000000000000710 | 50 | MANUAL | 2020-06-26T23:05:37.103000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000210 | AVAILABLE | 10 | 2020-06-26T23:05:30.777000+00:00 | ocid1.volumebackup.oc1.iad.000000000000000000000000000000000000000000000000000000000719 |
#: 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.type='INCREMENTAL'
AND t1.lifecycle_state='AVAILABLE'
AND t1.volume_id = t2.id (+)
AND NOT EXISTS (SELECT 1
FROM OCI360_BACKUPS t3
WHERE t1.type='FULL'
AND t1.lifecycle_state='AVAILABLE'
AND t1.volume_id=t3.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')
);
3 rows selected.