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