All Products
Search
Document Center

PolarDB:Overall process and estimated time

Last Updated:Mar 22, 2024

When accidental operations are performed on some tables, you can restore a table or several tables with accidental operations to the original cluster.

The data of databases or tables can be restored to a previous point in time and from a backup set (snapshot). The difference between the two restoration methods is whether the point in time to which you want to restore data is the point in time when a backup set was created. If the point in time to which you want to restore data is the point in time when a backup set was created, you can choose to restore data from a backup set (snapshot). Otherwise, you can only choose to restore data to a previous point in time.

Overall restoration process

These methods have the same key restoration process. The overall process includes the following steps:

1. Create a temporary node and restore data at a point in time to the node.

2. Restore the retrieved data to the original cluster.

The following figure shows the overall restoration process.

image
Note

We recommend that you restore data during off-peak hours.

Estimated time required for restoration

The following table describes estimated time required for restoration and is for reference only.

Step

Estimated time

Create a temporary node and restore data in the backup set to the node

About 3 minutes

Restore data by using redo logs

Note

Redo logs are used only when you want to restore data to a previous point in time. The restoration duration is related to the size of redo logs that are used.

1.5 GB/minute

Restore data to the original cluster

1.2 GB/minute

It may take a long time to restore terabytes of data in databases and tables. If you want to quickly restore the data, you can restore the data from a backup set (snapshot). This usually takes several minutes. For more information, see Method 1 for full restoration: Restore data from a backup set. If you restore the data from a backup set (snapshot), data in all tables is restored to a previous point in time. Proceed with caution.