ORA-10456: cannot open standby database; media recovery session may be in progress
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.