ORA-01153 an incompatible media recovery is active
I need help solving this issue please
On my standby database I run the following query and got ORA-01153 below.
SQL> alter database recover managed standby database NODELAY disconnect from session
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
How to resolve this?
Thank you for your help
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
i think there is an other recovery process taking place... U should either allow it complte or stop the other process....
try OERR NUmber to get the details in the window....
You may have hit bug# 3597439, check it out in Metalink.
Here is an excerpt:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE command will fail with
ORA-1153, "incompatible media recovery active" if an RMAN backup is
Start managed recovery before starting RMAN backup,
(They will run at the same time, but only if managed recovery is started first)
Wait until the RMAN backup is complete before starting managed recovery.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Click Here to Expand Forum to Full Width