oci360 2b.44. Backup Policies (OCI360_BKP_POLICY)


# ID DISPLAY_ TIME_CREATED COMP DEST SCHE SCHEDULES$PERIOD SCHEDULES$TIME_ZONE SCHEDULES$BACKUP SCHE SCHE SCHE SCHE SCHEDULES$OFFSET_SECONDS SCHEDULES$RETENTION_SECONDS
1 ocid1.volumebackuppolicy.oc1..000000000000000000000000000000000000000000000000000000000725 silver 2017-10-01T00:00:00.001000+00:00       ONE_WEEK REGIONAL_DATA_CENTER_TIME INCREMENTAL         0 2419200
2 ocid1.volumebackuppolicy.oc1..000000000000000000000000000000000000000000000000000000000725 silver 2017-10-01T00:00:00.001000+00:00       ONE_MONTH REGIONAL_DATA_CENTER_TIME INCREMENTAL         0 31557600
3 ocid1.volumebackuppolicy.oc1..000000000000000000000000000000000000000000000000000000000725 silver 2017-10-01T00:00:00.001000+00:00       ONE_YEAR REGIONAL_DATA_CENTER_TIME FULL         0 157680000
4 ocid1.volumebackuppolicy.oc1..000000000000000000000000000000000000000000000000000000000726 bronze 2017-10-01T00:00:00+00:00       ONE_MONTH REGIONAL_DATA_CENTER_TIME INCREMENTAL         0 31557600
5 ocid1.volumebackuppolicy.oc1..000000000000000000000000000000000000000000000000000000000726 bronze 2017-10-01T00:00:00+00:00       ONE_YEAR REGIONAL_DATA_CENTER_TIME FULL         0 157680000
6 ocid1.volumebackuppolicy.oc1..000000000000000000000000000000000000000000000000000000000727 gold 2017-10-01T00:00:00.002000+00:00       ONE_DAY REGIONAL_DATA_CENTER_TIME INCREMENTAL         0 604800
7 ocid1.volumebackuppolicy.oc1..000000000000000000000000000000000000000000000000000000000727 gold 2017-10-01T00:00:00.002000+00:00       ONE_WEEK REGIONAL_DATA_CENTER_TIME INCREMENTAL         0 2419200
8 ocid1.volumebackuppolicy.oc1..000000000000000000000000000000000000000000000000000000000727 gold 2017-10-01T00:00:00.002000+00:00       ONE_MONTH REGIONAL_DATA_CENTER_TIME INCREMENTAL         0 31557600
9 ocid1.volumebackuppolicy.oc1..000000000000000000000000000000000000000000000000000000000727 gold 2017-10-01T00:00:00.002000+00:00       ONE_YEAR REGIONAL_DATA_CENTER_TIME FULL         0 157680000

#: click on a column heading to sort on it

 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 ID                                                                                           VARCHAR2(128)
 DISPLAY_NAME                                                                                 VARCHAR2(8)
 TIME_CREATED                                                                                 VARCHAR2(32)
 COMPARTMENT_ID                                                                               VARCHAR2(4)
 DESTINATION_REGION                                                                           VARCHAR2(4)
 SCHEDULES$MONTH                                                                              VARCHAR2(4)
 SCHEDULES$PERIOD                                                                             VARCHAR2(16)
 SCHEDULES$TIME_ZONE                                                                          VARCHAR2(32)
 SCHEDULES$BACKUP_TYPE                                                                        VARCHAR2(16)
 SCHEDULES$DAY_OF_WEEK                                                                        VARCHAR2(4)
 SCHEDULES$HOUR_OF_DAY                                                                        VARCHAR2(4)
 SCHEDULES$OFFSET_TYPE                                                                        VARCHAR2(4)
 SCHEDULES$DAY_OF_MONTH                                                                       VARCHAR2(4)
 SCHEDULES$OFFSET_SECONDS                                                                     NUMBER
 SCHEDULES$RETENTION_SECONDS                                                                  NUMBER


SELECT t1.*
FROM   OCI360_BKP_POLICY t1;


9 rows selected.

oci360 (c) 2020, All rights reserved. oci360 v20.06 (2020-06-25) based on moat369 v2002 (2020-02-27). Timestamp: 2020-06-30T15:52:27