客户数据库备份日志报错: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'; 成功将归档删除!
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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10271187/viewspace-1358036/