达州做网站
大橙子网站建设，新征程启航
为企业提供网站建设、域名注册、服务器等服务
数据库中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=2328 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_24/thread_1_seq_2329.1242.1027887719 thread=1 sequence=2329 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_24/thread_1_seq_2330.1243.1027887813 thread=1 sequence=2330 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_24/thread_1_seq_2331.1244.1027887873 thread=1 sequence=2331 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_25/thread_1_seq_2332.1245.1027902623 thread=1 sequence=2332 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_25/thread_1_seq_2333.1246.1027902719 thread=1 sequence=2333 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_25/thread_1_seq_2334.1247.1027908493 thread=1 sequence=2334 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_25/thread_1_seq_2335.1248.1027911721 thread=1 sequence=2335 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_26/thread_1_seq_2336.1249.1027989005 thread=1 sequence=2336 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_26/thread_1_seq_2337.1250.1027989067 thread=1 sequence=2337 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_26/thread_1_seq_2338.1251.1027990617 thread=1 sequence=2338 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_26/thread_1_seq_2339.1252.1028041713 thread=1 sequence=2339 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived 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 log archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_24/thread_1_seq_2330.1243.1027887813 RECID=18420 STAMP=1027887814 deleted archived log archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_24/thread_1_seq_2331.1244.1027887873 RECID=18421 STAMP=1027887875 deleted archived log archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_25/thread_1_seq_2332.1245.1027902623 RECID=18422 STAMP=1027902628 deleted archived log archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_25/thread_1_seq_2333.1246.1027902719 RECID=18423 STAMP=1027902721 deleted archived log archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_25/thread_1_seq_2334.1247.1027908493 RECID=18424 STAMP=1027908500 deleted archived log archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_25/thread_1_seq_2335.1248.1027911721 RECID=18425 STAMP=1027911722 deleted archived log archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_26/thread_1_seq_2336.1249.1027989005 RECID=18426 STAMP=1027989010 deleted archived log archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_26/thread_1_seq_2337.1250.1027989067 RECID=18427 STAMP=1027989069 deleted archived log archived log file name=+CWDATA/sjjhdg/archivelog/2019_12_26/thread_1_seq_2338.1251.1027990617 RECID=18428 STAMP=1027990618 deleted archived log archived 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错误的处理方法是什么这一问题有了更深刻的体会，具体使用情况还需要大家实践验证。这里是创新互联，小编将为大家推送更多相关知识点的文章，欢迎关注！
分享名称：数据库中RMAN删除归档日志出现RMAN-0813错误的处理方法是什么-创新互联
网站URL：http://dzwzjz.com/article/iieoh.html