POiSON WORLD

Problem :

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active

-----------------------------------------------------------------------------------------------------
                                          OR
-----------------------------------------------------------------------------------------------------

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


Solution :

This indicates that currently running media recovery process i.e. standby active

SQL> alter database recover managed standby database cancel; --- Cancel first

Database altered. 


SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

Database altered.

Comments

comments

Tags: an incompatible media recovery is active, Database DBA, Ora : an incompatible media recovery is active, Ora Error, ORA-01153, ORA-01153: an incompatible media recovery is active, Oracle an incompatible media recovery is active, oracle data guard, oracle data guard error, oracle data guard issues, Oracle Database Error, Oracle Database Solution, Oracle DBA, oracle error, Oracle Error Solution

This entry was posted on Monday, November 16th, 2015 at 12:01 am and is filed under Oracle Queries. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.