oceanbase4.3.5全量备份还原的命令

租户ID变成了1006 又重新做了恢复吗?

select * from __all_virtual_replay_stat where tenant_id = 1006;

是的,昨天我有又重新试了一次,还是一直卡在upgrade

学习到了

加油

太赞了

select * from __all_virtual_ls_restore_progress where tenant_id=1006;

1006 17 1 127.0.0.1 2882 2025-08-07 18:53:39.070142 2025-08-07 18:57:16.014779 0 1754292381278119000 0 0 710 710 0 0 YB427F000001-00063BAD0D03F6B6-0-0 0
1006 17 1001 127.0.0.1 2882 2025-08-07 18:54:19.295603 2025-08-07 18:58:58.571395 10 1754292381278119000 0 0 4799 4799 0 0 YB427F000001-00063BAD0D03F6F0-0-0 0
1006 17 1002 127.0.0.1 2882 2025-08-07 18:54:20.563784 2025-08-07 18:55:21.023587 10 1754292381278119000 0 0 15 15 0 0 YB427F000001-00063BAD0D03F6A1-0-0 0

sys租户下执行备切主操作试下

ALTER SYSTEM ACTIVATE STANDBY TENANT xxx;

obclient(root@sys)[oceanbase]> ALTER SYSTEM ACTIVATE STANDBY TENANT mq_t1;
ERROR 4179 (HY000): tenant status is not normal, failover to primary is not allowed
obclient(root@sys)[oceanbase]>

恢复还卡在upgrade

确实没有恢复完成,我要咨询下研发老师看看

好的,感谢。

SELECT * FROM oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY WHERE module='physical_restore';

查下这个,然后发下rootservice.log

查询结果.zip (3.9 KB)

rootservice.log压缩发下

rootservice.zip (15.2 MB)

observer.log也发下

observer.log (16 MB)

参考这个帖子 已解决

1 个赞

感谢大家的点赞!感谢官方支持!谢谢大家,一起学习进步。

ALTER SYSTEM ACTIVATE STANDBY TENANT mq_t1

4179 - Tenant restore data mode is remote. Operation is not allowed
时间: 0.036s

ALTER SYSTEM ACTIVATE STANDBY TENANT = mq_t1

4179 - Tenant restore data mode is remote. Operation is not allowed
时间: 0.027s
这个怎么处理?