ORA-10456: cannot open standby database; media recovery session may be in progress
来源:互联网 发布:linux ipv6 编辑:程序博客网 时间:2024/06/05 09:23
http://neeraj-dba.blogspot.com/2011/10/ora-10456-cannot-open-standby-database.html
Once while starting my standby database i found that database is not opening in normal mode. It throws the error-10456 :cannot standby database.
On performing some R&D and googling comes to the conclusion that this error is generally occurs because a media recovery or RMAN session may have been in progress on a mounted instance of a standby database when an attempt was made to open the standby database. Hence to solve of this issue we have to cancel any conflicting recovery session and then open the standby database.
Here is the issue what i have experienced .
C:\>sqlplus sys/xxxx@red as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon Oct 3 12:47:32 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from hr.aa;
select * from hr.aa
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
NOIDA MOUNTED
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-10456: cannot open standby database; media recovery session may be in progress
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database open;
Database altered.
SQL> alter database recover managed standby database using current logfile disconnect ;
Database altered.
Hence, finally we solve the issues.
0 0
- 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
- 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-10458: standby database requires recovery
- ORA-10458: standby database requires recovery
- ORA-10458: standby database requires recovery
- ORA-16456: switchover to standby in progress or completed
- ORA-16661: the standby database needs to be reinstated
- ORA-01123: cannot start online backup; media recovery not enabled
- ORA-01123: cannot start online backup; media recovery not enabled
- Encountering ORA-01153: an incompatible media recovery is active When Starting Up Phycial Standby
- ORA-00313, ORA-00312, ORA-27037 in Standby Database [ID 601835.1]
- ORA-00313, ORA-00312, ORA-27037 in Standby Database [ID 601835.1]
- ORA-00313, ORA-00312, ORA-27037 in Standby Database [ID 601835.1]
- ORA-38706: Cannot turn on FLASHBACK DATABASE logging.ORA-38709: Recovery Area is not enabled.
- ORA-38706: Cannot turn on FLASHBACK DATABASE logging.ORA-38709: Recovery Area is not enabled.
- ORA-28390: auto login wallet not open but encryption wallet may be open
- NWeb 中关于 Markdown的使用规范
- 使用VBScript脚本查看Windows 10序列号
- Java并发编程:Callable、Future和FutureTask
- Android TextUtils类常用方法
- 阅读郭林《第一行代码》的笔记——第9章 后台默默的劳动者,探究服务
- ORA-10456: cannot open standby database; media recovery session may be in progress
- 学数据结构的第一个算法,最大子列和问题,即求一个数组连续子列和求最大
- solr 入门笔记
- 一次完整的从webshell到域控的探索之路
- 51nod1264 线段相交
- 数据库--使用索引的注意事项及常见场景
- gdebi
- jdk+hadoo+hbase安装
- LeetCode-----13. Roman to Integer