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.


Stop MRP:

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

Enable flashback:

SQL> ALTER DATABASE FLASHBACK ON;
Database altered.
SQL>

Start MRP:

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

All Steps:

SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
NO
SQL>
SQL> ALTER DATABASE FLASHBACK ON;
ALTER DATABASE FLASHBACK ON
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active

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;
Database altered.
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
YES
SQL> 

Done. 

Get what proxy setting the database is using

SQL >

var proxy varchar2(100)
var no_proxy varchar2(100)
exec utl_http.get_proxy(:proxy,:no_proxy) ;
print proxy
print no_proxy