欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

RMAN备份报RMAN-03009: failure of Control File and SPFILE Autoba

程序员文章站 2024-01-20 20:07:10
...

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打上补丁

RMAN备份报RMAN-03009: failure of Control File and SPFILE Autoba