Standby Archive log Management Module (AMM) Settings

This section provides an overview of the variables that can be configured for the AMM module with regards to the Standby Database.

Please see Archive log Management Module (AMM) for more information on AMM.

 

Variables are sorted alphabetically in the table below

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.

Possible Values:

  • Yes
    Enable AMM module on the standby server.

  • No
    Disable AMM module on the standby server.

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.

This is specific to the Dbvisit Standby ARCHDEST location. Please see ARCHDEST in the Standby Variable section.

To disable this setting, set to 0. If you are not sure, set to 7.

Example:

DAYS_TO_KEEP_ARCHDEST = 7

 

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. 

There is no verification that these log files have been backed up, this (backups) is outside the scope of Dbvisit Standby

 

Possible Values:

  • 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.

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 archive log files on disk before an alert is triggered on the standby server.

This parameter is specific to the Dbvisit Standby ARCHDEST location

 

A value of 80 means that if the 80% disk space threshold is reached, an alert will be triggered. If you are not sure, set to 80.

Example:

THRESHOLD_ARCHDEST = 80