2a.38. Volumes without a backup policy (OCI360_VOLGROUP_BKP)

#	DISPLAY_NAME	IS_H	SIZE_IN_GBS	VPUS_PER_GB	COMPARTMENT_NAME	LIFECYCLE_STATE	AVAILABILITY_DOMAIN	ID
1	test_vol	true	50	10	compt_dev_app	AVAILABLE	CYtq:US-ASHBURN-AD-3	ocid1.volume.oc1.iad.000000000000000000000000000000000000000000000000000000000710
2	oci360_u01	true	50	10	compt_dev_app	AVAILABLE	CYtq:US-ASHBURN-AD-3	ocid1.volume.oc1.iad.000000000000000000000000000000000000000000000000000000000712
3	test_vol	true	50	0	compt_dev_db	TERMINATED	CYtq:US-ASHBURN-AD-3	ocid1.volume.oc1.iad.000000000000000000000000000000000000000000000000000000000711

#: click on a column heading to sort on it

ERROR:
ORA-04043: object OCI360_VOLGROUP_BKP does not exist



SELECT jt.DISPLAY_NAME,
       jt.IS_HYDRATED,
       jt.SIZE_IN_GBS,
       jt.VPUS_PER_GB,
       tcomp.NAME COMPARTMENT_NAME,
       jt.LIFECYCLE_STATE,
       jt.VOLUME_GROUP_ID,
       jt.AVAILABILITY_DOMAIN,
       jt.ID
FROM   OCI360_VOLUMES jt,
       OCI360_COMPARTMENTS tcomp,
       OCI360_BKP_POLICY_ASSIGN tbkppolassign
WHERE  jt.COMPARTMENT_ID = tcomp.ID
AND    jt.ID = tbkppolassign.ASSET_ID (+)
AND    tbkppolassign.ASSET_ID is null
ORDER  BY COMPARTMENT_NAME, jt.TIME_CREATED DESC;


3 rows selected.