2b.42. Volume Backups - Available (OCI360_BACKUPS) 2b.42. Volume Backups - Available (OCI360_BACKUPS)
| # | VOLUME_NAME | TYPE | SIZE_IN_GBS | SIZE_IN_MBS | SOURCE_T | DISPLAY_NAME | TIME_CREATED | COMPARTMENT_NAME | EXPI | LIFECYCLE_STATE | UNIQUE_SIZE_IN_GBS | UNIQUE_SIZE_IN_MBS | TIME_REQUEST_RECEIVED | VOLUME_ID | ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | oci360_u01 | FULL | 50 | 51200 | MANUAL | u01_Full_2 | 2020-06-19T15:08:00.215000+00:00 | compt_dev_app | AVAILABLE | 12 | 11826 | 2020-06-19T15:07:57.095000+00:00 | ocid1.volume.oc1.iad.000000000000000000000000000000000000000000000000000000000712 | ocid1.volumebackup.oc1.iad.000000000000000000000000000000000000000000000000000000000721 | |
| 2 | oci360_u01 | INCREMENTAL | 50 | 51200 | MANUAL | u01_Incr_3 | 2020-06-19T15:10:05.106000+00:00 | compt_dev_app | AVAILABLE | 1 | 1 | 2020-06-19T15:09:58.482000+00:00 | ocid1.volume.oc1.iad.000000000000000000000000000000000000000000000000000000000712 | ocid1.volumebackup.oc1.iad.000000000000000000000000000000000000000000000000000000000716 | |
| 3 | test_vol | INCREMENTAL | 50 | 51200 | MANUAL | test_vol_incr_1 | 2020-06-26T22:10:59.613000+00:00 | compt_dev_app | AVAILABLE | 10 | 9904 | 2020-06-26T22:10:56.172000+00:00 | ocid1.volume.oc1.iad.000000000000000000000000000000000000000000000000000000000710 | ocid1.volumebackup.oc1.iad.000000000000000000000000000000000000000000000000000000000723 | |
| 4 | test_vol | INCREMENTAL | 50 | 51200 | MANUAL | test_vol_incr_2 | 2020-06-26T23:05:37.103000+00:00 | compt_dev_app | AVAILABLE | 10 | 9904 | 2020-06-26T23:05:30.777000+00:00 | ocid1.volume.oc1.iad.000000000000000000000000000000000000000000000000000000000710 | 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 t2.display_name VOLUME_NAME,
t1.type,
t1.size_in_gbs,
t1.size_in_mbs,
t1.source_type,
t1.display_name,
t1.time_created,
t3.name COMPARTMENT_NAME,
t1.expiration_time,
t1.lifecycle_state,
t1.unique_size_in_gbs,
t1.unique_size_in_mbs,
t1.time_request_received,
t1.volume_id,
t1.id
FROM OCI360_BACKUPS t1,
OCI360_VOLUMES t2,
OCI360_COMPARTMENTS t3
WHERE t1.lifecycle_state = 'AVAILABLE'
AND t1.volume_id = t2.id (+)
AND t1.compartment_id = t3.id (+);
4 rows selected.