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

//查看是否实时应用
set linesize 300
col dest_name for a30
col database_mode for a30
select dest_id,dest_name,DATABASE_MODE,PROTECTION_MODE,recovery_mode from v$archive_dest_status;

//查看adg应用进程
SELECT thread#,PROCESS,PID,CLIENT_PROCESS, SEQUENCE#, block#,STATUS FROM V$MANAGED_STANDBY order by 1;

//查看gap

select * from v$archive_gap;

//查看归档日志情况

select thread#,first_time,SEQUENCE#,block_size*blocks/1024/1024,archived,applied,status from v$archived_log where first_time>sysdate-1 order by 2


//查看延时情况

select * from v$dataguard_stats;