2b.43. Volume Backups - Not Available (OCI360_BACKUPS) 2b.43. Volume Backups - Not 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 | 2020-06-19T14:33:43.702000+00:00 | compt_dev_app | TERMINATED | 12 | 11826 | 2020-06-19T14:33:39.186000+00:00 | ocid1.volume.oc1.iad.000000000000000000000000000000000000000000000000000000000712 | ocid1.volumebackup.oc1.iad.000000000000000000000000000000000000000000000000000000000724 | |
| 2 | oci360_u01 | FULL | 50 | 51200 | MANUAL | teste | 2020-06-19T16:00:21.714000+00:00 | compt_dev_app | TERMINATED | 12 | 11826 | 2020-06-19T16:00:18.097000+00:00 | ocid1.volume.oc1.iad.000000000000000000000000000000000000000000000000000000000712 | ocid1.volumebackup.oc1.iad.000000000000000000000000000000000000000000000000000000000722 | |
| 3 | test_vol | FULL | 50 | 51200 | MANUAL | test_vol_full_1 | 2020-06-26T21:28:03.693000+00:00 | compt_dev_app | TERMINATED | 11 | 10777 | 2020-06-26T21:27:56.471000+00:00 | ocid1.volume.oc1.iad.000000000000000000000000000000000000000000000000000000000710 | ocid1.volumebackup.oc1.iad.000000000000000000000000000000000000000000000000000000000718 | |
| 4 | test_vol | FULL | 50 | 51200 | MANUAL | test_vol_full_1 | 2020-06-26T19:20:59.873000+00:00 | compt_dev_db | TERMINATED | 1 | 1 | 2020-06-26T19:20:56.631000+00:00 | ocid1.volume.oc1.iad.000000000000000000000000000000000000000000000000000000000711 | ocid1.volumebackup.oc1.iad.000000000000000000000000000000000000000000000000000000000720 |
#: 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.