Log_archive_dest_state_9:
Description: Identify the nearest user-defined status of the specific log archive target.
Value range: Enable - If the target property is valid, enable archive log target; Defer - Even if the target property is valid, delay processing archive log target; or Alternate, delay processing archive log target, until another target failure This goal is automatically enabled (provided that the properties of the alternate target must be valid).
LOG_ARCHIVE_START:
Note: N is applicable only in the case where the database is in the Archive Log Mode. It specifies that the redo log is automatically replicated. The recommended value is true, that is, the automatic archive is performed;
Otherwise, you need to manually intervene, use
The ALTER System Archive Log ... command to block routines hang.
Value range: True | False
Default: False
Log_archive_duplex_dest:
Description: Specifies another archive target outside log_archive_dest. In Oracle8i Enterprise Edition, this parameter is
Log_archive_Dest_n is replaced.
Value range: A NULL string, or any valid path or device name, except for the original partition.
Default: null
LOG_ARCHIVE_FORMAT:
Description: log_archive_format is useful if the database is in the "archive log" mode. Text string and variable% s (log serial number)
And% T (thread number) is used in conjunction with the unique file name of each archive reform log file. This string is attached to
Log_archive_dest parameter.
Value range: Any valid file name.
Default: Depending on the operating system
LOG_ARCHIVE_MAX_PROCESSES:
Description: Specifies the number of ARCH processes required. If log_archive_start = true, this value can be evaluated at the routine startup;
You can also evaluate when the ARCH process is called by SQL * Plus or SQL syntax.
Value range: 1 - 10 (including endpoint) any integer.
Default: 1
Log_archive_dest_2:
Description: Five local (specified location) or remote (specifying service) destination location,
Archive reform log files can be replicated at these target locations. This parameter is only valid in the Enterprise Edition Oracle8i database or a higher version of the database.
Value range: syntax (null_string | service = tnsnames-service | location = Directory-Spec) [MANDATORY | OPTIONAL] [Reopen = INTEGER]
Default: null
LOG_ARCHIVE_MIN_SUCCEED_DEST:
Note: The minimum number of targets that must be copied to by defining the minimum number of targets that must be copied. This value should be greater than or equal to log_archive_dest_n
The number of MANDATory targets.
Value range: 1 - 5 (if used in common use with log_archive_duff_duplex_dest, limit at 1-2).
Default: 1
LOG_ARCHIVE_TRACE:
Description: Controls the output generated by the archive log process. This process can be started in the following manner
ARCN background process (specified as ARCN in the output log)
A clear session call reception process (specified in the output log) or
Remote File Server (RFS) process of "Managed Birage Database".
Value range:
0: Disable archive log tracking (this is the default setting)
1: Tracking archive of redo log files
2: Tracing archive status of each archive log target
4: Tracking the archive operation phase
8: Tracking archive log target activities
16: Track detailed archive log target activities
32: Tracking archive log target parameters modification
64: Tracking ARCN Process Status Activity
Default: 0
Log_archive_dest_10:
Log_archive_dest_3:
Note: The third of the five local (specified location) or remote (specified service) destination location,
Archive reform log files can be replicated at these target locations. This parameter is only valid in the Enterprise Edition Oracle8i database or a higher version of the database. Value range: syntax (null_string | service = tnsnames-service | location = Directory-Spec) [MANDATORY | OPTIONAL] [Reopen = INTEGER]
Default: null
Log_archive_dest:
Note: The third of the five local (specified location) or remote (specified service) destination location,
Archive reform log files can be replicated at these target locations. This parameter is only valid in the Enterprise Edition Oracle8i database or a higher version of the database.
Value range: syntax (null_string | service = tnsnames-service | location = Directory-Spec) [MANDATORY | OPTIONAL] [Reopen = INTEGER]
Default: null
Log_archive_dest_state_2:
Description: Specifies the availability status of the corresponding archive log target parameter (only log_archive_dest_2). If enabled,
The log target will be archived. If delay, this goal will be excluded from the archive operation until re-enabled.
Value range: enable | Defer
Default: enable
Log_archive_dest_5:
Description: Fifth in five local (specified locations) or remote (specified service) destination location,
Archive reform log files can be replicated at these target locations. This parameter is only valid in the Enterprise Edition Oracle8i database or a higher version of the database.
Value range: grammar (null_string | service = TN
