Script_dg new

 select dest_id,process,transmit_mode,async_blocks, 

net_timeout,delay_mins,reopen_secs,register,binding 

from v$archive_dest; 

column error format a55 tru 

select dest_id,status,error from v$archive_dest; 

column message format a80 

select message, timestamp 

from v$dataguard_status 

where severity in ('Error','Fatal') 

order by timestamp; 

select group#,sequence#,bytes,used,archived,status from v$standby_log;

select group#,thread#,sequence#,bytes,archived,status from v$log; 

select process,status,client_process,sequence#,block#,active_agents,known_agents

from v$managed_standby;

select al.thrd "Thread", almax "Last Seq Received", lhmax "Last Seq Applied"

from (select thread# thrd, max(sequence#) almax

      from v$archived_log

      where resetlogs_change#=(select resetlogs_change# from v$database)

      group by thread#) al,

     (select thread# thrd, max(sequence#) lhmax

      from v$log_history

      where first_time=(select max(first_time) from v$log_history)

      group by thread#) lh

where al.thrd = lh.thrd;

select * from v$archive_gap; 

set numwidth 5 

column name format a30 tru 

column value format a50 wra 

select name, value 

from v$parameter 

where isdefault = 'FALSE';

SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference" FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH, (SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL WHERE ARCH.THREAD# = APPL.THREAD# ORDER BY 1;