LOGARCHIVEMINSUCCEEDDEST=n - Definition - Oracle Redo Log

Q.  Which parameter uses all MANDATORY destinations plus some number of non-standby OPTIONAL destinations to determine whether LGWR can overwrite the online log?
- Published on 19 Oct 15

a. LOG_ARCHIVE_DEST_n
b. LOG_ARCHIVE_MIN_SUCCEED_DEST=n
c. Both A & B
d. None of the above

ANSWER: LOG_ARCHIVE_MIN_SUCCEED_DEST=n
 

    Discussion

  • Nirja Shah   -Posted on 24 Sep 15
    - The optional initialization parameter LOG_ARCHIVE_MIN_SUCCEED_DEST=n determines the minimum number of destinations to which the database must successfully archive a redo log group before it can reuse online log files.

    - The default value is 1.

    - Valid values for n are 1 to 2 if you are using duplexing, or 1 to 10 if you are multiplexing.

    - The LOG_ARCHIVE_DEST_n parameter lets you specify whether a destination is OPTIONAL (the default) or MANDATORY.

    - The LOG_ARCHIVE_MIN_SUCCEED_DEST=n parameter uses all MANDATORY destinations plus some number of non-standby OPTIONAL destinations to determine whether LGWR can overwrite the online log.

    - The following rules apply:
    1. Omitting the MANDATORY attribute for a destination is the same as specifying OPTIONAL.
    2. You must have at least one local destination, which you can declare OPTIONAL or MANDATORY.
    3. When you specify a value for LOG_ARCHIVE_MIN_SUCCEED_DEST=n, Oracle Database will treat at least one local destination as MANDATORY, because the minimum value for LOG_ARCHIVE_MIN_SUCCEED_DEST is 1.
    4. If any MANDATORY destination fails, including a MANDATORY standby destination, Oracle Database ignores the LOG_ARCHIVE_MIN_SUCCEED_DEST parameter.
    5. The LOG_ARCHIVE_MIN_SUCCEED_DEST value cannot be greater than the number of destinations, nor can it be greater than the number of MANDATORY destinations plus the number of OPTIONAL local destinations.
    6. If you DEFER a MANDATORY destination, and the database overwrites the online log without transferring the archived log to the standby site, then you must transfer the log to the standby manually.

    - If you are duplexing the archived logs, you can establish which destinations are mandatory or optional by using the LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST parameters.

    - The following rules apply:
    1. Any destination declared by LOG_ARCHIVE_DEST is mandatory.
    2. Any destination declared by LOG_ARCHIVE_DUPLEX_DEST is optional if LOG_ARCHIVE_MIN_SUCCEED_DEST = 1 and mandatory if LOG_ARCHIVE_MIN_SUCCEED_DEST = 2.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)