ORA-01153: an incompatible media recovery is active

標籤：ora-01153: an incompatible media recovery is active

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

SQL> recover managed standby database cancel;

SQL> recover automatic standby database;

SQL> RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;

本文出自 “Permanent” 部落格，請務必保留此出處http://ericklee.blog.51cto.com/6941516/1560413

ORA-01153: an incompatible media recovery is active