ORA-01153: an incompatible media recovery is active

ORA-01153: an incompatible media recovery is active

Want to enable flashback on DR but getting the error.

Reason is because MRP process is running. So we stop MRP process and then try enabling flashback. After that start MRP process.

Steps:

SQL> select flashback_on from v$database;
FLASHBACK_ON
——————
NO

SQL> ALTER DATABASE FLASHBACK ON;
ALTER DATABASE FLASHBACK ON
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active

Stop MRP:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Database altered.

Enable flashback:

SQL> ALTER DATABASE FLASHBACK ON;
Database altered.

Start MRP:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
Database altered.

SQL> select flashback_on from v$database;
FLASHBACK_ON
——————
YES

  • December 29, 2017 | 14 views
  • Comments