alter database recover managed standby database using current logfile disconnect from session;

2、关闭实时应用

alter database recover managed standby database  cancel;

3、检查MRP0进程

select process,client_process,sequence#,status from v$managed_standby; 

4、主库中查看第二存档点是否异常

col dest_name for a30
select dest_name,status,error,target,process from v$archive_dest where substr(dest_name,-1) in (1,2,3);

第二进程点出问题可通过下面命令刷新下：
alter system set log_archive_dest_state_2=defer;
alter system set log_archive_dest_state_2=enable;
5、备库查看日志应用情况：
set pagesize 100
select sequence#,applied from v$archived_log order by 1;

6、查备库与主库的延迟

select name,value,datum_time from v$dataguard_stats;

7.主备归档日志序号检查

SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;  （主，备）
select thread#,sequence#,archived,status from v$standby_log;   （备）
select group#,thread#,sequence#,status from v$log;    （主）
select group#,thread#,sequence#,status from gv$log;