The Database resource in Oracle Cloud Infrastructure Database service provides an optional auto_backup_window option in its API during creation (Terraform resource: oci_database_database).
The database resource can be used in an OCI Base DB system or Exadata Cloud VM Cluster pluggable database (PDB) for example.
The time window enum value selected for initiating automatic backup for the database system is available in twelve two-hour UTC time windows as the following:
| Slot | Description |
|---|---|
| SLOT_ONE | 12:00AM - 2:00AM UTC |
| SLOT_TWO | 2:00AM - 4:00AM UTC |
| SLOT_THREE | 4:00AM - 6:00AM UTC |
| SLOT_FOUR | 6:00AM - 8:00AM UTC |
| SLOT_FIVE | 8:00AM - 10:00AM UTC |
| SLOT_SIX | 10:00AM - 12:00PM UTC |
| SLOT_SEVEN | 12:00PM - 2:00PM UTC |
| SLOT_EIGHT | 2:00PM - 4:00PM UTC |
| SLOT_NINE | 4:00PM - 6:00PM UTC |
| SLOT_TEN | 6:00PM - 8:00PM UTC |
| SLOT_ELEVEN | 8:00PM - 10:00PM UTC |
| SLOT_TWELVE | 10:00PM - 12:00AM UTC |
Timezone used for the slots is always UTC regardless of the timezone used in the database.
For example, if the user selects SLOT_TWO from the enum list, the automatic backup job will start in between 2:00 AM (inclusive) to 4:00 AM (exclusive)
If no option is selected, a start time between 12:00 AM to 7:00 AM in the region of the database is automatically chosen.
Reference
Safe harbor statement
The information provided on this channel/article/story is solely intended for informational purposes and cannot be used as a part of any contractual agreement. The content does not guarantee the delivery of any material, code, or functionality, and should not be the sole basis for making purchasing decisions. The postings on this site are my own and do not necessarily reflect the views or work of Oracle or Mythics, LLC.
This work is licensed under a Creative Commons Attribution 4.0 International License (CC-BY 4.0).
Top comments (0)