Oracle Dataguard Monitoring Scripts -4

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#;

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/