All Products
Search
Document Center

Database Backup:How do I restore data to another database instance by using DBS?

Last Updated:Mar 01, 2024

Database Backup (DBS) allows you to restore backup data to the source database instance or other existing database instances. DBS supports data restoration to a variety of database instances, such as ApsaraDB RDS instances and self-managed databases hosted on Elastic Compute Service (ECS) instances. You can use this feature to restore data after an accidental operation and analyze historical data. This topic describes how to restore data to an existing ApsaraDB RDS instance.

Prerequisites

The database that you want to restore is backed up. For more information, see Back up databases.

Procedure

Note

The specific restoration procedure varies based on database engines. For more information about the backup and restoration scenarios for different database engines, see Backup and restoration overview.

  1. Log on to the Database Backup (DBS) console.

  2. In the left-side navigation pane, click Backup Schedules. In the top navigation bar, select a region.

  3. On the Backup Schedules page, find the backup schedule that you want to use and click Manage in the Actions column.

  4. On the Configure Task page, click Restore Database in the upper-right corner.

  5. In the Set Time Restored To step of the Create Restore Task wizard, configure 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 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 source 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 point in time 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 the 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 database instance is running before you select Use Exists.

    Database Location

    The location of the destination database instance. In this example, RDS Instance is selected.

    Instance Region

    The region in which the destination database instance resides.

    RDS Instance ID

    The ID of the destination ApsaraDB RDS instance.

    Database Account

    The username of the account that is used to log on to the destination database instance.

    Password

    The password of the account that is used to log on to the destination database instance.

    SSL Encryption

    The connection method that is used to transmit 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.

      If you want to select SSL-encrypted, you must enable SSL encryption for the destination ApsaraDB RDS instance in advance. For more information, see Step 1: Enable the SSL encryption feature for an RDS instance.

  6. In the Configure Objects to Restore step, configure the parameters that are described in the following table and click Precheck.

    Parameter or setting

    Description

    Conflict Handling

    By default, Rename Object with the Same Name is selected for the Conflict Handling parameter. For example, if the job_info table shares the same name with another table during the restoration, the system renames the new table to job_info_dbs_<restoration task ID>_</timestamp> by default.

    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 reduces the amount of data to be restored and shortens the recovery time objective (RTO).

  7. If the Precheck Passed message appears in the Precheck dialog box, click Start Task.

    You can click Restore Tasks in the left-side navigation pane to view the database restoration progress.

    Note

    The duration of the restoration depends on the specification of the backup schedule and the size of the database. Less time is required for the restoration of a backup schedule with higher specifications. For more information, see Performance tests on backup and restoration.

Related operations

  • You can also directly create, start, or view a restoration task by calling an API operation. For more information, see CreateRestoreTask, StartRestoreTask, or DescribeRestoreTaskList.

  • If the backup data at the specified point in time does not meet your business requirements, you can click Start Full Data Backup in the upper-right corner of the Full Data page to manually back up the database. After the backup is complete, configure a restoration task to restore the database to the point in time of the latest full backup.

  • If an exception or error occurs in the restoration task, refer to Common Errors and Troubleshooting for troubleshooting.