Versions Compared

Old Version 4

changes.mady.by.user Anna Macnaughtan

Saved on

compared with

New Version 5

changes.mady.by.user Anton Els

Saved on

Key

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

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

 

NUM_TO_KEEPBACKUPCOUNTFRA_

Variable Name

Meaning

ARCHSOURCE_BACKUP_COUNT

Specify the number of times an archive log has to be backed up by RMAN before Dbvisit Standby deletes it from the primary server.

To disable this setting, set to 0 which is the default value.

Example:

ARCHSOURCE_BACKUP_COUNT = 0

 

ARCHSOURCE_MANAGEMENT

Specifies

Specify if the AMM module to manage the archive log files

is

are turned on or off on the primary server.

Possible Values

are Yes or NoYes = Turn on AMM

:

  • Yes (default)
    Enable the AMM module on primary server.

  • No
= Turn off AMM

  • Disable the AMM module on primary server.
If you are not sure, set to Yes.

Example:

   

ARCHSOURCE_MANAGEMENT= Yes

 

DAYS_TO_KEEP_ARCHSOURCE

Specifies

Specify the number of days to keep the Oracle log files on the primary server.

After this

If this value (in days) are reached, the log files will be removed from the server.

To disable this setting, set to 0

.If

, if you are not sure, set to 7.

Note

Make sure you have sufficient disk space to store the archive logs.

See also the ARCHDEST parameter under the standby server variable section for more detail

 

Example:

   

DAYS_TO_KEEP_ARCHSOURCE = 7

 

DELETE_ARCHSOURCE

Specifies the number of

Specify if archive log files

to keep

should be deleted once the percentage threshold (THRESHOLD_ARCHSOURCE) on the primary server

.
Log files greater than this number will be removed (oldest first).
To disable this setting, set to 0.

is reached.

Once the threshold is reached oldest archive log files are deleted first. 

Note

There is no verification that these log files have been backed up. Dbvisit Standby does not perform backups, this should be configured outside the Dbvisit Standby product.

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 archive log files will be deleted). 

If you are not sure, set to

0 (disable)

No.

Example:

    NUM_ARCHSOURCE

DELETE_ARCHSOURCE = No

 

Note

This setting has no influence whether (archive) log files are deleted for DAYS_TO_KEEP

= 0

_ARCHSOURCE or NUM_ARCHSOURCE_

TO_

Specifies the number of times an archive log has to be backed up by RMAN before Dbvisit Standby deletes it from the primary server.
To disable this setting, set to 0.
If you are not sure, set to 0.
Example:
    ARCHSOURCE_BACKUP_COUNT = 0

KEEP.

These settings will delete (archive) log files once the percentage threshold is met.

FRA_THRESHOLD_ARCHSOURCE

Specifies the threshold in percentage (%) of how much

disk

FRA (flash/fast recovery area) space may be taken up by the

Oracle

archive log files on disk before an alert is triggered on the primary server.

A value of 80 means at 80%

disk space full

FRA space threshold is reached, an alert will be triggered.

Please specify threshold as an integer. 

Example:

   FRA_ THRESHOLD_ARCHSOURCE = 80

 

NUM_ARCHSOURCE_TO_KEEP

Specifies the number of archive log files to keep on the primary 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

80

0 (disable).

Example:

   

THRESHOLD

NUM_ARCHSOURCE

= 80

_TO_KEEP = 0

 

THRESHOLD_ARCHSOURCE

Specifies the threshold in percentage (%) of how much

FRA

disk space may be taken up by the

Oracle

archive log files on disk before an alert is triggered on the primary server.

A value of 80 means at 80%

FRA

space

full

threshold is reached, an alert will be triggered.

Please specify threshold as an integer. 

If you are not sure, set to 80.

Example:

   FRA_

    THRESHOLD_ARCHSOURCE = 80

DELETE_ARCHSOURCESpecifies if (archive) log files should be deleted once the percentage threshold (THRESHOLD_ARCHSOURCE) on the primary server is reached.
Once the threshold is reached oldest (archive) log files are deleted first. 
The log files WILL have been transferred to the standby server.

(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_ARCHSOURCE = No
This setting has no influence whether (archive) log files are deleted for DAYS_TO_KEEP_ARCHSOURCE or NUM_ARCHSOURCE_TO_KEEP.
These settings will delete (archive) log files once the percentage threshold is met.