Hi,
Dataguard should be monitored everytime by Oracle DBA.
You can read other Oracle Dataguard monitoring scripts like following.
https://ittutorial.org/2018/03/02/oracle-dataguard-monitoring-scripts-1/
https://ittutorial.org/2018/03/02/oracle-dataguard-monitoring-scripts-2/
https://ittutorial.org/2018/03/02/oracle-dataguard-monitoring-scripts-3/
To see all parameters of Oracle dataguard, you can execute following query.
set linesize 500 pages 0
col value for a80
col name for a50
select name, value from v$parameter
where name in ('db_name','db_unique_name','log_archive_config',
'log_archive_dest_1','log_archive_dest_2','log_archive_dest_3',
'log_archive_dest_state_1','log_archive_dest_state_2','log_archive_dest_state_3', 'remote_login_passwordfile',
'log_archive_format','log_archive_max_processes','fal_server','fal_client','db_file_name_convert',
'log_file_name_convert', 'standby_file_management') order by 1;
To see applied archivelogs in dataguard, execute following script.
select thread#,sequence#,first_time,next_time,applied from gv$archived_log where applied='YES';
Below script provides information about max sequence of dataguard
select thread#,max(sequence#) from gv$archived_log group by thread#;