Backup and restore help protect OceanBase data and maintain system and business availability against risks such as storage media failures and accidental operations. OceanBase Cloud provides manual backups and backup strategies for scheduled, incremental, sparse, and archive backups. These options support routine data protection, lower backup retention costs, disaster recovery, and regulatory audit requirements. You can restore data at the tenant, database, or table level to meet different recovery needs. Backup set downloads and OpenAPI operations also let you transfer data between cloud and local environments and integrate backup and restore with your own systems.
Key features
Consistent backup and restore
Consistent backup and restore lets you restore historical tenant data to a point in time with second-level precision. It uses periodic full backups and log backups. For example, suppose an OceanBase instance creates a full backup at 02:00 every Monday, Wednesday, and Saturday. To restore data to 18:36:36 on the previous Sunday, the system selects the closest preceding full backup: the one created at 02:00 on Saturday. It then replays the log backups from 02:00 on Saturday through 18:36:36 on Sunday to obtain a consistent data snapshot for the requested time.
Database-level and table-level restore
You can restore selected databases or tables from backups when you need to recover part of your data after a failure or accidental operation. Examples include accidentally deleting data, dropping databases or tables, or executing unintended DDL statements.
With a physical backup, you can restore selected databases or tables to a point in time before the failure or accidental operation, provided that the point in time is within the restorable time range. With a logical backup, you can restore database or table data from the selected backup set. The supported restore objects and targets depend on the backup method and OceanBase Database version:
Restore method |
Restore objects |
Restore target |
|
|---|---|---|---|
| Restore from a logical backup | Databases and tables | An existing tenant | |
| Restore from a physical backup | OceanBase Database 4.x instances | Databases and tables | An existing tenant |
| OceanBase Database 2.x or 3.x instances | Tables | A new tenant created in an existing instance. The new tenant and restored data are retained after the restore completes. | |
Note
For version requirements, limitations, and restore procedures, see: