1.184 LOG_ARCHIVE_MIN_SUCCEED_DEST
LOG_ARCHIVE_MIN_SUCCEED_DEST
defines the minimum number of destinations that must succeed in order for the online logfile to be available for reuse.
Property | Description |
---|---|
Parameter type |
Integer |
Default value |
|
Modifiable |
|
Modifiable in a PDB |
Yes |
Range of values |
1 to 10 if you are using 1 or 2 if you are using |
Basic |
No |
If you are using the LOG_ARCHIVE_DEST_
n
parameters and automatic archiving is enabled, then the value of this parameter cannot exceed the number of enabled, valid destinations specified as MANDATORY
plus the number of enabled, valid destinations that are configured with the OPTIONAL
and LOCATION
attributes.
If you are using LOG_ARCHIVE_DEST
and LOG_ARCHIVE_DUPLEX_DEST
and automatic archiving is enabled, a value of 1
specifies that the destination specified in LOG_ARCHIVE_DEST
must succeed. A value of 2
specifies that the destinations specified in both parameters must succeed.
If the value of this parameter is less than the number of enabled, valid MANDATORY
destinations, this parameter is ignored in favor of the MANDATORY
destination count. If the value is more than the number of enabled, valid MANDATORY
destinations, then some of the enabled, valid destinations configured with the OPTIONAL
and LOCATION
attributes are treated as MANDATORY
.
You can switch dynamically from using the older parameters to the LOG_ARCHIVE_DEST_
n
parameter using ALTER SYSTEM
, as follows:
-
Set
LOG_ARCHIVE_MIN_SUCCEED_DEST
to1
. -
Set the value of
LOG_ARCHIVE_DEST
andLOG_ARCHIVE_DUPLEX_DEST
to the null string. -
Set the desired number of destinations for the
LOG_ARCHIVE_DEST_
n
parameters. -
Reset
LOG_ARCHIVE_MIN_SUCCEED_DEST
to the desired value.
See Also:
-
Oracle Database Administrator’s Guide for more information on setting this parameter
-
"LOG_ARCHIVE_DEST_n", "LOG_ARCHIVE_DUPLEX_DEST", and "V$ARCHIVE_DEST" for information on related parameters