CONFIG

This procedure updates a value in the config table.

Note:

Do not perform parameter changes for the Recovery Appliance unless so instructed by Oracle Support.

Changes made to the config table are tracked, as well as default values, which are the "best values" that the Recovery Appliance is shipped with.

Syntax

PROCEDURE config(
   p_name VARCHAR2,
   p_value VARCHAR2,
   comments IN VARCHAR2 DEFAULT NULL);

Parameters

Table 22-6 CONFIG Parameters

Parameter Description

Parameter	Description
`p_name`	The parameter to update. Possible parameters are: `check_files_days` The frequency with which the Recovery Appliance runs the metadata consistency check in the background. The default frequency is 7 days. `crosscheck_db_days` The frequency with which the Recovery Appliance performs crosschecks of the recovery catalog to reflect actions in tape libraries or downstream Recovery Appliances. The default frequency is 1 day. `optimize_chunks_days` The frequency with which the Recovery Appliance performs background re-ordering of blocks in the delta store to reduce disk reads required for restore operations. The default frequency is 7 days. `group_log_max_count` These are the maximum number of archive logs that are grouped into a single backup before being written to tape. The default is 1, which is equivalent to turning it off. `group_log_backup_size_gb` This is the maximum size allowed for an archive log backup created with archive log grouping. the default is 256 GB. `validate_metadata_days` The frequency with which the Recovery Appliance performs background metadata validation. The default frequency is 7 days. `validate_db_days` The frequency with which the Recovery Appliance performs background validation of backup pieces. The default frequency is 7 days. `percent_late_for_warning` The percent threshold at which the Recovery Appliance posts warnings for incomplete background operations. For example, if `validate_db_days` is 7 and the `percent_late_for_warning` is `50`, then the Recovery Appliance records a warning in the incident log when a database has gone 10.5 (or 7 + ((50/100)*7)) days without being validated. The default is `100` percent. `network_chunksize` The message size that the Recovery Appliance uses for transferring backups between itself and protected databases. It is also used for replication. The default is 128 MB. All protected databases use this value to determine the unit size in which to send or read backups. For example, if a protected database backup is 1 TB, then the SBT library sends the backup data to the Recovery Appliance in units of `network_chunksize`. This technique is an optimization that enables the Recovery Appliance to restart the data transfer faster if a failure occurs.
`p_value`	The new value for the parameter.
`comments`	Optional user supplied comment describing reason for executing this command.

p_name

The parameter to update. Possible parameters are:

check_files_days

The frequency with which the Recovery Appliance runs the metadata consistency check in the background. The default frequency is 7 days.

crosscheck_db_days

The frequency with which the Recovery Appliance performs crosschecks of the recovery catalog to reflect actions in tape libraries or downstream Recovery Appliances. The default frequency is 1 day.

optimize_chunks_days

The frequency with which the Recovery Appliance performs background re-ordering of blocks in the delta store to reduce disk reads required for restore operations. The default frequency is 7 days.

group_log_max_count

These are the maximum number of archive logs that are grouped into a single backup before being written to tape. The default is 1, which is equivalent to turning it off.

group_log_backup_size_gb

This is the maximum size allowed for an archive log backup created with archive log grouping. the default is 256 GB.

validate_metadata_days

The frequency with which the Recovery Appliance performs background metadata validation. The default frequency is 7 days.

validate_db_days

The frequency with which the Recovery Appliance performs background validation of backup pieces. The default frequency is 7 days.

percent_late_for_warning

The percent threshold at which the Recovery Appliance posts warnings for incomplete background operations. For example, if validate_db_days is 7 and the percent_late_for_warning is 50, then the Recovery Appliance records a warning in the incident log when a database has gone 10.5 (or 7 + ((50/100)*7)) days without being validated. The default is 100 percent.

network_chunksize

The message size that the Recovery Appliance uses for transferring backups between itself and protected databases. It is also used for replication. The default is 128 MB.

All protected databases use this value to determine the unit size in which to send or read backups.

For example, if a protected database backup is 1 TB, then the SBT library sends the backup data to the Recovery Appliance in units of network_chunksize. This technique is an optimization that enables the Recovery Appliance to restart the data transfer faster if a failure occurs.

p_value

The new value for the parameter.

comments

Optional user supplied comment describing reason for executing this command.