麻烦发下OCP版本及业务集群OB的版本
ocp版本4.3.4,集群版本4.3.5
麻烦在用户租户下黑屏做下如下操作看备份是否可以成功,如果不成功麻烦发下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;
这里备份的目的地应该填写我在ocp中配置的file:///data/backup,还是在库中查到的file:///data/backup/shanxi_ob_second/1740541070/tenant_incarnation_1/1004/clog,需要清空原先的备份目录下的数据吗
再重新创建一个别的目录 ///data/backup/test,log_archive_dest及data_backup_dest 可以都指定到这个目录试下
归档的问题解决了,又回到一开始的问题了,今天早上备份出现的就是这个问题(
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)
按这个步骤 黑屏执行备份有报错吗?
黑屏3456步设置地址报错不支持ERROR 1235 (0A000): Not supported feature or function
麻烦截图看下
使用用户租户,不要用sys租户
在这个租户下查下
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.确认下之前备份是正常的吗?还是说刚配置备份就遇到了这个报错?
看不大懂啊
这个日志太少了,麻烦再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