Database Backup (DBS) allows you to back up and restore databases. You can use DBS to restore backup data to the source database instance or other database instances. DBS supports restoration to a variety of database instances, such as ApsaraDB RDS instances and self-managed databases hosted on Elastic Compute Service (ECS) instances.

Prerequisites

At least one database backup is complete. For more information, see Back up databases.

Procedure

The following example shows you how to restore data to an existing ApsaraDB RDS instance. The restoration configurations vary for different database engines. For more information about the sample restoration configurations for different database engines, see Backup and restoration overview.

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Backup Schedules. On the Backup Schedules page, select a region in the upper-left corner.
  3. On the Backup Schedules page, find the backup schedule that you want to use to create a restore task, and click Manage in the Actions column.
  4. On the Configure Task tab, click Restore Database in the upper-right corner.
  5. In the Set Time Restored To step of the Create Restore Task wizard, set the parameters in the Set Time Restored To and Configure Destination Database sections. Then, click Next in the lower-right corner of the page.
    Section Parameter Description
    N/A Task Name

    The name of the restore task. DBS automatically generates a task name. We recommend that you specify a name that can help you identify the task. Task names do not need to be unique.

    Set Time Restored To Time Range Available to Restore

    The time range from the point in time when the first full backup set is created to the point in time when the latest full backup set is created. The database can be restored to a point in time within the time range.

    Restore To
    The point in time to which you want to restore the source database. The value must be within the time range that is specified by the Time Range Available to Restore parameter.
    Note
    • If the incremental backup feature is enabled, DBS allows you to restore the data to a point in time from the completion of the first full backup to the completion of the last incremental backup.
    • If the incremental backup feature is disabled, DBS allows you to restore the data to a point in time when a full backup is complete.
    Configure Destination Database Target database instance type Select Use Exists.
    Note Make sure that the destination instance is running before you select Use Exists.
    Database Location The location of the destination instance. In this example, select RDS Instance.
    Instance Region The region in which the destination instance resides.
    RDS Instance ID The ID of the destination ApsaraDB RDS instance.
    Database Account The Alibaba Cloud account that is used to log on to the destination database instance.
    Password The password that is used to log on to the destination database instance.
    SSL Encryption The method that is used to encrypt the backup data. Valid values:
    • Non-encrypted
    • SSL-encrypted: SSL encrypts network connections at the transport layer to improve the security and integrity of data in transit. However, SSL increases the network connection response time.

      SSL encryption must be enabled for the ApsaraDB RDS instance if you want to use SSL-encrypted. For more information, see Enable SSL encryption.

  6. In the Configure Objects to Restore step, set the parameters that are described in the following table. Then, click Precheck in the lower-right corner.
    Parameter Description
    Conflict Handling Select one of the following methods for conflict handling:
    • Fail When Object with the Same Name Exists
    • Rename Object with the Same Name. If you select this option, DBS renames the new table that is to be created by the restore task. For example, a table to be restored in the source database and an existing table in the destination database have the same name job_info. DBS renames the new table that is restored from the table in the source database in the following format: job_info_dbs_<ID of the restore task>_</Timestamp>.
    Objects to Restore Select the database or table that you want to restore in the Available section and click the right arrow to add it to the Selected section.
    Note DBS allows you to restore a single database or table. This feature reduces the amount of data to be restored and shortens the recovery time objective (RTO).
  7. After the Precheck Passed message appears in the Precheck dialog box, click Start Task.
    To view the database restoration progress, click Restore Tasks in the left-side navigation pane.
    Note The amount of time used to restore a database depends on the specifications of the backup schedule and the size of the database. Higher specifications offer a higher restoration speed. For more information, see Performance tests on backup and restoration.