Cancel the Standby Recovery
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Start the Standby database recovery in mount
startup mount
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Start the Standby database recovery in open mode
Startup Open
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;-- real time
or
alter database recover managed standby database using current logfile disconnect; -- real time
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Start the Standby database recovery in mount
startup mount
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Start the Standby database recovery in open mode
Startup Open
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;-- real time
or
alter database recover managed standby database using current logfile disconnect; -- real time