一个redhat as4下的oracle 10.2.0.2的库使用的是基于物理dataguard的备份,每天晚上自动使用rman对数据库进行备份,但是今天却发现昨天晚上的备份失败!因为数据要保证能恢复到任何的时间点,所以备份脚本中是先对数据库进行增量备份,然后进行日志的备份。结果发现增量备份成功,但日志却没有被备份。错误提示如下:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-10006: error running SQL statement: select sofar, context, start_time from v$session_longops where (start_time > nvl(:1,
sysdate-100) or start_time = nvl(:2, sysdate+100)) and sid = :3 and serial# = :4 and opname
like 'RMAN:%' order by start_time desc, context desc
RMAN-10002: ORACLE error: ORA-00000: normal, successful completion
网上google了下,发现在9i中这是一个bug,metalink中有这个bug的描述:
Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.5
This problem can occur on any platform.
Symptoms:
RMAN fails selecting from v$session_longops :
RMAN-10006: error running SQL statement: select sofar, context, start_time
from v$session_longops where (start_time > nvl(:1, sysdate-100) or
start_time = nvl(:2, sysdate+100)) and sid = :3 and serial#
= :4 and opname like 'RMAN:%' order by start_time desc, context desc
RMAN-10002: ORACLE : ORA-01041: internal error. hostdef extension doesn't exist
Solution:
Bug 3123232 is fixed in 9.2.0.6 so apply 9206 PSR or use the workaround:
Add to the init.ora/spfile of the target database
Switch off long-op statistics by setting the following (9.2 specific) settings in the (s)pfile :
optimizer_features_enable=9.2.0.1
_subquery_pruning_mv_enabled=false
Instance will have to be restarted
虽然此bug的描述跟我碰到的不大相同,而且此bug的版本跟我的也相差甚远,但是网上看到有人在9.2.0.8中照样碰到了,而且也是基于dataguard的备份,所以,这很可能就是一个bug,变异拉,哈哈。需要说明的是查询v$session_longops失败不会导致运行中的命令失败,而会导致下一条命令运行失败。就比如我的,增量备份照样完成,只不过接下来的对归档进行备份的命令却失败。
不过我没有设置隐含参数,只是重启了dataguard就好了
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25016/viewspace-1000207/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25016/viewspace-1000207/