ORACLE_DATAGUARD_Recover standby database manually
Check the standby status:
SQL>select open_mode from v$database;
SQL>select sequence#,applied from v$archived_log order by sequence#;
SQL>SELECT THREAD#, LOW_SEQUENCE#, HIGH_SEQUENCE# FROM V$ARCHIVE_GAP;
SQL>select process,status from v$managed_standby;
---If you find the MRP0 status is WAIT_FOR_GAP, so, we can apply manually thearchivelog to standby.
Solution:
Copythe archive log from the primary to standby.
Inthe standby:
$sqlplus / as sysdba
SQL>recover managed standby database cancel;
SQL>recover automatic standby database;
SQL>alter database recover managed standby database disconnect from session;