Home >Database >Mysql Tutorial >RMAN备份报RMAN-03009: failure of Control File and SPFILE Autoba

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

WBOY
WBOYOriginal
2016-06-07 17:24:341728browse

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

linux

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn