So no action is required if you do this ( above ). If you shutdown apply and open it then you need to shutdown and restart mount and restart apply.
/home/oracle:STANDBY >sqlplus " / as sysdba" SQL*Plus: Release 18.104.22.168.0 Production on Wed Oct 24 16:04:54 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options 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>
951368,what will happen if physical standby database is opened when in standby role plus primary is opened?>
what do we need to do to get back the data guard configuration?,we need to just much neither need to shut down the db ,run the below command only:
alter database recover managed standby database using current logfile disconnect ; or alter database recover managed standby database disconnect ;