Can data be recovered if only one KV is backed up out of three copies of 3KV?

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

Original topic: 3副本3kv 只有1个kv备份了能恢复数据么

| username: tidb狂热爱好者

Can data be recovered if there are 3 replicas and 3 KVs but only 1 KV is backed up?

| username: 小龙虾爱大龙虾 | Original post link

| username: tidb菜鸟一只 | Original post link

Column - Methods for Lossy Recovery of Multiple Damaged Replicas in TiDB | TiDB Community

| username: Kongdom | Original post link

:flushed: Having only one KV backup might not be sufficient. During restoration, integrity should be verified. If it’s incomplete, it probably can’t be restored.

| username: YuchongXU | Original post link

Not possible.

| username: jiayou64 | Original post link

It should be because the recovery is incomplete.

| username: zhanggame1 | Original post link

Incomplete recovery does not guarantee data consistency.

| username: zhaokede | Original post link

Incomplete recovery should be able to restore most of the data.

| username: zhh_912 | Original post link

It should not be possible.

| username: chenhanneu | Original post link

Can data be recovered if only one of the three KV copies is backed up?
How was the backup done if only one KV copy was backed up?

| username: zhaokede | Original post link

Physical Backup by Operating System Copy

| username: terry0219 | Original post link

No, you can’t.

| username: 我是吉米哥 | Original post link

If backups are made through virtual machine snapshots, the backups of the three TiKV nodes are not consistent. In theory, as long as the snapshot backup of one node is normal, the database can be restored, but it requires the original TiDB developers to perform an unconventional recovery.

| username: cchouqiang | Original post link

You can try using online-unsafe-recovery, 专栏 - 使用Online unsafe recovery恢复v6.2同城应急集群 | TiDB 社区

| username: 随缘天空 | Original post link

What do you mean by only one TiKV backup? Is it the SST file backup on one machine? If it is the SST file backup of a single machine, it cannot be restored.

| username: TiDBer_xTvoCh2f | Original post link

No, that would mean losing data.

| username: tidb狂热爱好者 | Original post link

Unified reply: This data can be restored.

| username: TiDBer_TQXaqJ6U-6236 | Original post link

Three replicas, losing one is acceptable; if two are lost, data cannot be recovered.

| username: 濱崎悟空 | Original post link

It may not be fully recoverable.

| username: tidb狂热爱好者 | Original post link

Even if two out of three replicas are broken, it can still recover.