在社区版4.5下,做租户恢复
alter system restore omsoracle_dg1
from ‘file:///backup/full,file:///backup/archive’
with ‘pool_list=pool_oms_oracle1’;
时,cdb_ob_restore_history的STATUS列的值,先后经过restoring和PHYSICAL_RESTORE_WAIT_QUICK_RESTORE_FINISH,然后就fail了。fail的原因是module: RESTORE_DATA, result: -4012(Timeout) 。
从PHYSICAL_RESTORE_WAIT_QUICK_RESTORE_FINISH到fails历经了8个多小时。
后来尝试多次,都是从PHYSICAL_RESTORE_WAIT_QUICK_RESTORE_FINISH到fails要历经很长时间。
1 个赞
旭辉
#5
发下详细版
show variables like '%version_comment%';
oceanbase-all-in-one-4.5.0_20251127.el7.x86_64.tar 这个
旭辉
#7
查一下这个
SELECT * FROM oceanbase.DBA_OB_ROOTSERVICE_EVENT_HISTORY WHERE module='physical_restore';
OceanBase_CE 4.5.0.0 (r100000012025112711-0e8d5ad012baf0953b2032a35a88bdf8886e9a7a) (Built Nov 27 2025 12:06:16)
我把集群删掉,重新创建集群。 再做恢复,虽然没有报错了,但是花费的时间也比较长,我是一个空租户。
2025-12-30 17:50:47.062474 | dg3 | CREATE_TENANT |
| 2025-12-30 17:51:16.973778 | dg3 | WAIT_TENANT_RESTORE_FINISH |
| 2025-12-30 17:52:08.632945 | dg3 | RESTORE_CREATE_INIT_LS |
| 2025-12-30 17:52:09.270475 | dg3 | PHYSICAL_RESTORE_WAIT_RESTORE_TO_CONSISTENT_SCN |
| 2025-12-30 18:05:31.976539 | dg3 | PHYSICAL_RESTORE_WAIT_QUICK_RESTORE_FINISH |
| 2025-12-30 19:00:32.736767 | dg3 | RESTORE_WAIT_LS |
| 2025-12-30 19:00:35.814827 | dg3 | POST_CHECK |
| 2025-12-30 19:00:35.913901 | dg3 | UPGRADE |
| 2025-12-30 19:01:35.969868 | dg3 | RESTORE_SUCCESS |
| 2025-12-30 19:01:36.037474 | dg3 | |
| 2025-12-30 19:02:17.837651 | dg3 | RESTORE_SUCCESS |
| 2025-12-30 19:02:18.012520 | dg3 |