Promo Center

50% off for new user

Direct Mail-46% off

Learn More

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

Updated at: 2025-02-17 10:03

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

    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

    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 to be restored shares the same name with a table in the destination database, the system renames the restored table in the following format: job_info_dbs_<Restore task ID>_<Timestamp>.

    Objects to Restore

    Select the database or table that you want to restore in the Available section and click the rightwards arrow to add it to the Selected section.

    Note

    DBS allows you to restore some databases by database or table. This reduces the amount of data to be restored and shortens the recovery time objective (RTO). For more information about the supported restoration granularity, see Database engines and features.

  7. If 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 restoration duration depends on the specifications of the backup schedule and the size of the database to be restored. The restoration duration is shorter for 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.

  • On this page (1, O)
  • Prerequisites
  • Procedure
  • Related operations
Feedback
phone Contact Us

Chat now with Alibaba Cloud Customer Service to assist you in finding the right products and services to meet your needs.

alicare alicarealicarealicare