11G DG状态检查语句

查看DG 状态：select database_role,switchover_status from v$database;


查看DG保护模式  select protection_mode,protection_level  from v$database;




查看与DG有关的相应进程 ：select process, status, thread#,sequence#, block#, blocks from v$managed_standby; 




查看是否使用Real-Time apply：Select recovery_mode from v$archive_dest_status;

查看 备库apply redo 过程中丢失的归档日志   select   *   from  v$archive_gap;

主库上查看日志传送情况：
set wrap off
col dest_name for a30
select dest_name,status,error from v$archive_dest;

##############################3

查看备库standby redo 与主库redo的对应关系
select THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM v$standby_log;  #备库语句


select THREAD#,SEQUENCE#,STATUS FROM v$log;                  #主库语句

#################################

查看 archivelg 应用情况 
col name  for a40
select sequence#,applied,REGISTRAR,name  from  v$archived_log where APPLIED；

如果等了很长时间applied 都无法应用，可以尝试一下方法：

alter database recover managed standby database cancel; 
alter database recover managed standby database disconnect from session; 

###################################

监控日志传输性能：select frequency,duration,time from v$redo_dest_resp_histogram  where DEST_ID = 2 and frequency >1;