LOGARCHIVEDEST maximum of two locations & primary archive destination - Oracle Redo Log

Q.  Which parameter is used to specify a maximum of two locations,used to specify a primary archive destination?
- Published on 30 Jul 15

a. LOG_ARCHIVE_DEST
b. LOG_ARCHIVE_DUPLEX_DEST
c. LOG_ARCHIVE_FORMAT
d. None of the above

ANSWER: LOG_ARCHIVE_DEST
 

    Discussion

  • Nirja Shah   -Posted on 24 Sep 15
    - To specify a maximum of two locations, use the LOG_ARCHIVE_DEST parameter to specify a primary archive destination and the LOG_ARCHIVE_DUPLEX_DEST to specify an optional secondary archive destination.

    - All locations must be local.

    - Whenever the database archives a redo log, it archives it to every destination specified by either set of parameters.

    - Perform the following steps to use this method:

    1. Use SQL*Plus to shut down the database.

    SHUTDOWN

    2. Specify destinations for the LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST parameter (you can also specify LOG_ARCHIVE_DUPLEX_DEST dynamically using the ALTER SYSTEM statement). For example, enter:

    LOG_ARCHIVE_DEST = '/disk1/archive'
    LOG_ARCHIVE_DUPLEX_DEST = '/disk2/archive'

    3. Set the LOG_ARCHIVE_FORMAT initialization parameter.

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.)