通过RMAN清理断档归档日志

asmcmd检查归档路径

ASMCMD> pwd
+DATA/arch

ASMCMD> pwd
+DATA/TSRFM1/ARCHIVELOG
ASMCMD> du 
Used_MB      Mirror_used_MB
 602067              602067

通过rman查看控制文件中是否存在

发现不存在+DATA/TSRFM1/ARCHIVELOG路径下归档文件

RMAN> list copy;

using target database control file instead of recovery catalog
specification does not match any datafile copy in the repository
specification does not match any control file copy in the repository
List of Archived Log Copies for database with db_unique_name TSRFM1
=====================================================================

Key     Thrd Seq     S Low Time            
------- ---- ------- - --------------------
22583   1    14210   A 17-NOV-2023 21:19:13
        Name: +DATA/arch/1_14210_944928942.arc

22584   1    14211   A 17-NOV-2023 21:20:07
        Name: +DATA/arch/1_14211_944928942.arc

22585   1    14212   A 17-NOV-2023 21:21:46
        Name: +DATA/arch/1_14212_944928942.arc

22587   1    14213   A 18-NOV-2023 05:05:32
        Name: +DATA/arch/1_14213_944928942.arc

22588   1    14214   A 18-NOV-2023 14:02:25
        Name: +DATA/arch/1_14214_944928942.arc

22589   1    14215   A 18-NOV-2023 21:00:01
        Name: +DATA/arch/1_14215_944928942.arc

注册归档日志至rman

 catalog start with '+DATA/TSRFM1/ARCHIVELOG'

检查文件是否存在

crosscheck

删除归档

delete archivelog all completed before 'sysdate-3';  #删除大于3天的创建并已成功备份或应用到备用数据库的已归档重做日志文件。
#or
delete archivelog until time 'SYSDATE-3';  #删除大于3天创建的已归档重做日志文件，而不考虑它们是否已备份。它只是简单地删除指定时间之前的所有已归档重做日志文件。

验证空间是否释放

检查路径下文件是否删除
```
ASMCMD > ls +DATA/TSRFM1/ARCHIVELOG
```
检查空间大小
```
asmcmd lsdg
```