ocp日志备份无法启动,显示归档已开启

image
image

麻烦发下OCP版本及业务集群OB的版本

1 个赞

ocp版本4.3.4,集群版本4.3.5

1 个赞

麻烦在用户租户下黑屏做下如下操作看备份是否可以成功,如果不成功麻烦发下RS节点的observer.log和rootservice.log

RS节点的IP:select svr_ip from dba_ob_servers where with_rootserver='yes';
1.Alter system noarchivelog;
2.等2分钟

3.alter system set log_archive_dest= ' ';
4.alter system set data_backup_dest= ' ';
5.alter system set log_archive_dest= 'LOCATION=file:///xxx';
6.alter system set data_backup_dest= 'file:///xxx';
87.Alter system archivelog;
7.alter system backup database;
1 个赞

这里备份的目的地应该填写我在ocp中配置的file:///data/backup,还是在库中查到的file:///data/backup/shanxi_ob_second/1740541070/tenant_incarnation_1/1004/clog,需要清空原先的备份目录下的数据吗

1 个赞

再重新创建一个别的目录 ///data/backup/test,log_archive_dest及data_backup_dest 可以都指定到这个目录试下

1 个赞

:smiling_face_with_tear:归档的问题解决了,又回到一开始的问题了,今天早上备份出现的就是这个问题(
ROOTSERVICE)addr: 10.104.106.173:2882, result: -9120(cannot find object on object storage), trace_id: YB420A686AAD-00062F087091B94B-0-0
我传一下详细的日志
subtask_1016589.log (10.7 KB)

1 个赞

按这个步骤 黑屏执行备份有报错吗?

1 个赞

黑屏3456步设置地址报错不支持ERROR 1235 (0A000): Not supported feature or function

麻烦截图看下

使用用户租户,不要用sys租户


没有报错,应该算备份成功了吧,ocp上还是不行

好像并没有,我执行完ocp上也多了一条记录,还是失败


我找一下日志

在这个租户下查下

SELECT * FROM oceanbase.DBA_OB_BACKUP_JOBS;
SELECT * FROM oceanbase.DBA_OB_BACKUP_JOB_HISTORY order by START_TIMESTAMP desc;


三次都是失败,同样的问题

1.麻烦使用obdiag巡检下集群
obdiag check run
https://www.oceanbase.com/docs/common-obdiag-cn-1000000002488230

2.麻烦把这个时间的RS节点的observer.log和rootservice.log发下

RS节点IP:select svr_ip from dba_ob_servers where with_rootserver=‘yes’;


2025-03-19 15:02:40.333  WARN 3137618 --- [manual-subtask-executor16,ce413c6b136c4588,09e7b7790593a14d] c.o.o.b.i.t.s.WaitDataBackupSuccessTask  : check backup task failed: [DataBackupHistoryWrapperTask{taskId=2, backupType=FULL, clusterId=null, obTenantId=1004, backupSetId=2, backupDest=file:///data/back_up/shanxi_ob_second/1740541070/tenant_incarnation_1/1004/data, snapshotVersionTime=null, startTime=2025-03-19T07:02:09.233949Z, finishTime=2025-03-19T07:02:24.046106Z, status=FAILED, progress=null, errorMsg=(ROOTSERVICE)addr: 10.104.106.173:2882, result: -9120(cannot find object on object storage), trace_id: YB420A686AAD-00062F087091B94B-0-0}]

2025-03-19 15:02:40.334 ERROR 3137618 --- [manual-subtask-executor16,ce413c6b136c4588,09e7b7790593a14d] c.o.o.c.t.e.c.w.subtask.SubtaskExecutor  : Data backup task failed.

3.确认下之前备份是正常的吗?还是说刚配置备份就遇到了这个报错?

看不大懂啊

observer.log (210.9 KB)
rootservice.log (189.7 KB)
第一次配置集群的备份就出现这个问题了,单点的没问题

这个日志太少了,麻烦再10.104.106.173上 ,然后发下1.txt,2.txt

grep "YB420A686AAD-00062F087091B94B-0-0" observer.log > 1.txt
grep "YB420A686AAD-00062F087091B94B-0-0" rootservice.log > 2.txt