Standby Archive log Management Module (AMM)
Please see Archive log Management Module (AMM) for more information on AMM.
| Variable Name | Meaning |
|---|---|
| ARCHDEST_MANAGEMENT | Specifies if the AMM module to manage the archive log files is turned on or off on the standby server. Values are Yes or No
If you are not sure, set to Yes. Example: ARCHDEST_MANAGEMENT= Yes |
| DAYS_TO_KEEP_ARCHDEST | Specifies the number of days to keep the Oracle log files on the standby server. |
| After this the log files will be removed from the server. | |
| To disable this setting, set to 0. | |
| If you are not sure, set to 7. | |
| Example: | |
| DAYS_TO_KEEP_ARCHDEST = 7 | |
| NUM_ARCHDEST_TO_KEEP | Specifies the number of archive log files to keep on the standby server. |
| Log files greater than this number will be removed (oldest first). | |
| To disable this setting, set to 0. | |
| If you are not sure, set to 0 (disable). | |
| Example: | |
| NUM_ARCHDEST_TO_KEEP = 0 | |
| THRESHOLD_ARCHDEST | Specifies the threshold in percentage (%) of how much disk space may be taken up by the Oracle log files on disk before an alert is triggered on the standby server. |
| 80 means at 80% disk space full an alert will be triggered. | |
| Please specify threshold as an integer. | |
| If you are not sure, set to 80. | |
| Example: | |
| THRESHOLD_ARCHDEST = 80 | |
| DELETE_ARCHDEST | Specifies if (archive) log files should be deleted once the percentage threshold (THRESHOLD_ARCHDEST) on the standby server is reached. |
| Once the threshold is reached oldest (archive) log files are deleted first. | |
| The log files WILL have been applied to the standby database. | |
| (There is no verification that these log files have been backed up). | |
| Values are Yes or No | |
| Yes = Let Dbvisit Standby delete archive log files once percentage threshold is met. | |
| No = Dbvisit Standby will only alert when percentage threshold is met (no log files will be deleted). | |
| If you are not sure, set to No. | |
| Example: | |
| DELETE_ARCHDEST = No | |
| This setting has no influence whether (archive) log files are deleted for DAYS_TO_KEEP_ARCHDEST or NUM_ARCHDEST_TO_KEEP. | |
| These settings will delete (archive) log files once the percentage threshold is met. |