Normal 0 7.8 pt 0 2 false false false MicrosoftInternetExplorer4 RMAN中删除归档时报错RMAN-08137

数据库版本

任何版本

现象描述

在RMAN中删除归档时报错RMAN-08137

RMAN-08515: archived log file name=/u01/app/oracle/arch/test

/testarch1_114535_628330195.dbf thread=1 sequence=114535

RMAN-08137: WARNING: archived log not deleted as it is still needed

RMAN-08515: archived log file name=/u01/app/oracle/arch/test/testarch1_114536_628330195.dbf thread=1 sequence=114536

解决方案

确认这些归档可以删除后，在rman使用下面脚本强制删除最近两天已经备份过一次的归档

delete force noprompt archivelog until time 'trunc(sysdate-2)' backed up 1 times to device type disk;

ITPub博客

RMAN中删除归档时报错RMAN-08137