The ApsaraDB OceanBase console provides a high-availability, high-performance backup feature for OceanBase cluster instances.
Backup methods
OceanBase supports the following two backup methods:
Automatic scheduled backup:
This method automatically and periodically backs up data based on a preset backup policy. You can set full backups to start at a fixed time weekly or monthly. This method also supports concurrent log backups and the periodic purging of expired data. After you create a backup policy, backups run automatically at scheduled intervals.
Immediate backup:
You can manually perform a one-time physical or logical backup. A physical backup cannot be performed if another data backup job for the cluster instance is in progress.
Data backup
Log on to the OceanBase Management Console.
In the navigation pane on the left, click Instance List.
In the instance list, find the target cluster instance and click its name to go to the Cluster Instance Workspace page.
In the navigation pane on the left, click Backup and Recovery > Data Backup to view the data backup list.
The Data Backup tab displays an overview of all executed backup jobs, including Backup Set ID, Backup Object, Backup Method, Backup Type, Restorable Time Point, Start Time, End Time, Backup Duration, File Size, Execution Method, Valid, Status, and Operations.
You can sort the jobs by start time and file size.
You can hover the mouse pointer over a table object to view the Tenant, Database, Restorable Time Point, and Table Name for the logical backup.
In the Operations column, you can Restore, Delete, or Download a backup set.
NoteThe backup set download feature requires whitelisting. To enable this feature, contact OceanBase technical support.
Downloading backup sets is not currently supported for Serverless instances.
If the conditions for an operation are not met, the corresponding button is unavailable. For example, physical backups cannot be deleted. Backups that are in the running state cannot be restored, deleted, or downloaded.
Backup and recovery
In the Operations column, click ... > Restore to open the backup and recovery page. For more information about the restore operation, see Initiate a recovery.
Delete a backup
When a logical backup is no longer needed, you can delete the backup set to free up space and reduce your storage fees.
Deleting physical backups is not currently supported.
In the Operations column, click ... > Delete.
Click Confirm to delete the backup.
Download a backup set
In addition to backing up data, OceanBase Database also packages, compresses, and converts backup files into a downloadable format.
The time required for compression and conversion depends on the size of the backup file. Larger files take longer. For example, a 150 GB file takes about 4 hours to process. This is for reference only.
To download a backup file, the following conditions must be met:
The backup set download feature is enabled on the whitelist. If you need this feature, contact OceanBase technical support.
The backup status must be Completed, and the backup set must be a full backup that has not been deleted.
Procedure:
In the Operations column, click Download.
In the pop-up window, confirm that the full backup set download information is correct. Then, click Generate Download URL to start generating the download file.
After the task is complete, click View Download URL in the Operations column. You can view information about the full backup set and its internal and external download URLs. Copy the internal download URL for file transfers within the internal network. Copy the external download URL to download the file over the internet. The download URL is valid for one hour. If it expires, click Refresh to generate a new one.
NoteOnly internal download URLs are provided for the Gold Zone.
Downloading a backup set using an external URL incurs network traffic fees. This service is free for a limited time.
Logical backups can only be downloaded over the internal network.
Keep the download URL secure to prevent data leaks and ensure data security.
Downloading log backups is not currently supported.
After you obtain the download URL, use a tool or command that supports resumable downloads. The following are examples:
Download the backup set over the internal network using the wget command:
wget http://****.oss-cn-hangzhou-internal.aliyuncs.com/****Download the backup set over the internet using the curl command:
curl -O http://****.oss-cn-hangzhou.aliyuncs.com/****