Dbvisit - E-Mail Notification Configuration
===
###### tags: `DBVISIT`, `STANDBY`, `ORACLE`, `MAIL`, `SMTP`, `ALARM`


### **1. 登入 Dbvisit Central Console 點選 MANAGE CONFIGURATION**

### **2. 開始編輯配置**

### **3. 啟動Mail寄送功能**

### **4. 設定 mail 寄送方式不使用 SSL/TLS port，並設定 mail port: 25**
**<font color="#dd0000">MAILCFG_SMTP_SERVER & MAILCFG_SMTP_SERVER 必須為空，否則會自動使用SMTP寄送mail</font>**
>IMPORTANT: If you are not using SSL/TLS make sure that "MAILCFG_PROTOCOL" is not set in the DDC file and if it is set it should not have a value:


### **5. 設定收信人**

### **6. 設定 mail 寄送規則**
>* **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 the 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 the 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


### **7. 設定寄信人**


### **8. 設定寄送同步訊息 & 寄送時間**
>**Dbvisit will not necessarily send an email at the exact time specified. Dbvisit will only send the heartbeat email when it is executed.**
Example: If SEND_HEARTBEAT_TIME24=1400, but Dbvisit is not executed until 14:20, then the heartbeat email will be sent at 14:20.


### **9. 儲存配置**

### **10. 測試寄送同步訊息**
> ./dbvctl -f send_heartbeat -d EMR