OceanBase Database supports the creation of periodic backup strategies, which can perform full backups at specified intervals. It can also simultaneously initiate log backups and automatically clean up expired backup files.
Background information
After you enable a backup strategy, the produced data backups and log backups are stored in the object storage service in the corresponding region of your cloud service vendor. You may be charged for the storage space occupied by your backups based on the billing strategy for the object storage service of your cloud service vendor. Make sure that your cloud service account has a sufficient balance.
Note
- Clusters created before the end of November 2023 will need to manually enable the backup feature. For Tencent Cloud and AWS clusters created after this date: in DBaaS or SaaS mode, the backup feature will be enabled by default; in MaaS mode, manual activation is still required.
- For Tencent Cloud clusters, the backup feature is not supported for OceanBase Database versions later than V4.0.0 but earlier than V4.2.1.
Enable a backup strategy
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
On the Instances page, click the name of the target instance to go to the Overview page of the instance.
In the left-side navigation pane, click Backup.
In the upper-right corner of the page, click Enable Backup Policy.
In the displayed dialog box, click OK.
Modify a backup strategy
On the Backup Strategy tab of the Backup page, click Modify Backup Strategy.
On the Modify Backup Strategy page, set the parameters related to local backup.
Parameter Default Value Description Data Backup Type Full At present, only full backup is supported. Log Backup Enabled After a backup strategy is configured and enabled, log backup is enabled automatically and cannot be disabled. Backup Cycle 04:00 a.m. on the next day after the cluster is created You can specify one or more days in a week on which data is backed up as needed. The system backs up data on the specified days every week. We recommend that you back up data at least once a week for data security purposes. Backup Time 04:00 a.m. You can select a backup time from the drop-down list. - We recommend that you select a point in time during off-peak hours.
- Do not select a backup time within the major compaction window, which is one hour before and one hour after a major compaction is performed. Otherwise, the backup task will be delayed.
Data Backup Retention Days / PITR Window 7 Days Backup data can be retained for 2 to 730 days. Backup Retention Strategy upon Instance Release Do not retain backups (Backups cannot be restored after release) N/A Click OK.
Disable a backup strategy
On the Backup Strategy tab of the Backup page, click Disable Backup Policy.
Note
After disabling the automatic backup feature, all historical automatic backups will be deleted. It is recommended to restore backup data to a new instance before disabling this feature to prevent data loss.In the displayed dialog box, click OK.