Versions Compared

Old Version 1

changes.mady.by.user Anton Els

Saved on

compared with

New Version 2

changes.mady.by.user Anton Els

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

 

THRESHOLD

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

are

:

Yes = Turn on AMM on
  • Yes
or No

  • Enable AMM module on the standby server.

  • No
= Turn off

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

To disable this setting, set to 0.
If you are not sure, set to 7.
Example:
    DAYS_TO_KEEP_ARCHDEST = 7
NUM_ARCHDEST_TO_KEEPSpecifies the number of archive log files to keep on the standby server.
Log files greater than this number will be removed (oldest first)
Note

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

0 (disable)

7.

Example:

    NUM_ARCHDEST

DAYS_TO_KEEP

= 0

_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

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

The log files WILL have been applied to the standby database.
(
Note

There is no verification that these log files have been backed up

).
Values are Yes or No
Yes =

, 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

 

Note

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.

Note

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