This topic describes how to copy information of a restore task.
You can copy a restore task by using the following methods:
Method 1: Log in to the OceanBase Cloud Platform (OCP) console. In the left-side navigation pane, choose Backup & Recovery > Recovery. You can copy a restore task on the Recovery Tasks tab.
Method 2: Log in to the OCP console and go to the Overview page of a cluster. In the left-side navigation pane, choose Backup & Recovery > Recovery. You can copy a restore task of the cluster on the Recovery Tasks tab.
Method 3: Log in to the OCP console and go to the Overview page of a tenant. In the left-side navigation pane, choose Backup & Recovery > Recovery. You can copy a restore task of the tenant on the Recovery Tasks tab.
Prerequisites
The task to be copied is in the Completed state.
To copy a restore task by using Method 1, make sure that you have the following permissions:
- Resource permissions: Cluster management or tenant management permission.
- Menu permissions: Permission on the Restore menu of backup and restore.
To copy a restore task by using Method 2, make sure that you have the following permissions:
- Resource permissions: Cluster management permission.
- Menu permissions: Permission on the Backup & Recovery menu of clusters.
To copy a restore task by using Method 3, make sure that you have the following permissions:
- Resource permissions: Cluster management or tenant management permission.
- Menu permissions: Permission on the Backup & Recovery menu of tenants.
Procedure
The procedure of Method 1 is described as follows:
Log in to the OCP console.
Log in to the OCP console. In the left-side navigation pane, choose Backup & Recovery > Recovery. The Recovery Tasks tab automatically appears.
On the Recovery Tasks tab, find the target task, click Copy in the Actions column.
On the Copy Restore Task page, specify the restore source.
Restore a tenant
Parameter Description Source Cluster The source cluster for data restore. The default value is the cluster to which the current tenant belongs. Source Tenant The source tenant for data restore. The default value is the current tenant. Object to Restore Select Tenant. Recovery Date Select a date within the specified restorable time range. Restore databases
Note
This feature is supported only in OceanBase Database V4.x.
Parameter Description Source Cluster The source cluster for data restore. The default value is the cluster to which the current tenant belongs. Source Tenant The source tenant for data restore. The default value is the current tenant. Object to Restore Select Database. Recovery Date Select a date within the specified restorable time range. Restore Database Object Select the databases to be restored in the Restorable Objects list on the left and click > to add them to the Selected Objects list on the right. The database names must be unique. OCP allows you to rename databases, as shown in the following figure: Note
You can select at most 200 database objects.
Restore tables
Note
- Only user tables can be restored. Columnstore tables, temporary tables, views, materialized views, materialized view logs, or indexes cannot be restored separately.
- The table restore is considered successful when the table data is restored, even if the indexes, constraints, or other associated schemas fail to be restored.
Parameter Description Source Cluster The source cluster for data restore. The default value is the cluster to which the current tenant belongs. Source Tenant The source tenant for data restore. The default value is the current tenant. Object to Restore Select Table. Recovery Date Select a date within the specified restorable time range. Restore Table Object Select the tables to be restored in the Restorable Objects list on the left and click > to add them to the Selected Objects list on the right. The table names must be unique. OCP allows you to rename tables, as shown in the following figure: Note
You can select at most 200 table objects.
Specify the restore target.
Restore a tenant
Parameter Description Destination Cluster Select a target cluster. Destination Tenant Select a target tenant. Number of Units in Each Zone The maximum number of units allowed depends on the minimum number of OBServer nodes in a zone. Restore databases
Note
During a database or table restore, you need to create an auxiliary tenant in the target cluster. We recommend that the specifications of the auxiliary tenant be consistent with those of the source tenant, and that the target cluster have sufficient CPU, memory, and disk resources. If the resources are insufficient, the restore may be slow or fail. After the restore is completed, the system will delete the auxiliary tenant by default.
Parameter Description Destination Cluster Select a target cluster. Destination Tenant Select a target tenant. Number of Units in Each Zone The maximum number of units allowed depends on the minimum number of OBServer nodes in a zone. Restore tables
Note
During a database or table restore, you need to create an auxiliary tenant in the target cluster. We recommend that the specifications of the auxiliary tenant be consistent with those of the source tenant, and that the target cluster have sufficient CPU, memory, and disk resources. If the resources are insufficient, the restore may be slow or fail. After the restore is completed, the system will delete the auxiliary tenant by default.
Parameter Description Destination Cluster Select a target cluster. Destination Tenant Select a target tenant. Number of Units in Each Zone The maximum number of units allowed depends on the minimum number of OBServer nodes in a zone.
Specify the following zone-related parameters and set the priorities of the zones.
Parameter Description Replica Type Valid values: - Full-featured Replica: A standard replica that contains all the data categories and all the features, including MemTables, SSTables, and transaction logs. A full-featured replica can switch to the leader role efficiently to provide services.
- Log Replica: A replica that contains only logs. It does not have a MemTable or an SSTable. It provides log services for external applications and participates in log voting. It can facilitate the restore of other replicas, but it cannot become the leader to provide database services.
- Read-only Replica: A replica that contains full logs, MemTables, and SSTables. You can select this type of replica for applications that does not require high consistency in data reading.
Unit Specification The specifications of the resources that the replica occupies. - You can select an existing specification.
- You can also create a specification as needed and select the created specification.
Units The number of resource units occupied by the replica. Notice
If the version of the target cluster is V4.0 or later, you can only set the same number of units for all zones. In other words, the number of units that you specify on this page applies to all zones under the restored tenant.Click Copy.