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

OceanBase 技术问题
#74

太赞了

#75 
select * from __all_virtual_ls_restore_progress where tenant_id=1006;
#76

企业微信截图_17546341106803
企业微信截图_175463411068032032×121 10.5 KB

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
#77

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

ALTER SYSTEM ACTIVATE STANDBY TENANT xxx;
#78

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

image
image1590×218 16.9 KB

#79

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

1 个赞
#80

好的，感谢。

1 个赞
#81 
SELECT * FROM oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY WHERE module='physical_restore';

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

1 个赞
#82

查询结果.zip (3.9 KB)

#83

rootservice.log压缩发下

1 个赞
#84

rootservice.zip (15.2 MB)

1 个赞
#85

observer.log也发下

1 个赞
#86

observer.log (16 MB)

1 个赞
#87

参考这个帖子 已解决

2 个赞
#88

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

1 个赞
#89

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
这个怎么处理？

1 个赞
#90

混个回复。。。

1 个赞
#91

学习了

#92

学习学习

#93

收藏了