Encountering ORA-01153: an incompatible media recovery is active When Starting Up Phycial Standby
来源:互联网 发布:怎样使用淘宝优惠券 编辑:程序博客网 时间:2024/06/05 22:37
Problem
sys@db11r2dr> startup mount;
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@db11r2dr> 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
sys@db11r2dr> alter database recover managed standby database cancel;
sys@db11r2dr> 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.
- Encountering ORA-01153: an incompatible media recovery is active When Starting Up Phycial Standby
- VIII.4 ORA-01153: an incompatible media recovery is active
- VIII.5 ORA-01153: an incompatible media recovery is active
- ORA-01153: an incompatible media recovery is active(产生原因及解决方法)
- ORA-16136: Managed Standby Recovery not active
- ORA-10456: cannot open standby database; media recovery session may be in progress
- ORA-10456: cannot open standby database; media recovery session may be in
- ORA-10456: cannot open standby database; media recovery session may be in progress
- ORA-10456: cannot open standby database; media recovery session may be in progress
- How to Disable Parallel Transaction Recovery When Parallel Txn Recovery is Active (Doc ID 238507.1)
- ORA-10458: standby database requires recovery
- ORA-10458: standby database requires recovery
- ORA-10458: standby database requires recovery
- ORA-01196: file 1 is inconsistent due to a failed media recovery session
- Notifications --- Preserving Navigation when Starting an Activity
- ORA-01113: file 2 needs media recovery
- ORA-01113: file 7 needs media recovery
- ORA-01113: file 7 needs media recovery
- 01随机生成函数
- SecureCRT配置前--Linux网卡设置
- Android:自定义view实现动画
- mac10.9 安装caffe CPU_Only 模式
- 安装nfs步骤
- Encountering ORA-01153: an incompatible media recovery is active When Starting Up Phycial Standby
- 错误记录:this.requestWindowFeature(Window.FEATURE_NO_TITLE)报错或没效果
- 23种设计模式
- 选择排序(解析及代码实现)
- 在rhel7下,安装oracle database时不能选择xfs文件,原因是不支持
- SPL库的基本介绍(1)
- Linux下/proc目录简介
- 设计模式----组合模式(C#)
- 概率质量函数(Probability Mass Function)和期望课程笔记