勾选独立存储目录,自行填入S3域,日志不再报 no such host 错误,OCP页面仍提示备份存储目录无法被主机 [xx.xx.xx.xxx] 访问
日志中报错:Failed to check oss visitable of host address:183.xx.xx.105
截取部分日志如下:
2025-03-08 10:42:38.109 WARN 33402 --- [http-nio-0.0.0.0-28880-exec-8,cd2ff14bb2b45570,0ea278e81860a9ee] c.o.o.o.i.t.c.ObjectBackupStorageChecker : Failed to check oss visitable of host address:183.xx.xx.105
com.oceanbase.ocp.executor.exception.HttpRequestFailedException: [AgentClient]:http request is failed, response:check storage bucket failed, bucket: oceanbase, reason: operation error S3: HeadBucket, exceeded maximum number of attempts, 3, https response error StatusCode: 0, RequestID: , HostID: , request send failed, Head "https://218.xx.xx.149:4000/oceanbase": http: server gave HTTP response to HTTPS client
# 省略前面创建资源池部分
ALTER SYSTEM RESTORE slave_sg FROM 's3://oceanbase/xxx/1002/data?host=http://218.xx.xx.149:4000&access_id=66XM*****n9&access_key=yLfZyf***UaK,s3://oceanbase/xxx/1002/clog?host=http://218.xx.xx.149:4000&access_id=66XM*****n9&access_key=yLfZyf***UaK' UNTIL TIME='2025-03-10 05:54:09.314667' WITH 'pool_list=pool_slave_sg';
# 恢复完成后执行recover 设置UNLIMITED
ALTER SYSTEM RECOVER STANDBY tenant = slave_sg UNTIL UNLIMITED;