Backup and Restore Issues

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 备份恢复问题

| username: TiDB超级萌新

Two machines: one for backup and one for recovery. Backup to S3. The recovery machine pulls from S3 for PITR. At this point, does the backup machine need to disable log backup?

| username: lemonade010 | Original post link

I didn’t quite understand. Are you asking whether the log backup of the backup set needs to be turned off, or whether the log backup of the restore machine needs to be turned off?

| username: xfworld | Original post link

When restoring, you will be prompted to choose a recovery time, which is essentially selecting a snapshot for recovery.

As for whether to shut down, it will not affect the recovery process. Please refer to…

| username: TiDB超级萌新 | Original post link

The backup. There are two clusters: one backup cluster and one recovery cluster. The recovery cluster is brand new with nothing enabled.

| username: TiDB超级萌新 | Original post link

To restore on the original machine, you need to disable log backup. But if you start a new machine for restoration, you don’t need to disable log backup, right?

| username: redgame | Original post link

No need to close.

| username: xfworld | Original post link

It’s not about the machine, it’s calculated based on the cluster. The original cluster cannot be restored. Unless you remove all related data from the original cluster and choose a backup from S3… This is very risky, don’t do it this way…

It is generally recommended to use a new cluster for recovery…

| username: 江湖故人 | Original post link

PITR only supports recovery to a brand new empty cluster.
The data restored by BR does not have logs, so it cannot be synchronized through CDC and binlog, which is unrelated to whether the logs are enabled or not.

| username: dba远航 | Original post link

The restoration is to a new cluster, the original one does not need to be shut down.

| username: DBAER | Original post link

For creating a new cluster recovery, you can also look into FLASHBACK DATABASE for data recovery.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.