Dbvisit Standby log gap report with heartbeat messageAs part of the Daily scheduler heartbeat message it is possible to include the Dbvisit Standby log gap report. The Dbvisit Standby log gap reports on the: - Archive log gap which is difference between the last archived sequence on the primary and the last applied sequence on the standby database. The archive log gap should be near 0 (except when APPLY_DELAY_LAG_MINUTES is used).
- Transfer log gap which is the difference between the last archived sequence on the primary and the last sequence transferred to the standby server. The transfer log gap should be near 0.
To include the Dbvisit Standby archive and transfer log gap report in the daily heartbeat message set: SEND_LOG_GAP_WITH_HEARTBEAT=Yes In the Dbvisit Database Configuration (DDC) file. Dbvisit Standby will start the standby database if the standby database is not running and AUTO_START_STANDBY_DB = Yes. Email modesThere are two modes for emailing on the primary server: - SUCCESSMAIL = Yes. This will send an email every time that Dbvisit Standby transfers or applies an archive on the primary server. This setting is usually set at the beginning of an installation to ensure that Dbvisit Standby is processing correctly.
- SUCCESSMAIL = No. This will only send an email if an error has occurred on the primary server. No email is good news. However a heartbeat email will still be sent at the start of everyday to ensure that the email notification is functioning correctly.
There are two modes for emailing on the standby server: - SUCCESSMAIL_DR = Yes. This will send an email every time that Dbvisit Standby transfers or applies an archive on the standby server. This setting is usually set at the beginning of an installation to ensure that Dbvisit Standby is processing correctly.
- SUCCESSMAIL_DR = No. This will only send an email if an error has occurred on the standby server. No email is good news. However a heartbeat email will still be sent at the start of everyday to ensure that the email notification is functioning correctly.
Email addressThe email addresses are specified by the ADMINS and SUCCESS_MAILTO parameters in the DDC file. Multiple email addresses can be separated with a comma. All mail configurations are specified in the Dbvisit Standby Database Configuration (DDC) file. If SUCCESS_MAILTO is not set, all emails notifications that Dbvisit Standby sends go to ADMINS. If SUCCESS_MAILTO is set to a valid email address and SUCCESSMAIL is set to Y then: - All error messages and warnings still always go to ADMINS:
- Warnings sent by AMM module
- Alert on archive log gap sequence if it exceeds the threshold (archive or transfer)
- All error messages
- Messages sent by running dbv_functions
- Warning when no new logs found on the primary server to transfer to the standby
- Warning that a previous instance of Dbvisit Standby is still running
- Warning that a required archive log not found on standby database
- Notifications of successful completion of CSD with a trace file attached
- And the following messages go to SUCCESS_MAILTO: - Notification of successful completion of Dbvisit Standby run on the primary to transfer logs
- Notification of successful completion of Dbvisit Standby run on the standby to apply logs
- Heartbeat messages
- Log gap report
If SUCCESS_MAILTO is set to a valid email address but SUCCESSMAIL is set to N then the following type of messages will not be sent at all: - Warning when no new logs found to transfer (even when ALERT_ON_WARNING is set)
- Warning that a previous instance of Dbvisit Standby is still running
- Warning that a required archive log not found on standby database
- Notification of successful completion of Dbvisit Standby run on the primary to transfer logs
- Notification of successful completion of Dbvisit Standby run on the standby to apply logs
|