数据库中RMAN删除归档日志出现RMAN-0813错误的处理方法是什么

这篇文章主要讲解了"数据库中RMAN删除归档日志出现RMAN-0813错误的处理方法是什么"，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习"数据库中RMAN删除归档日志出现RMAN-0813错误的处理方法是什么"吧！

数据库备份日志报错：RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process，DB版本为11.2.0.4，根据备策略，每天备份归档，并且自动删除档，保留一个星期的归档，手功执如下命令：

delete noprompt archivelog until time 'sysdate-7'；

依然报错，信息如下：

archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_24/thread_1_seq_2328.1241.1027887401 thread=1 sequence=2328RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_24/thread_1_seq_2329.1242.1027887719 thread=1 sequence=2329RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_24/thread_1_seq_2330.1243.1027887813 thread=1 sequence=2330RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_24/thread_1_seq_2331.1244.1027887873 thread=1 sequence=2331RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_25/thread_1_seq_2332.1245.1027902623 thread=1 sequence=2332RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_25/thread_1_seq_2333.1246.1027902719 thread=1 sequence=2333RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_25/thread_1_seq_2334.1247.1027908493 thread=1 sequence=2334RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_25/thread_1_seq_2335.1248.1027911721 thread=1 sequence=2335RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_26/thread_1_seq_2336.1249.1027989005 thread=1 sequence=2336RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_26/thread_1_seq_2337.1250.1027989067 thread=1 sequence=2337RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_26/thread_1_seq_2338.1251.1027990617 thread=1 sequence=2338RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_26/thread_1_seq_2339.1252.1028041713 thread=1 sequence=2339RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_27/thread_1_seq_2340.1253.1028075413 thread=1 sequence=2340...............

在MOS搜索发现这是11g中的一个bug，描述的原因是在11g中，RMAN查看的是v$database中的MIN_REQUIRED_CAPTURE_CHANGE#，而不是DBA_CAPTURE。默认情况下，该值每6小时更新一次。因此，在默认情况下，v$database中的值将比当前值晚6个小时。
给出的解决方法是需要在delete 后面加上force。
手动执行delete noprompt force archivelog until time 'sysdate-7', 成功将归档删除。

deleted archived logarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_24/thread_1_seq_2330.1243.1027887813 RECID=18420 STAMP=1027887814deleted archived logarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_24/thread_1_seq_2331.1244.1027887873 RECID=18421 STAMP=1027887875deleted archived logarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_25/thread_1_seq_2332.1245.1027902623 RECID=18422 STAMP=1027902628deleted archived logarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_25/thread_1_seq_2333.1246.1027902719 RECID=18423 STAMP=1027902721deleted archived logarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_25/thread_1_seq_2334.1247.1027908493 RECID=18424 STAMP=1027908500deleted archived logarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_25/thread_1_seq_2335.1248.1027911721 RECID=18425 STAMP=1027911722deleted archived logarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_26/thread_1_seq_2336.1249.1027989005 RECID=18426 STAMP=1027989010deleted archived logarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_26/thread_1_seq_2337.1250.1027989067 RECID=18427 STAMP=1027989069deleted archived logarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_26/thread_1_seq_2338.1251.1027990617 RECID=18428 STAMP=1027990618deleted archived logarchived log file name=+CWDATA/sjjhdg/archivelog/2019_12_26/thread_1_seq_2339.1252.1028041713 RECID=18429 STAMP=1028041715...........Deleted 800 objects

感谢各位的阅读，以上就是"数据库中RMAN删除归档日志出现RMAN-0813错误的处理方法是什么"的内容了，经过本文的学习后，相信大家对数据库中RMAN删除归档日志出现RMAN-0813错误的处理方法是什么这一问题有了更深刻的体会，具体使用情况还需要大家实践验证。这里是，小编将为大家推送更多相关知识点的文章，欢迎关注！