Versions Compared

Key

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

The Dbvisit Standby Archive Log Management Module fully automates the management and monitoring of the Oracle archive log space on either the primary, standby server or both. Unlike the Oracle database files location, the Oracle archive logs location needs to be monitored and managed constantly to ensure the database continues its optimal operation. If the disk space available to Oracle archive logs is used up, the whole database will "freeze" and not allow any update or insert operation.

...

Follow the on-screen instructions to install AMM or please see the  Dbvisit Standby Archive log Management Module (AMM) setup section for description of each step.

Image ModifiedHome > Setup > Update Dbvisit > Update Dbvisit Configuration. Choose the AMM settings to update and click on Save Configuration.

Dbvisit Standby Archive Log Management Module variables

The main variables that control the Dbvisit Standby Archive Log Management Module (AMM) processing for the primary server are listed here:

Office Excel
nameWorkbook2.xlsx
row17

 Primary Archive log Management Module (AMM) 

The variables that control the Dbvisit Standby Archive Log Management Module (AMM) processing for the standby server are listed here: Standby Archive log Management Module (AMM)

Note
titleNote
  1. Only the variables for the primary server are shown. The standby server variables work exactly the same as the primary server variables. The standby server variables have the word DEST instead of SOURCE.
  2. In normal circumstances either variable DAYS_TO_KEEP_ARCHSOURCE or NUM_ARCHSOURCE_TO_KEEP will be used, but not both.
  3. The variables DAYS_TO_KEEP_ARCHSOURCE and NUM_ARCHSOURCE_TO_KEEP can be turned off by setting them to 0.
  4. The variable THRESHOLD_ARCHSOURCE can be turned off by setting it to 100.

...