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