If you have backed up an instance across regions, you can restore data from the backup file to a new instance or an existing instance in the region where the source instance is located or the region where the cross-region backup file is stored.

Precautions

If the source instance has enabled the database proxy feature and does not have a privileged account, you must reset the password to connect to the instance to which data is restored.

Restore cross-region backup data to a new instance

  1. Log on to the ApsaraDB for RDS console.
  2. In the left-side navigation pane, click Cross-region Backup.
  3. Find the destination RDS instance and click its ID.
    Cross-region restoration
  4. On the Database Backup tab, find the target backup set and click Restore in the corresponding Actions column.
    Select backup
  5. Select Restore to New Instance and click OK.
  6. On the Restore Database page, select Subscription or Pay-As-You-Go and configure the following parameters.
    Parameter Description
    Restore Mode
    • By Backup Set: Restore the data of the backup set to a new instance.
    • By Time: Restore data from a specified time point to a new instance. You can specify any time point within the log backup retention period.
    Backup Set When Restore Mode is set to By Backup Set, select the backup set that you want to restore.
    Restore Point When Restore Mode is set to By Time, select the time point to restore data.
    Note Local and cross-region logs can be restored to a specified time point.
    Region The region where the new instance is located.
    Zone An independent physical area within a region. There are no substantive differences between zones. You can choose to create RDS and ECS instances in the same zone or in different zones.
    CPU and Memory The type of the RDS instance. Each instance type supports a specific number of CPU cores, memory capacity, maximum number of connections, and maximum IOPS. For more information, see Primary instance types.
    Capacity The storage capacity used to store data files, system files, binary log files, and transaction files.
    Network Type
    • Classic Network: a traditional type of network.
    • VPC: the recommended network type. A VPC is an isolated virtual network with higher security and better performance than a classic network. If you select VPC, you must also select a VSwitch.
    Note The database engine and edition are consistent with those of the source instance and cannot be modified.
  7. Specify Duration (only applicable to subscription instances) and Quantity, and click Buy Now.
  8. On the Order Confirmation page, select the check box to agree the terms of service and complete the payment as prompted.

Restore cross-region backup data to an existing instance

  1. Log on to the ApsaraDB for RDS console.
  2. In the left-side navigation pane, click Cross-region Backup.
  3. Find the destination RDS instance and click its ID.
    Cross-region restoration
  4. On the Database Backup tab, find the target backup set and click Restore in the corresponding Actions column.
    Select backup
  5. Select Restore to Existing Instance and click OK.
  6. Configure the following parameters.
    Restore data to an existing RDS instance
    Parameter Description
    Restore Method
    • By Backup Set: Restore the data of the backup set to an existing instance.
    • By Time: Restore data from a specified time point to an existing instance. You can specify any time point within the log backup retention period.
    Region The region where the destination instance is located.
    Destination Instance The destination instance to which the data is restored.
    Databases and Tables to Restore Select the databases and tables that you want to restore.
    Selected Databases and Tables Specify the database and table names after the databases and tables are restored to the destination instance. If you do not specify a name, the name before migration will be added with a _backup suffix to form a new name.
  7. Click OK.

References

After an RDS instance is created, you must configure whitelists and create accounts for it. If you want to connect to the RDS instance over the Internet, you must also apply for a public endpoint. After you complete these operations, you can connect to the RDS instance.

Related operations

Operation Description
CheckCreateDdrDBInstance Checks whether the RDS instance has a cross-region backup set to perform the restoration.
CreateDdrInstance Restores cross-region backup data to a new instance.
ModifyInstanceCrossBackupPolicy Modifies the cross-region backup settings of an RDS instance.
DescribeInstanceCrossBackupPolicy Queries the cross-region backup settings.
DescribeCrossRegionBackups Queries the cross-region backup files of the data.
DescribeCrossRegionLogBackupFiles Queries the cross-region backup files of the logs.
DescribeAvailableCrossRegion Queries the available regions that support cross-region backup from the current region.
DescribeAvailableRecoveryTime Queries the time period that contains the backup data that can be restored.
DescribeCrossRegionBackupDBInstance Queries the cross-region backup settings of the instance in the selected region.