Zabbix通过Orabbix监控Oracle DataGuard

　　

甲骨文通过DataGuard作为异地备份,可以通过监控主备的归档日志序列之差


vim orabbix/conf/查询。道具

在开头的QueryList添加

QueryList=存档,审计,dbblockgets, dbconsistentgets, dbhitratio, dbphysicalread, hitratio_body, hitratio_sqlarea, hitratio_table_proc \ 　　lio_current_read、门锁、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_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,正常运行时间,dbfilesize, dbsize,过程,max_process, used_session, max_session, active_session, archive_size,

<强>


dgstatus.Query=select 数(0),得到v $ archive_dest  where 状态=坝行А? 　　dataguard_logs.Query=select  max(#)序列,得到v $ archived_log




然后在数据库中进行授权,查询相关表的权限

GRANT  select 提醒v_ archived_log 美元;用ZABBIX; 　　GRANT  SELECT 提醒v_ archive_dest 美元;用ZABBIX;


ZABBIX触发器设置报警为

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

注意以下的Oracle-db_name_primary与自己定义匹配



Zabbix通过Orabbix监控Oracle DataGuard