Oracle 备用数据库的RMAN 备份失败显示 1153, ORA-01153: an incompatible media recovery is active

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com

 

ORA-01153 oerr ora 1153
01153, 00000, "an incompatible media recovery is active"
// *Cause: Attempted to start an incompatible media recovery or open resetlogs
//         during media recovery or RMAN backup . Media recovery sessions
//         are incompatible if they attempt to recover the same data file.
//         Incomplete media recovery or open resetlogs is incompatible with
//         any media recovery. Backup or restore by RMAN is incompatible
//         with open resetlogs
// *Action: Complete or cancel the other media recovery session or RMAN backup

适用于：

Oracle Database – Enterprise Edition –版本 11.1.0.6 到 11.2.0.3 [Release 11.1到11.2]
本文信息适用于任何平台。

症状

RMAN 备份失败显示1153 (ORA-01153 / ORA-1153)

 

MRP0: Background Media Recovery terminated with error 1153
ORA-01153: an incompatible media recovery is active
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH ALL SWITCHOVER DISCONNECT USING CURRENT LOGFILE
MRP0: Background Media Recovery terminated with error 1153

 

原因

虽然在为备用数据库运行托管的恢复时可以创建RMAN备份，但客户使用keep选项时可能对于RMAN备份不进行同样操作。在11g中当指定了keep子句时，RMAN 尝试创建一个一致性备份，但这是不可能的，因为在备用数据库上在运行媒体恢复。请参阅本文获取有关使用keep选项备份的一致性的一些有用的背景资料：

http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmbckba.htm#CHDHAFHJ
解决方案

要在11g中在备用数据库上使用keep子句创建备份，你必须停止托管恢复并在只读模式下按照以下文档打开数据库：
<Note 1274127.1>  RMAN-6764 “standby database must be open read only before creating a KEEP backup”

参考

NOTE:1274127.1 – RMAN-6764 “standby database must be open read only before creating a KEEP backup”