【DataGuarad】ORA-1153 trying to turn on Flashback for Physical Standby Database 2011-10-

简介:
当试图开启备库的flashback功能时报如下错误:
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;
Database altered.
SQL> alter database flashback on;
Database altered.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
相关文章
|
数据库 内存技术 关系型数据库
|
Oracle 关系型数据库 数据库
|
SQL Oracle 关系型数据库
【原】Configuring Oracle Data Guard In Physical Standby Database
作者:david_zhang@sh 【转载时请以超链接形式标明文章】 http://www.cnblogs.com/david-zhang-index/p/5042640.html参照文档:https://azure.
1016 0
|
数据库
巧用flashback database实现灵活的数据回滚
之前写了一篇博文分享了使用flashback database的特性来在测试环境中避免重复导入大批量的数据,造成时间和存储空间的浪费。http://blog.itpub.net/23718752/viewspace-1584057/ 今天碰到的这个问题更有针对性和普遍性,在很多时候都需要一套独立的环境来作为客户的培训和演示需要,环境中的数据一旦配置完成,一般是很少需要改动的。
768 0
下一篇
无影云桌面