All Products
Search

This Product

    Lindorm:Restore an instance by using its backup data

    Document Center

    Lindorm:Restore an instance by using its backup data

    Last Updated:Apr 27, 2026

    The data backup and restoration feature can minimize the loss caused by accidental operations performed on databases. This topic describes how to restore an instance by using its backup data.

    Prerequisites

    Usage notes

    • Lindorm V1 and single-node Lindorm instances do not support this feature.

    • Lindorm restores data to an instance by writing its backup data to the tables of the instance. Therefore, we recommend that you delete the data in a Lindorm table before you restore backup data to the table,

    Procedure

    1. Log on to the Lindorm console.

    2. In the upper-left corner of the page, select the region where the instance is deployed.

    3. On the Instances page, click the ID of the target instance or click View Instance Details in the Actions column for the instance.

    4. In the navigation pane on the left, click Wide Table Engine.

    5. Click the Backup & Recovery tab.

    6. In the Full Backup section, click Initiate Data Recovery.

    7. In the Recovery dialog box, configure the data recovery parameters based on your business needs.

      Parameter

      Description

      Cluster for Recovery

      The name of the Lindorm instance to which you want to restore your backup data.

      Important

      The backup data generated for a Lindorm instance cannot be restored to the instance after the instance is upgraded to a later version.

      Point in Time

      Specify a point in time to which you want to restore backup data.

      Full Database Recovery

      Select Yes to perform a full database recovery.

      Tables for Recovery

      If you select No for full database recovery, you must specify the tables to recover. Enter one namespace per line. Asterisks (*) are not supported.

      • To recover a table, use the format namespace:table. For example: default:testTable.

      • To recover a table to another table, use the format namespace:table/namespace:table2. For example: default:testTable/default:testTable2.

    8. Click OK. On the Recovery List tab, click Details in the Actions column to view the data recovery progress.

    FAQ

    • What is the most recent point in time to which I can restore data?

      If no pending tasks exist, the most recent point in time varies based on the cycle in which the system backs up write-ahead logs (WAL) to Object Storage Service (OSS). By default, the system backs up WAL data at an interval of 30 seconds or performs a backup operation for each 30 MB of WAL data. If a failure occurs, you may fail to restore the data that is written to a Lindorm instance within the 30-second period before the present time.

    • How much time does the system require to restore data?

      The period of time that the system requires to restore data varies based on the data size and bandwidth.

      • Full data restoration: Backup data can be read from OSS at a speed up to 1 GB/s. Each Lindorm Tunnel Service (LTS) node can write backup data to a Lindorm instance at a speed of 100 MB/s.

      • Incremental data restoration: Backup data can be written to each node in a Lindorm instance at a speed of 30 MB/s to 40 MB/s. Each LTS node can write backup data to a Lindorm instance at a speed of 100 MB/s.

    • Can I restore backup data to a single table?

      Yes, you can restore backup data to a single table. If a table with the same name already exists, you can restore the backup data to another table.