Problem
sys@standby> startup mount;
ORACLE instance started.
ORACLE instance started.
Total System Global Area 835104768 bytes
Fixed Size 2217952 bytes
Variable Size 490735648 bytes
Database Buffers 335544320 bytes
Redo Buffers 6606848 bytes
Database mounted.
sys@standby> alter database recover managed standby database using current logfile disconnect;
Fixed Size 2217952 bytes
Variable Size 490735648 bytes
Database Buffers 335544320 bytes
Redo Buffers 6606848 bytes
Database mounted.
sys@standby> alter database recover managed standby database using current logfile disconnect;
alter database recover managed standby database using current logfile disconnect
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
Cause
This indicates a currently running media recovery process.
Action
sys@standby> alter database recover managed standby database cancel;
sys@standby> alter database recover managed standby database using current logfile disconnect;
Note
When shutting down physical standby database, firstly turn off media recovery process. Otherwise the next time when starting up redo apply again, you will encounter error ORA-01153.
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, ORA-01153: an incompatible media recovery is active On standby Database, 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