Oracle ORA-1153 尝试对物理standby数据库启动闪回

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

*

沪ICP备14014813号-2

沪公网安备 31010802001379号