1、确认各个系统生产数据库归档磁盘空间大小
单机(文件系统):
查看/arch目录大小
集群:
查看archdg磁盘组空间大小
su - grid asmcmd lsdg
2、查询各个系统生产数据库每日归档量大小
–查询2024-03-01到2024-04-01的每日归档量大小
select to_char(completion_time, 'YYYY-MM-DD') as archivelog_date,round(sum(blocks * block_size) / 1024 / 1024 / 1024, 2) as archivelog_size_gb from gv$archived_log where to_char(completion_time, 'YYYY-MM-DD') BETWEEN '2024-03-01' AND '2024-04-01' group by to_char(completion_time, 'YYYY-MM-DD') order by to_char(completion_time, 'YYYY-MM-DD');