You can initiate a restore task to restore the data of a tenant, a database, and a table.
Background information
When initiating a restore task, if you want to restore the data of tenant A at a specific time to tenant B, then A is the source tenant, and B is the target tenant.
You can restore data between OceanBase databases of different versions. However, there are still certain limitations in some scenarios:
The target cluster must be running or undergoing allowlist modification.
Data cannot be restored from an instance of a later version to an instance of an earlier version.
Generally, data in an instance of an earlier version can be restored to an instance of the same version or a later version. However, this feature is not supported in some special scenarios.
Data backups cannot be restored from a cluster instance of OceanBase Database V2.x or V3.x to that of OceanBase Database V4.x.
Data backups cannot be restored from a cluster instance of OceanBase Database V4.0 to that of OceanBase Database V4.1.
Considerations
The remaining resource specification of the target instance must be greater than or equal to that of the source instance.
The source tenant/database/table and the target tenant/database/table must have different names.
Only OceanBase V4.x supports physical restore at the database or table level.
Restore of column-store tables is not supported at the database or table level.
The successful restore of table data indicates that the table itself has been successfully restored, even if the restore of indexes, constraints, or other associated schemas fails.
Initiate a restore task
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 Initiate Restore.
On the Restore page, select a restore object, for example, a tenant, a database, or a table. Then, configure related parameters, as shown in the following tables.
Click OK. After the restore task is created, you can check the task status on the Data Restore tab.
Tenant restore task
| Parameter | Description |
|---|---|
| Restore Source | Select the source from which you need to restore data. |
| Restore Method | Specify whether to restore data by backup set or by timestamp.
|
| By Backup Set | Select the backup set you want to restore. |
| Source Tenant | Select the tenant whose data needs to be restored. |
| Restore Time Point | Select the point in time you want to restore. |
| Target Cluster Instance | Select the cluster instance to which you want to restore data. You can also click Create Instance to create a new cluster instance for restoring tenant data.
NoteGrayed-out cluster instances cannot be restored. You can view the specific reasons by hovering the mouse pointer over the cluster instance name. |
| Target Tenant Name | Enter the target tenant name to create a new tenant. The specific requirements are as follows:
|
| Number of Resource Units | Select the number of resource units for the target tenant. |
| Unit Specification | Select the CPU and memory specifications of the target tenant. You can click View Resource Distribution to view the resource allocation of each node.
|
| Primary Zone | Select the primary zone of the target tenant. |
| Remarks (optional) | The length of the remarks cannot exceed 30 characters. |
Database restore task
Note
When restoring a database or table, an auxiliary tenant must be created in the target instance. Please ensure that the target instance has at least the same CPU/Memory resources as the source tenant and sufficient disk resources. Insufficient resources may cause restore failure. The system will automatically delete the auxiliary tenant after the database or table restore is complete.
| Parameter | Description |
|---|---|
| Restore Method | Specify whether to restore data by backup set or by timestamp. |
| By Backup Set | Select the backup set you want to restore. |
| Source Tenant | Select the tenant whose data needs to be restored. |
| Restore Time Point | Select the point in time you want to restore. |
| Select Database Object | Select the database you want to restore, or search for it by entering the database name in the search box.
NoteYou can select a maximum of 200 databases, and databases with the same name are not allowed in the target tenant. |
| Target Instance | Select the cluster instance to which you want to restore data. |
| Target Tenant | Select the tenant to which you want to restore data. |
Table restore task
Note
When restoring a database or table, an auxiliary tenant must be created in the target instance. Please ensure that the target instance has at least the same CPU/Memory resources as the source tenant and sufficient disk resources. Insufficient resources may cause restore failure. The system will automatically delete the auxiliary tenant after the database or table restore is complete.
| Parameter | Description |
|---|---|
| Restore Method | Specify whether to restore data by backup set or by timestamp. |
| By Backup Set | Select the backup set you want to restore. |
| Source Tenant | Select the tenant whose data needs to be restored. |
| Restore Time Point | Select the point in time you want to restore. |
| Select Table Object | Select the table you want to restore, or search for it by entering the table name in the search box.
NoteYou can select a maximum of 200 tables, and tables with the same name are not allowed in the target database. |
| Target Instance | Select the cluster instance to which you want to restore data. |
| Target Tenant | Select the tenant to which you want to restore data. |
View a restore task
You can view the initiated restore task on the Data Restore tab.