-- STOPING RECOVERY PROCESS

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE  CANCEL;
 Database altered.


-- STARTING RECOVERY PROCESS

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
SQL> alter database recover managed standby database using current logfile disconnect from session;
 Database altered.


--Go to the apply instance and check whether the apply process is started or not

----standby----
SQL> select PROCESS,CLIENT_PROCESS,THREAD#,SEQUENCE#,BLOCK# from v$managed_standby where process = 'MRP0' or client_process='LGWR';