ITPub博客

首页 > 数据库 > Oracle > RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream

原创 Oracle 作者:parknkjun 时间:2014-12-05 17:43:10 0 删除 编辑
客户数据库备份日志报错:RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process,
DB版本为11.2.0.1,根据备策略,每天备份归档,并且自动删除档,保留两个星期的归档,手功执如下命令:
delete noprompt archivelog until time 'sysdate-14';
依然报错,信息如下:
 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=E:\ORAARCH\JZH\ARC0000218319_0796336681.0001 thread=1 sequence=218319
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=E:\ORAARCH\JZH\ARC0000218320_0796336681.0001 thread=1 sequence=218320
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=E:\ORAARCH\JZH\ARC0000218321_0796336681.0001 thread=1 sequence=218321
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=E:\ORAARCH\JZH\ARC0000218322_0796336681.0001 thread=1 sequence=218322
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=E:\ORAARCH\JZH\ARC0000218323_0796336681.0001 thread=1 sequence=218323
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=E:\ORAARCH\JZH\ARC0000218324_0796336681.0001 thread=1 sequence=218324
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=E:\ORAARCH\JZH\ARC0000218325_0796336681.0001 thread=1 sequence=218325


搜索MOS,发现这是11g中的一个bug,需要在delete 后面加上force,mos描述如下:
—————————————————————————————————————————————————————————————————————————
Symptoms
Applies To: 11gR1-11gR2

RMAN is unable to delete archive logs from database even though they are not needed by CAPTURE process anymore.
Changes
Cause
In 11g, RMAN looks at MIN_REQUIRED_CAPTURE_CHANGE# in v$database and not at DBA_CAPTURE. By default this value is updated every 6 hours. So by default the value in v$database will be six hours behind the current value.

Solution
Since changing frequency of update to MIN_REQUIRED_CAPTURE_CHANGE# in v$database can not be controlled, following workaround can be used:

Archive log which are not needed by capture process can be deleted using:

delete noprompt force archivelog all completed before 'sysdate-10/1440';
_________________________________________________________________________________________________________________________________________

最后加上force关键字,手动执行delete noprompt force archivelog until time 'sysdate-14'; 成功将归档删除!



来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10271187/viewspace-1358036/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 简单配置 Log Miner
请登录后发表评论 登录
全部评论
DBA攻城狮

注册时间:2008-02-11

  • 博文量
    115
  • 访问量
    519790