Home >Database >Mysql Tutorial >RMAN备份报RMAN-03009: failure of Control File and SPFILE Autoba
RMAN备份报RMAN-03009: failure of Control File and SPFILE Autobackup command
操作系统版本:
AIX 6100
数据库版本:
Oracle 11.2.0.2
现象描述
生产数据库RMAN备份成功之后报了一个错,发现为数据文件,控制文件还有归档备份完成之后才报的错,按道理不影响备份,但是有报错影响以后备份检查,需要进行解决
具体报错信息如下,,
channel ch1: backup set complete, elapsed time: 00:00:03
Finished backup at 08-NOV-12
Starting Control File and SPFILE Autobackup at 08-NOV-12
released channel: ch1
released channel: ch2
released channel: ch3
RMAN-00571: ======================================================
RMAN-00569: =========== ERROR MESSAGE STACK FOLLOWS ===========
RMAN-00571: ======================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ch1 channel at 11/08/2012 01:15:01
ORA-00245: control file backup operation failed
RMAN>
诊断和解决过程
1.备份脚本一直没有动过,以前备份都没有报过这个错,排除是脚本问题
2.经查证为oracle 11.2.0.2的Bug,Bug号为10317487
3.解决方案为升级数据库或下载10317487打上补丁