In addition to scheduled backups, you can start a physical data backup manually without waiting for the scheduled backup time. The following backup restrictions still apply.
Note
- OceanBase Database performs major compactions by default once a day. However, if the business write volume is high, multiple major compactions may be triggered. After each major compaction, OceanBase Database can only support one successful data backup. If the data backup succeeds, triggering another backup before the next major compaction will result in a backup failure message.
- Manual backup execution is limited to data backups and does not affect log backup tasks.
Background information
- Physical backup: A physical backup involves dumping OceanBase's physical files, which contain baseline data, log archive data, etc. In the event of a database failure, these files can be used for database recovery.
Procedure
BYOC supports on-demand physical backups. Follow these steps to create a backup task.
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
In the instance list, find the target BYOC cluster, click the name to enter the Overview page.
In the left-side navigation pane, click Backup.
In the upper-right corner of the page, click Create backup.
In the Create backup panel, configure the following settings:
ParameterDescriptionBackup Object Select the backup object. Tenants are currently supported. Select Tenants Select all tenants or specific tenants to back up. Backup method Currently, only physical backup is supported. Backup storage settings Select the backup storage location. OceanBase Cloud storage is currently supported. Click OK to submit the backup task.
On the Data Backup tab, view the task progress and results.
Execution result
On the Data Backup tab, view the basic information of the manually created backup task. You can view the task progress through the progress percentage.