Dataguard transport time


Job details

Name: Dataguard transport time
Platform: Oracle
Category: Cluster and Replication
Description: Checks refresh date of scheduled jobs in refresh group(s).
Long description:
Version: 1.0
Default schedule: 10m
Requires engine install: No
Compatibility tag: .[type=‘instance’ & databasetype=‘oracle’]

Parameters

Name Default value Description
warning_delay_min 2 Warning status if redo log transport is more than x minutes delayed
alarm_delay_min 5 Alarm status if redo log transport is more than x minutes delayed

Job Summary

select 60 * extract(hour from to_dsinterval(value)) + extract(minute from to_dsinterval(value)) as "Transport lag in min" from sys.v$dataguard_stats where name like 'transport lag';

Technical Details

Attribute Description
Name Oracle Dataguard transport time noschema
Version 1.0
Company dbWatch.com
Group com.dbwatch.job
Artifact ID oracle_noschema_dataguard_transport_time
Category Cluster and Replication
Instance Requirement False
Express Install True
Compatibility Oracle Data Guard instances configured as physical standbys

Configuration Parameters

Schedule and Frequency

Output Evaluation

Reporting