如果自己搞不定可以找诗檀软件专业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"