|
Index >
ORACLE Server Parameters >
log_archive_min_succeed_dest
log_archive_min_succeed_dest
Oracle 11.1.0:
| Parameter Name: | log_archive_min_succeed_dest
| | Description: | minimum number of archive destinations that must succeed
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 10.2.0:
| Parameter Name: | log_archive_min_succeed_dest
| | Description: | minimum number of archive destinations that must succeed
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 10.1.0:
| Parameter Name: | log_archive_min_succeed_dest
| | Description: | minimum number of archive destinations that must succeed
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 9.2.0:
| Parameter Name: | log_archive_min_succeed_dest
| | Description: | minimum number of archive destinations that must succeed
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 8.1.7:
| Parameter Name: | log_archive_min_succeed_dest
| | Description: | minimum number of archive destinations that must succeed
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 8.0.6:
| Parameter Name: | log_archive_min_succeed_dest
| | Description: | minimum number of archive destinations that must succeed
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 7.3.4:
No such parmeter in Oracle 7.3.4.
Related Error Messages:
ORA-01052: required destination LOG_ARCHIVE_DUPLEX_DEST is not specifiedCause: A valid destination for parameter LOG_ARCHIVE_DUPLEX_DEST was not specified when parameter LOG_ARCHIVE_MIN_SUCCEED_DEST was set to two.Action: Either specify a value for parameter LOG_ARCHIVE_DUPLEX_DEST, or reduce the value for parameter LOG_ARCHIVE_MIN_SUCCEED_DEST to one.
ORA-16020: less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST Cause: With automatic archiving enabled, the number of archive log destinations that could be used for the database was less than the LOG_ARCHIVE_MIN_SUCCEED_DEST parameter value.Action: Either adjust the settings of the log archive destination parameters, or lower the value of LOG_ARCHIVE_MIN_SUCCEED_DEST.
ORA-16028: new %s causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires Cause: With automatic archiving enabled, an attempt was made to change the indicated LOG_ARCHIVE_DEST_n or a LOG_ARCHIVE_DEST_STATE_n parameter (n = 1...10) to a value that reduces the number of archive log destinations to less than the specified LOG_ARCHIVE_MIN_SUCCEED_DEST value.Action: Either select different options for the LOG_ARCHIVE_DEST_n or LOG_ARCHIVE_DEST_STATE_n parameters, or reduce the value for parameter LOG_ARCHIVE_MIN_SUCCEED_DEST.
ORA-16029: cannot change LOG_ARCHIVE_MIN_SUCCEED_DEST, no archive log destinations Cause: An attempt was made to change the LOG_ARCHIVE_MIN_SUCCEED_DEST parameter when there are no archive log destinations.Action: Define one or more log archive destinations using parameters LOG_ARCHIVE_DEST, LOG_ARCHIVE_DUPLEX_DEST, or LOG_ARCHIVE_DEST_n (n = 1...10). Then, change the value of parameter LOG_ARCHIVE_MIN_SUCCEED_DEST.
ORA-16030: session specific change requires a LOG_ARCHIVE_DEST_n destination Cause: The following event caused an incompatibility: Parameter LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST was in use when an attempt was made to change the LOG_ARCHIVE_MIN_SUCCEED_DEST parameter with an ALTER SESSION command.Action: Replace any LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST parameters with LOG_ARCHIVE_DEST_n (n = 1...10) parameters.
ORA-19555: invalid LOG_ARCHIVE_MIN_SUCCEED_DEST parameter value Cause: The value of parameter LOG_ARCHIVE_MIN_SUCCEED_DEST was not set within the valid range.Action: Specify a correct value for parameter LOG_ARCHIVE_MIN_SUCCEED_DEST. If the archive log parameters LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST are in use, set parameter LOG_ARCHIVE_MIN_SUCCEED_DEST to either 1 or 2.
This parameter is documented in the
Oracle Server Reference Guide.
Search for more info about
[ log_archive_min_succeed_dest ]
on the Oracle FAQ.
| 
