登录到rman

RMAN TARGET /

检查归档日志状态

RMAN> LIST ARCHIVELOG ALL;

列出过期的归档日志

RMAN> list expired archivelog all;

删除归档日志-删除过期的归档日志

RMAN> delete archivelog all obsolete;

RMAN> DELETE EXPIRED archivelog all;

删除归档日志-基于截止时间删除:

RMAN> DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-10';  -- 删除10天前的所有归档日志

RMAN> delete force archivelog all completed before 'sysdate-1';

删除归档日志-基于序列号删除:

DELETE ARCHIVELOG ALL UNTIL SEQUENCE 300;  -- 删除序列号小于300的所有归档日志

查询归档日志的备份历史

RMAN> list backup of archivelog all;

查询归档日志的空间使用统计信息

RMAN> report obsolete;

查看所有归档文件

RMAN> crosscheck archivelog all;

查看归档日志空间占比率

select * from v$flash_recovery_area_usage;  -- 查看空间占用率
select * from v$recovery_file_dest; -- 查看归档日志存放地址
select count(*) from v$archived_log; -- 查看归档日志数量