ORA-10456: cannot open standby database; media recovery session may be in progress


SQL> set linesize 1000
SQL> set pagesize 100
SQL> 
SQL> 
SQL> select name,open_mode from v$database;
NAME                                                                 OPEN_MODE
---------                           --------------------------------------------------------------------------------
KBANAR                                                              MOUNTED

SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-10456: cannot open standby database; media recovery session may be in
progress


Solution:

SQL> alter database recover managed standby database cancel;
Database altered.

SQL> alter database open read only;
Database altered.

SQL> select name,open_mode from v$database;
NAME                                                                 OPEN_MODE
---------                           --------------------------------------------------------------------------------
KBANAR                                                             READ ONLY
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: