【 使用环境 】 测试环境
【 OB or 其他组件 】OB
【 使用版本 】企业单机版V4.2.5.6
【问题描述】将A服务器的备份目录和归档目录拷贝到B服务器,如何写命令进行恢复?
一、目前先试了预览,直接报错:
obclient(root@sys)[oceanbase]> ALTER SYSTEM RESTORE FROM ‘file:///home/obbackup_bucket/obbackup_dest,file:///home/obbackup_bucket/obarchive_dest’ UNTIL TIME = ‘2026-07-31 09:45:00’ PREVIEW;
Query OK, 0 rows affected (0.001 sec)
obclient(root@sys)[oceanbase]> SHOW RESTORE PREVIEW;
ERROR 9011 (HY000): cannot find backup file
二、执行真正的恢复命令也是报错:
obclient(root@sys)[oceanbase]> ALTER SYSTEM RESTORE zhj
→ FROM ‘file:///home/obbackup_bucket/obbackup_dest,file:///home/obbackup_bucket/obarchive_dest’ UNTIL TIME = ‘2026-07-31 09:45:00’
→ WITH ‘pool_list=pool_zhj&primary_zone=zone1’;
ERROR 9011 (HY000): cannot find backup file