场景: 搭建CDC,主集群备份,到备集群恢复, 恢复找不到文件,NFS所有observer均已挂载
– # 集群 B ALTER SYSTEM RESTORE tenant01 FROM tenant01 at ‘file:///nfs/backup’ until ‘2021-11-30 15:57:56.664416’ with ‘backup_cluster_name=cluster_standby&backup_cluster_id=1&pool_list=restore_pool’; ERROR 9011 (HY000): cannot find backup file tree -L 4 /nfs/backup/ /nfs/backup/ └── obcluster └── 1 └── incarnation_1 ├── 1 ├── 1001 ├── clog_info ├── cluster_backup_piece_info ├── cluster_backup_set_file_info ├── cluster_clog_backup_info ├── cluster_data_backup_info ├── tenant_info └── tenant_name_info
SELECT * FROM CDB_OB_BACKUP_SET_DETAILS;
| INCARNATION | TENANT_ID | BS_KEY | COPY_ID | BACKUP_TYPE | ENCRYPTION_MODE | START_TIME | COMPLETION_TIME | ELAPSED_SECONDES | KEEP | KEEP_UNTIL | DEVICE_TYPE | COMPRESSED | OUTPUT_BYTES | OUTPUT_RATE_BYTES | COMPRESSION_RATIO | OUTPUT_BYTES_DISPLAY | OUTPUT_RATE_BYTES_DISPLAY | TIME_TAKEN_DISPLAY | STATUS |
| 1 | 1 | 1 | 0 | D | PASSWORD | 2021-11-30 15:21:35.436539 | 2021-11-30 15:22:25.964115 | 51 | NO | | FILE | NO | 2357821 | 46664.0434 | 0.03 | 2.25MB | 0.04MB/S | 00:00:50.527576 | COMPLETED |
| 1 | 1 | 2 | 0 | I | NONE | 2021-11-30 15:25:22.023126 | 2021-11-30 15:26:07.380695 | 45 | NO | | FILE | NO | 2522186 | 55606.7280 | 0.03 | 2.41MB | 0.05MB/S | 00:00:45.357569 | COMPLETED |
| 1 | 1 | 3 | 0 | D | PASSWORD | 2021-11-30 15 :55 :54.050956 | 2021-11-30 15 :56 :36.763349 | 43 | NO | | FILE | NO | 3234575 | 75729.1918 | 0.04 | 3.08 MB | 0.07 MB/S | 00 :00 :42.712393 | COMPLETED |
| 1 | 1 | 4 | 0 | I | PASSWORD | 2021-11-30 15 :57 :14.056002 | 2021-11-30 15 :57 :56.875010 | 43 | NO | | FILE | NO | 3398941 | 79379.2561 | 0.03 | 3.24 MB | 0.08 MB/S | 00 :00 :42.819008 | COMPLETED |
| 1 | 1001 | 1 | 0 | D | PASSWORD | 2021-11-30 15:21:35.436539 | 2021-11-30 15:22:25.736865 | 50 | NO | | FILE | NO | 2357821 | 46874.8652 | 0.03 | 2.25MB | 0.04MB/S | 00:00:50.300326 | COMPLETED |
| 1 | 1001 | 2 | 0 | I | NONE | 2021-11-30 15:25:22.023126 | 2021-11-30 15:26:07.164308 | 45 | NO | | FILE | NO | 2522186 | 55873.2822 | 0.03 | 2.41MB | 0.05MB/S | 00:00:45.141182 | COMPLETED |
| 1 | 1001 | 3 | 0 | D | PASSWORD | 2021-11-30 15:55:54.050956 | 2021-11-30 15:56:36.539408 | 42 | NO | | FILE | NO | 3234575 | 76128.3325 | 0.04 | 3.08MB | 0.07MB/S | 00:00:42.488452 | COMPLETED |
| 1 | 1001 | 4 | 0 | I | PASSWORD | 2021-11-30 15:57:14.056002 | 2021-11-30 15:57:56.664416 | 43 | NO | | FILE | NO | 3398941 | 79771.5916 | 0.03 | 3.24MB | 0.08MB/S | 00:00:42.608414 | COMPLETED |
ALTER SYSTEM RESTORE tenant01 FROM tenant01 at 'file:///nfs/backup' until '2021-11-30 15:57:56.664416' with 'backup_cluster_name=cluster_standby&backup_cluster_id=1&pool_list=restore_pool' ;
-- 这里 backup_cluster_name 是指备份结果中的 obcluster 吗?
-- obcluster就是集群名?
-- pool_list 是指为恢复新建的 resource pool 吗?
宁封
2021 年12 月 1 日 11:10
#8
-- 这里 backup_cluster_name 是指备份结果中的 obcluster 吗? 是的
-- obcluster就是集群名? 没有看到obcluster在哪里,backup_cluster_name是集群名字
-- pool_list 是指为恢复新建的 resource pool 吗? 对的