In addition to regular backup strategies, OceanBase Database also allows you to manually initiate an immediate data backup. Immediate backups are not subject to backup strategies and can be created directly in any scenario.
Note
- OceanBase Database merges data by default every 24 hours. However, if the business write load is high, multiple merges may be triggered. After each merge, OceanBase Database can only perform one successful data backup. If the backup is successful, any subsequent backup triggered before the next merge will fail.
- Manual backups are limited to data backups and do not affect log backup tasks.
Background information
Physical backup: A physical backup involves exporting the physical files of OceanBase Database, including baseline data and log archive data. These files can be used to restore the database in case of a failure.
Logical backup: A logical backup involves backing up database objects at the object level. It supports table-level and database-level backups. For database-level backups, the supported database objects vary depending on the compatibility mode:
Note
- Logical backup is currently available only to allowlist users. To enable it, please contact OceanBase Technical Support.
- A single backup task can contain a maximum of 200 tables.
MySQL compatible mode: tables, views, triggers, sequences, synonyms, types, packages, functions, and stored procedures.
Oracle compatible mode: tables, views, functions, and stored procedures.
Procedure
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
In the instance list, find the target instance and click its name 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 Create Backup.
Physical backup
On the Create Backup page, select the following configurations.
Parameter Description Backup Object When you select instance as the database object, logical backup will be performed. Backup Method Select Physical Backup. Backup Storage Settings You can back up data to an OceanBase Cloud storage or a hybrid storage (OceanBase Cloud storage + custom storage). When you use a hybrid storage, you must configure the required permissions in the Alibaba Cloud OSS console.
In the Custom Storage Configuration section, copy the RAM role ARN.
Go to the OSS Buckets page in the Alibaba Cloud console and select the bucket for the backup storage (the bucket must be in the same region as the current instance).
In the left-side navigation pane, select Permission Control > Bucket Policy > Add in GUI > Receive Objects to Replicate, enter the copied ARN information, select Cross-account Replication, and click OK.
Go to the Alibaba Cloud AccessKey page to obtain the Alibaba Cloud AccessKey ID and AccessKey Secret, and enter them in the Custom Storage Configuration section. Then, click Validate.
After the verification is successful, select the target storage bucket in the target object storage bucket and click OK.
Logical backup
On the Immediate Backup page, select Logical Backup.
Configure the following options and click OK.
Parameter Description Backup Object When you select database or table as the database object, logical backup will be performed. Source Tenant Select the target tenant. Database Objects Select databases from the source database area and add them to the backup database area. Table Objects Select tables from the source table area and add them to the backup table area.
View the result
On the Data Backup tab, view the basic information of the manually created backup task. You can check the task progress based on the percentage.