Monday, February 10, 2020

ORA-01153: an incompatible media recovery is active On standby Database

ORA-01153: an incompatible media recovery is active On standby Database


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.
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.

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

Cause:
This indicates a currently running media recovery process.

Action:
alter database recover managed standby database cancel;
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.

No comments:

Post a Comment