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:
MySQL compatible mode: tables, views, triggers, sequences, synonyms, types, packages, functions, and stored procedures.
Oracle compatible mode: tables, views, functions, and stored procedures.
Note
A single backup task can contain a maximum of 200 tables.
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 Immediate Backup page, select Physical Backup and click OK.
Logical backup
On the Immediate Backup page, select Logical Backup.
Configure the following options and click OK.
Parameter Description Backup Object Select the database objects to back up. Source Tenant Select the 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.
