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博客 ” ,链接:http://blog.itpub.net/21605631/viewspace-710738/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21605631/viewspace-710738/