ORA-10456: cannot open standby database; media recovery session may be in progre
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. Henceto 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:> Copyright (c) 1982, 2010, Oracle.All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition> 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> SQL> alter database open;
Database> SQL> alter database recover managed standby database using current logfile disconnect ;
Database> Hence, finally we solve the issues.
页:
[1]