你黑屏 设置归档路径和备份路径的命令 也再发下吧
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上显示一个备份任务了
这个日志这里是在做归档,你黑屏发起的,如果不手动停止,它会一直进行下去,不影响你做恢复测试
目前测试了几天好像没有什么问题,感谢旭辉老师耐心解答
![]()
不客气,后续有其它问题,欢迎发帖提问

