租户ID变成了1006 又重新做了恢复吗?
select * from __all_virtual_replay_stat where tenant_id = 1006;
租户ID变成了1006 又重新做了恢复吗?
select * from __all_virtual_replay_stat where tenant_id = 1006;
学习到了
加油
太赞了
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
rootservice.log压缩发下
observer.log也发下
参考这个帖子 已解决
感谢大家的点赞!感谢官方支持!谢谢大家,一起学习进步。
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
这个怎么处理?