ocp 不支持 发起备份至 minio吗

你黑屏 设置归档路径和备份路径的命令 也再发下吧

obclient(root@test01)[(none)]> alter system noarchivelog;
ERROR 9092 (HY000): Already in NOARCHIVELOG mode
obclient(root@test01)[(none)]> alter system set log_archive_dest= '';
Query OK, 0 rows affected (0.016 sec)

obclient(root@test01)[(none)]> alter system set data_backup_dest= '';
Query OK, 0 rows affected (0.076 sec)

obclient(root@test01)[(none)]> alter system set log_archive_dest='LOCATION=s3://oceanbase-backup/log/test01?host=https://k8s-minio-api-jw.crgdpharm.com&access_id=******&access_key=******&addressing_model=path_style';
Query OK, 0 rows affected (1.037 sec)

obclient(root@test01)[(none)]> alter system set data_backup_dest='s3://oceanbase-backup/data/test01?host=https://k8s-minio-api-jw.crgdpharm.com&access_id=******&access_key=*****&addressing_model=path_style';
Query OK, 0 rows affected (1.808 sec)

obclient(root@test01)[(none)]> ALTER SYSTEM ARCHIVELOG;
Query OK, 0 rows affected (0.014 sec)

obclient(root@test01)[(none)]> ALTER SYSTEM BACKUP DATABASE;
ERROR 9040 (HY000): backup can not start, because log archive status is not doing.

obclient(root@test01)[(none)]> SELECT * FROM oceanbase.DBA_OB_ARCHIVELOG\G
*************************** 1. row ***************************
                     DEST_ID: 1038
                    ROUND_ID: 4
                 INCARNATION: 1
                     DEST_NO: 0
                      STATUS: BEGINNING
                   START_SCN: 1767151768827187000
           START_SCN_DISPLAY: 2025-12-31 11:29:28.827187
              CHECKPOINT_SCN: 1767151768827187000
      CHECKPOINT_SCN_DISPLAY: 2025-12-31 11:29:28.827187
                  COMPATIBLE: 1
               BASE_PIECE_ID: 4
               USED_PIECE_ID: 4
       PIECE_SWITCH_INTERVAL: 86400000000
                   UNIT_SIZE: 1
                 COMPRESSION: none
                 INPUT_BYTES: 0
         INPUT_BYTES_DISPLAY: 0.00MB
                OUTPUT_BYTES: 0
        OUTPUT_BYTES_DISPLAY: 0.00MB
           COMPRESSION_RATIO: 0.00
         DELETED_INPUT_BYTES: 0
 DELETED_INPUT_BYTES_DISPLAY: 0.00MB
        DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
                     COMMENT: 
                        PATH: s3://oceanbase-backup/log/test01?host=https://k8s-minio-api-jw.crgdpharm.com
1 row in set (0.011 sec)

我重新创建了个租户测试了下,黑屏执行后,ocp能看到备份发起了,数据显示备份成功了,然后日志好像卡着很久没完成,这个实时的进度好像看不了,不知道具体卡在哪了

ALTER SYSTEM BACKUP DATABASE;

上面的日志我等下分析,
你这里的OCP备份已经正常了,没有卡,OCP的这个参数 ocp.backup.object-storage-sdk.invoke.https 调整了吗?

你上面说的“黑屏执行后” 是指执行了什么?

就是按您告诉我的黑屏备份这个步骤,按照这个步骤在新租户直接执行是没问题了,然后OCP的这个参数 ocp.backup.object-storage-sdk.invoke.https 调整了false

alter system noarchivelog;
alter system set log_archive_dest= '';
alter system set data_backup_dest= '';
设置归档路径和备份路径
ALTER SYSTEM ARCHIVELOG;
ALTER SYSTEM BACKUP DATABASE;

那就是正常了,OCP上是配置备份策略了吗?

ocp还没配置测试,等会我试试,然后如果我要做恢复测试的话,是不是也得等日志这个备份完了才能测,

还是说可以备份日志的同时,先测试一下数据恢复的这个测试呢

ocp还没配置测试,你是说黑屏配置的备份 在OCP上显示了?

对,就执行完这条ALTER SYSTEM BACKUP DATABASE; 之后就在ocp上显示一个备份任务了

这个日志这里是在做归档,你黑屏发起的,如果不手动停止,它会一直进行下去,不影响你做恢复测试

目前测试了几天好像没有什么问题,感谢旭辉老师耐心解答 :handshake: :handshake: :handshake:

不客气,后续有其它问题,欢迎发帖提问