Shulou(Shulou.com)06/01 Report--

Oracle uses DataGuard as remote backup, which can be used to monitor the difference between master and standby archive log sequences.

Vim orabbix/conf/query.props

Add at the beginning of the QueryList

QueryList=archive,audit,dbblockgets,dbconsistentgets,dbhitratio,dbphysicalread,hitratio_body,hitratio_sqlarea,hitratio_table_proc,\ lio_current_read,locks,maxprocs,maxsession,miss_latch,pga_aggregate_target, pga,phio_datafile_reads,phio_datafile_writes,phio_redo_writes,pinhitratio_body,pinhitratio_sqlarea,pinhitratio_table-proc,pinhitratio_trigger,\ pool_dict_cache,pool_free_mem,pool_lib_cache,pool_misc,pool_sql_area,procnum,session_active,session_inactive,session Session_system,sga_buffer_cache,\ sga_fixed,sga_java_pool,sga_large_pool,sga_log_buffer,sga_shared_pool,tbl_space,userconn,waits_controfileio,waits_directpath_read,\ waits_file_io,waits_latch,waits_logwrite,waits_multiblock_read,waits_singleblock_read,hitratio_trigger,lio_block_changes,lio_consistent_read,waits_other,waits_sqlnet,users_locked,uptime,dbfilesize,dbsize,process,max_process,used_session,max_session Active_session,archive_size,dgstatus,dataguard_logs

Add at the end

Dgstatus.Query=select count (0) from v$archive_dest where status='VALID'dataguard_logs.Query=select max (sequence#) from v$archived_log

Then authorize in the database and query the permissions of the relevant tables.

GRANT SELECT ON v_$archived_log TO ZABBIX;GRANT SELECT ON v_$archive_dest TO ZABBIX

Zabbix trigger sets the alarm to

{Oracle-db_name_primary:dataguard_logs.last ()}-{Oracle-db_name_standy:dataguard_logs.last ()} > 1

Note that the following Oracle-db_name_primary matches your own definition

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.