ORA-01153: an incompatible media recovery is active

Standby Database:

standbydb>alter database recover managed standby database disconnect from session;



alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active

What is the cause of an ORA-01153 error?

Answer:

ORA-01153: 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

standbydb> alter database recover managed standby database cancel;

database altered.

standbydb> alter database recover managed standby database disconnect from session;

database altered.