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

楊奇龍發表於2011-10-12
Database
當試圖開啟備庫的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.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/22664653/viewspace-709060/，如需轉載，請註明出處，否則將追究法律責任。

相關文章