如果自己搞不定可以找诗檀软件专业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 – 版本 10.2.0.4 及以上 本文信息适用于任何平台。 ***于 16-Apr-2014检查相关性*** ***于 06-July-2015检查相关性*** 症状 无法在备用数据库上启用闪回。报告以下错误： SQL> alter database flashback on; alter database flashback on * ERROR at line 1: ORA-01153: an incompatible media recovery is active 原因 备用数据库在恢复中。 报告的错误表示： ORA-1153, 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 解决方案 要启用闪回，需要暂停恢复。 你可以使用以下命令在备用数据库上暂停恢复： SQL> alter database recover managed standby database cancel; - 启用闪回： SQL> alter database flashback on; - 再次启动受管理的恢复 SQL> alter database recover managed standby database disconnect from session;