4.x前使用的cdb_ob_backup_set_details 这个视图，4.x后应该查看哪个视图？
– 查询数据备份占用磁盘空间
select
DATE_FORMAT(start_timestamp, ‘%Y-%m-%d’) as ‘备份日期’,
CASE DATE_FORMAT(start_timestamp, ‘%w’)
WHEN 1 THEN ‘星期一’
WHEN 2 THEN ‘星期二’
WHEN 3 THEN ‘星期三’
WHEN 4 THEN ‘星期四’
WHEN 5 THEN ‘星期五’
WHEN 6 THEN ‘星期六’
WHEN 0 THEN ‘星期日’
END
as ‘星期几’,
case
when backup_type = ‘FULL’ then ‘全备’
when backup_type = ‘INC’ then ‘增量备份’
else null
end
as ‘备份类型’,
CASE
WHEN status = ‘SUCCESS’ THEN ‘成功’
WHEN status = ‘FAILED’ THEN ‘失败’
ELSE NULL
END
as ‘备份状态’,
case
when file_status = ‘DELETED’ THEN ‘备份文件已删除’
WHEN file_status = ‘AVAILABLE’ THEN ‘有效备份’
WHEN file_status = ‘INCOMPLETE’ THEN ‘备份文件缺失’
WHEN file_status = ‘EXPIRED’ THEN ‘备份文件失效’
WHEN file_status = ‘COPYING’ THEN ‘文件备份中’
WHEN file_status = ‘DELETING’ THEN ‘备份文件删除中’
WHEN file_status = ‘BROKEN’ THEN ‘备份文件不完整’
ELSE NULL
END
as ‘备份文件状态’,
SEC_TO_TIME(elapsed_secondes) AS ‘备份总时长’,
result,
round(output_bytes / 1024 / 1024 / 1024, 2) as ‘备份文件大小(G)’,
PATH
from
CDB_OB_BACKUP_SET_FILES;
1 个赞
3.x与4.x的视图发生了变化，没有严格对应，你可以试试看看 哪个更满足你的需求
https://www.oceanbase.com/docs/common-oceanbase-database-cn-standalone-1000000002701800